Top Tips for Excel

  BACK   Home NEXT | Paint  

Table of Contents


General

  • You can press F2 to edit the active cell.
  • Press TAB to move to the right one cell at a time.
  • Hold down SHIFT and then press TAB to move to the left, one cell at a time.
  • Press ENTER to move the insertion point down one cell at a time.
  • Press CTRL+D to Fill down.
  • Press CTRL+R to Fill to the right.
  • You can start the spelling checker by pressing F7.

Selection

  1. To Select nonadjacent cells or ranges  :

    1. Select the first cell or range.
    2. Hold down CTRL while you select other cells or ranges.

  2. To Select a large range  :

    1. Click the cell at one corner of the range.
    2. Hold down SHIFT while you click the cell at the opposite corner.

  3. To Select cells and their contents on a worksheet :

    • To select the entire worksheet, you can press CTRL+A.
    • To select an entire row or column, click the row or column heading.
    • To select adjacent rows or columns, drag across the row or column headings.

    NOTE :

    1. Highlights do not appear in a printout. If you want to display cells with a highlight when you print a worksheet, you can use formatting features to apply cell shading.
    2. The contents should be in the same cell/column in all sheets.

  4. To indent text in a cell :

    You can use the Increase Indent and Decrease Indent buttons on the Formatting toolbar.

     Top

    A worksheet

  5. To create a new workbook :

    • If you've already opened Excel, click New on the Standard toolbar.
      Or :
      1. On the File menu, click New.
      2. In the New Workbook task pane, click Blank workbook.
      Or :
    • On the Insert menu, click Worksheet.

  6. To move a worksheet :

    1. Right-click the sheet tab of the worksheet you want to move, and then click Move or Copy.
    2. In the Move or Copy dialog box, choose where you want the tab to go, and then click OK.

  7. To rename sheet tabs :

    1. Right-click a sheet tab at the bottom of the window, and then click Rename.
    2. Type the new name, and then click OK.

  8. To add color to sheet tabs :

    1. Right-click the sheet tab at the bottom of the window, and then click Tab Color.
    2. Select the color you want, and then click OK.

  9. You can edit the contents of more than one sheet at a time  :

    & Hold down CTRL while you click the tabs of the sheets you want to edit, and then modify the data.

  10. To delete a worksheet:

    1. Right-click the sheet tab of the sheet you want to delete.
    2. Click Delete, or, on the Edit menu click Delete Sheet.

     Top

    Dates and Numbers

  11. To enter dates :

    Use a slash or a hyphen to separate the parts of a date.
    For example, 7/15/2005 or 16-July-2005.

  12. To increase weekdays, months, dates, or other series :

    Select the first item and then drag the fill handle at the corner.

  13. To increase a single number :

    Hold down CTRL while you drag the fill handle at the corner of the selection.

  14. To enter fractions :

    1. Leave a space between the whole number and the fraction. For example, 1 1/8.
    2. To enter a fraction only, enter a zero first. For example, 0 1/4.

    NOTE :


    If you do not leave a space nor enter a Zero first, the fractions will be 8 Nov and 4 Jan.

  15. Use the fill handle to enter months, days, dates, or numbers :

    1. Select the first cell in the range that you want to fill.
    2. Type the starting value for the series.
    3. Type a value in the next cell to establish a pattern.

    4. How?

      • For example, if you want the series 1, 2, 3, 4, 5..., Type 1 and 2 in the first two cells.
        If you want the series 2, 4, 8..., Type 2 and 4.

    5. Select the cells that contain the starting values.
    6. Drag the fill handle across the range that you want to fill.

     Top

    Wrapping Text

  16. To wrap text that is too long to fit in a cell, and so overlaps the next cell, follow these steps :

    1. Move to cell A1.
    2. Type some long Text.
    3. Press Enter.
    4. Return to cell A1.
    5. Choose Format > Cells from the menu.
    6. Choose the Alignment tab.
    7. Click Wrap Text. Click OK. The text wraps.

  17. To start a new line within a specific point in a cell :

    Click where you want to break the line, and then press ALT+ENTER.

    Insertion

  18. Insert symbols and special characters on a worksheet :

    You can use the Symbol dialog box to enter symbols and characters that are not on your keyboard.
    A-

    Insert a symbol :

    1. On the worksheet, click where you want to insert the symbol.
    2. On the Insert menu, click Symbol.
    3. Click the Symbols tab.
    4. Click the arrow in the Font box, and then click the font that you want in the list.
    5. Click the symbol that you want to insert, and then click Insert.

    B-

    Insert a Unicode character(special character) :

    1. On the worksheet, click where you want to insert the Unicode character.
    2. On the Insert menu, click Symbol.
    3. Click the Symbols tab.
    4. Click the arrow in the Font box, and then click the font that you want in the list.
    5. In the (from box), click Unicode (hex).

    TIP :

    Various Symbols are available for some fonts, such as Arial or Times New Roman, and provide an extended list of language characters, punctuation, and mathematical symbols.

  19. To add bullets to worksheet text, you need to insert a symbol :

    Do one of the following :

    1. On the Insert menu, click Symbol.
    2. On the Symbols tab, in the Font box, click the font that you want to use.
    3. Use the scroll bar to find the symbol that you want to insert.
    4. Click the symbol that you want, click Insert, and then click Close.
    5. To add more bullets, you can copy and paste the first one that you inserted.
    6. Or, if the bullet is in its own cell, you can drag the fill handle to repeat the symbol in adjacent cells.

  20. Delete cells, rows, or columns :

    1. Select the cells, rows, or columns that you want to delete.
    2. On the Edit menu, click Delete.

    TIP :

    1. You can also right-click a selection of cells, rows, or columns, and then click Delete on the shortcut menu.
    2. If needed, you can restore deleted data immediately after deletion. On the Edit menu, click Undo Delete, or press CTRL+Z.

    Headers and Footers

    • Headers and footers are not visible in the normal view.
    • To view a header or footer before printing the spreadsheet, use the Print Preview option.

    NOTE :

    To use Print Preview in Excel, you must have a printer installed on your computer.

    How to add headers and footers to a worksheet:

    1. Choose File > Page Setup.
    2. Select the Header-Footer tab.
    3. Select from the custom header - footer options.
    4. Create the header or footer.
    5. Preview in Print Preview.

  BACK   Home  Top NEXT | Paint