-
Is it possible to add up just the negative (or positive) numbers
in a range?
A. Yes. Use the =SUMIF function to do so. To add only negative
numbers, use =SUMIF(range,<0) To add only positive numbers,
use =SUMIF(range>0)
-
What is AUTOCALC?
A. The AUTOCALC feature allows you to get the results of formulas
without really using formulas.
-
STEPS:
-
Select the cells which have numbers in them.
-
Look at your staus bar -- over on the lower right.
-
Excel should be displaying the sum of the selected values.
-
Right-click on the status bar to select a different operation.
-
How do I center a heading across several columns?
A. Use the Center Across Selection format feature.
-
STEPS:
-
Enter the text in the leftmost column of the range.
-
Select the cell with the text as well as the remaining
columns.
-
Select Format.
-
Select Cells.
-
Click on the alignment tab.
-
Select Center Across Selection from the Horizontal dropdown
list.
-
Click OK.
-
Can I have more than 1 line of text in a cell?
A. Use Alt+ENTER at the end of the line.
-
Is there a way enter numbers with leading zeros?
A. Yes there is. You need to create a custom format:
-
STEPS:
-
Select the cells in which you will be entering these numbers.
-
Select Format.
-
Select cells.
-
Select the Number tab.
-
Look for Category, and then select Custom.
-
In the Type box, enter a series of zeroes and a #. Enter
1 less zero than the maximum number of digits that will
be entered. For instance, if the maximum number of digits
is 5, enter 0000#.
-
Click OK.
-
How do I create a title that will be centered across the page?
A. Type the title in the first column then select the cells across
the page that you want to center it on. Click on the merge and
center tool from the formatting toolbar (this is just to the right
of right alignment).
-
How do I get my column or row headings to print on each page without
manually typing them in?
A. In Excel, these are called titles. Follow the steps below:
-
STEPS:
-
Step 1: Select Page Setup from the File menu.
-
Step 2: Click on the Sheet properties (Sheet tab on top
of dialogue box).
-
Step 3: Click on the little red arrow to the right of
either the column titles or the row titles. Now select
the columns or rows you want for titles and press the
Enter key. Column titles appear at the top of every page,
row titles appear at the left edge of every page.
-
Why do pound symbols appear on my worksheet, ########?
A. This is an indication that the column is not wide enough for
the contents of that cell. Resolve this by selecting the cell
in question, click on the Format menu and point to Column and
move the mouse over and click on AutoFit Selection.
-
When I print, why do I get so many extra blank pages?
A. This common problem happens because there is something on your
spreadsheet that you do not see or did not intend to print (this
could even be the invisible space character). To prevent this,
select the exact range you wish to print, click on the File menu,
point to Print Area and click on Set Print Area.
-
Why does my printout comes out really small?
A. This is usually an indication that "shrink to fit" option from
page setup is chosen. You can leave the feature on. You just must
set your printing area correctly. To prevent this, select the
exact range you wish to print, click on the File menu, point to
Print Area and click on Set Print Area.
|