Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

How do I get Excel to not print blank pages when using outlines

I have several spreadsheets that when I click the upper left hand box to
apply formatting to the whold document such as shows outlines, my document
will print out and then I'll have several pages that are blanket with just
the outlines printing. I have one document that is 5 pages and when I apply
formatting to whole document, 1400 blanks will print out. How do I get rid of
these excess pages>


Post your answer or comment

comments powered by Disqus
I am re-developing a tracking sheet which records the length of system outages over periods of time.

When an outage occurs during, or extends into non-supported times, we are supposed to stop counting the outage time until the next support time kicks in.

So how do I get Excel to recognise and ignore those unsupported hours?

Also, if an outage extends over a few days, how do I get Excel to ignore the unsupported hours for each day, while tallying the time of the outage?

An example runs along these lines:
We provide "core support" from 7am-5pm Mon-Fri only.

A system outage occurs at 4:00pm on a Wednesday night and is not restored until 8:00am the following morning (Thursday).

My sheet needs to return 2 hours (agreed support times), but it currently returns 16 hours.

Also, how do I handle that calculation over multiple days? A normal 3 day outage needs to be tallied as 27 hours, not 72 hour. And that calculation needs to hold true over a weekend as we provide no core support.

Any advice appreciated.

how do I get excel to read open office spreadsheets?

How do I get Excel to correctly add a column of numbers that have each been
rounded to 2 decimals? It seems to always remember the unrounded figures;
therefore, the sum of the column of figures is never correct. It's always off
a few decimal points. This seems an amazing short-coming for a spreadsheet
program. Is there a fix for this problem?

I am creating a set of worksheets analyzed with pivot tables and charts that
track time delays in starting office procedures. Some of the procedures were
begun before the scheduled time. How do I get Excel to show those as
negatives or any other useful format? I am using Excell 2003.

I have used the "concatenate" function to put together data from 4 separate
columns to form a date & time entry in the next column (the original 4
columns came from a .cvs file) on the basis of dd/mm/yyyy hh:mm format.
I have defined the destimation column for 'Custom' Cell Format using the
dd/mm/yyyy hh:mm choice. But Excel does not recognise the information as
date & time, BUT, if I press the Return Key on each individual cell, then
Excel does recognise the contents as a date & time. Then I can go on to
chart my results on a timeline (the whole purpose of the exercise).
The difficulty is that I have >5000 entries with more to add. I don't want
to have to hit the Return key for every indivual cell as this defeats the
purpose of mass copy & paste.
How can I get Excel to accept the concatenated data as a date & time?

I need to know how to get excel to automatically compute the cell values when
i'm changing it to a different number ex: My point threshold is 400, i cahnge
it to 350, how do i make excel automatically convert the right average when
any number is changed

I have used the "concatenate" function to put together data from 4 separate
columns to form a date & time entry in the next column (the original 4
columns came from a .cvs file) on the basis of dd/mm/yyyy hh:mm format.
I have defined the destimation column for 'Custom' Cell Format using the
dd/mm/yyyy hh:mm choice. But Excel does not recognise the information as
date & time, BUT, if I press the Return Key on each individual cell, then
Excel does recognise the contents as a date & time. Then I can go on to
chart my results on a timeline (the whole purpose of the exercise).
The difficulty is that I have >5000 entries with more to add. I don't want
to have to hit the Return key for every indivual cell as this defeats the
purpose of mass copy & paste.
How can I get Excel to accept the concatenated data as a date & time?

this works:

but if I put 201012 into cell A3, this doesn't done work:

when i do Evaluate Formula on the 2nd one...I see that there are double quotes about the 201012 that was pulled from
A3...like so:

and as such, all the 201012s pulled from the MonthFinsh row come back as FALSE when compared to "201012"  (ie,
201012="201012" ) where as they come back as TRUE when I hard code 201012 as it shows up as 201012=201012.

how do i get Excel to not put those quotes around the number?

I am trying to make a spreadshet for a Nascar fantasy league but Excel does
not total blank cells. How do I get Excel to make the blank cells equal 0 so
they will total properly?

In our timesheet, we enter start time and end time. How do I get Excel to
return # of hrs. worked? If is use: (d11-c11) a decimal fraction is returned.
ie. .21 for 8:00 am to 1m. How do I get it to return 5 hrs.?

Thanks

How do I get excel to search through a range of numbers for example the
equation that I would like to complete is IF(B5=1.99 - 1.5,10) but excell
thinks that 1.99 - 1.5 is 1.99 minus 1.5. Please help.

Matthew

How can I get excel to apply values in a cell using an IF function before or
after dates displayed in another cell? It will allow me to use a
datevalue(...)= but not datevalue(...)> or datevalue(...)

I really feel stupid. Excel has brought me this low. All I'm trying to do is input information, in columns, in a "2/1" format. So the column will look like:

2/1
2/1
2/1
2/1
3/1
3/1
3/1
3/1...

and so on, and so on. Don't worry about what it means, it makes sense to me lol. But every time I do that, Excel replaces it with:

1-Feb
1-Feb
1-Feb
1-Feb
1-Mar
1-Mar...

How do I get Excel to stop autoreplacing my information with dates?! Oh, and my info in my profile is incorrect, I have Excel 2007.

How can I get excel to apply values in a cell using an IF function before or
after dates displayed in another cell? It will allow me to use a
datevalue(...)= but not datevalue(...)> or datevalue(...)<.

In our timesheet, we enter start time and end time. How do I get Excel to
return # of hrs. worked? If is use: (d11-c11) a decimal fraction is returned.
ie. .21 for 8:00 am to 1:pm. How do I get it to return 5 hrs.?

Thanks

Command buttons created in Excel 2000 do not show up in 2003 version. How do
I get them to show?

In Excel, how do you get it to not automatically round my dollars up or down.

Ex: I am summing a group of numbers and the total equals $598.6780. I want
to show only 2 decimal places but do NOT want Excel to round the amount up.
I want the answer to show me $598.67 not $598.68.

How can I get excel to auto alphabeticalize my spread sheet???

I have a lot of spread sheets that have tons of name that are not in
order and I was wondering if I could save myself hours of work by having excel do it for me. By clicking on something or whatever.

Please help me and please explain what I could to make this possible.

Thank you all in advance.

How do I get a "&" to print in a header?

I have a check list in excel and wish to use check marks to siginify
completion of individual fields. How do I get excel to insert a checkmark
into a field when I double click that field?

I am entering the date (8/25/2005) in a cell that is date-formatted.
However, once entered the cell always displays 1/1/1900 (Excel's embedded
calendar start date), i.e. it doesn't display the date I entered. How do I
get it to display teh date I entered?

How do I get a "&" to print in a header?

If I create a spreadsheet that is wider than one page, how do I get it to all
print on one page? Used to have this functionality on another computer but
can't seem to find it with this software

When using a barcode scanner, I am scanning UPC's into the Crtl F function to
find the UPC in a spreadsheet. When I scan the UPS it is readung it as a
whole number and not recognising the 0 at the beginning of the barcode. How
do I make Excell read it as a number with the 0 at the beginning?


No luck finding an answer? You could always try Google.