2-Introduction to MS Excel
Editing a Cell
• Double-click a cell to edit the data in it.
• Click the cell, and then edit the data in the formula bar.
• The worksheet now says Edit in the status bar).
• To save the changes in the cell, press ENTER or TAB
• If you are editing and made a mistake, you can press ESC. The changes will
not take place.
• Sometimes a cells displays ##### even when you know entered data in it.
• This means that the cell is not wide enough to display the number (or date).
• Double-click the right column boundary at the top to make more room. Also you can
drag the right column boundary as in the example.
• Every cell can have several formats in Excel.
• The most common type for a cell are:
– General (no format)
– Numbers (1, 394, 22.3)
– Currency ($2.43)
– Percentage (33.4%)
Format Cells dialog
• Right click on a cell then select the Format Cell option.
• This dialog box allows you to change the formatting of any selected cell.
• You might want to eventually print your worksheet.
• If you don’t put any cell borders, all you will see is the content of the cells (numbers,
Adding Cell Borders
• You can add many different types of cell borders by clicking the Borders button in the
• Simply click on the cell or cells that you wish to add a border to, then apply any border
• If you want more option, use Format Cell dialog, Border tab (as we showed before)
Printed Example With Borders
• If we print the same example as before after adding borders we would get the following.
Changing the Cell Format
• You can also change the format by using the Numbers panel of the Home tab (it will
show a preview of what the cell will look like in that format.
Removing Cell Format
• If you want to remove all cell formatting that you added (cell format, text size, text font,
text color, etc) on a cell, select it and use the Clear Formatting button in the Editing panel
of the Home tab.
Changing the Font
• You can change the font type, size, color, etc, using the same method as with Word or
- 1 - • You should first select the cells
• Sometimes you need another row to hold additional information.
• Click any cell in the row immediately below where you want the new row to appear.
• Then in the Home tab, click the Insert button of the Cells panel.
• Then click Insert Sheet Rows.
• Before inserting the row:
• After inserting the row:
• Click any cell in the column immediately to the right of where you want the new
column to appear.
• Then in the Home tab, click the Insert Button of the Cells panel.
• Then click Insert Sheet Columns
• A very useful feature in Excel is the Sort & Filter button of the Home tab.
• This button allows you to sort different types of data in ascending (increasing) or
descending (decreasing) order.