The Mid-Hudson Regional Information Center


Excel

 


  1. 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)

  2. What is AUTOCALC?
    A. The AUTOCALC feature allows you to get the results of formulas without really using formulas.
    STEPS:
    1. Select the cells which have numbers in them.
    2. Look at your staus bar -- over on the lower right.
    3. Excel should be displaying the sum of the selected values.
    4. Right-click on the status bar to select a different operation.

  3. How do I center a heading across several columns?
    A. Use the Center Across Selection format feature.
    STEPS:
    1. Enter the text in the leftmost column of the range.
    2. Select the cell with the text as well as the remaining columns.
    3. Select Format.
    4. Select Cells.
    5. Click on the alignment tab.
    6. Select Center Across Selection from the Horizontal dropdown list.
    7. Click OK.

  4. Can I have more than 1 line of text in a cell?
    A. Use Alt+ENTER at the end of the line.

  5. Is there a way enter numbers with leading zeros?
    A. Yes there is. You need to create a custom format:
    STEPS:
    1. Select the cells in which you will be entering these numbers.
    2. Select Format.
    3. Select cells.
    4. Select the Number tab.
    5. Look for Category, and then select Custom.
    6. 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#.
    7. Click OK.

  6. 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).

  7. 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:
    1. Step 1: Select Page Setup from the File menu.
    2. Step 2: Click on the Sheet properties (Sheet tab on top of dialogue box).
    3. 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.

  8. 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.

  9. 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.

  10. 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.

[Back to previous page]

Back to FAQ page

Can't find an answer to your question? Want to submit one to us?
Click here and we will post an answer to your question as quickly as possible.

These pages ©1996-2005 Mid-Hudson Regional Information Center, .
All rights reserved.