Contents
The Excel 2007 Interface
Keyboard Shortcuts in Excel 2007
How to Create New Spreadsheets and Open Existing Spreadsheets
How to Save and Close an Excel Spreadsheet
How to Navigate an Excel 2007 Spreadsheet
Basic Cell Operations in Excel
Excel Formulas and Functions
How to Use Excel’s Fill Feature
How to Sort Data in Excel
How to Format Cells in Excel
How to Format Excel Spreadsheets
How to Add Charts or Graphics to Excel Spreadsheets
How to Print Excel Spreadsheets
|
 |
 |
 |
|
How to Format Excel Spreadsheets
In addition to formatting individual cells or cell ranges, you can also format Excel spreadsheets in a variety of ways.
How to Adjust Column Width or Row Height
You can adjust the width of a column or the height of a row either automatically or manually.
- Automatically: Adjusting the column width or row height automatically resizes the column or row to the smallest possible width or height that can still accommodate the cell with the largest data entry in that row or column. To do this, point your cursor at the right edge of the column heading or bottom of the row heading and double-click.
- Manually: Adjusting the column width or row height manually takes more time but gives you more control. To adjust a column or row manually, click at either edge of the column heading or row heading, then drag to the size you want.
If you see a cell filled with # signs, it means that the number is too long to fit in the column. Once you’ve increased the column width enough to accommodate the number, the number will appear.
How to Insert Cells, Columns, or Rows
You can add an additional cell, a range of cells, or entire columns or rows to your spreadsheet.
How to Add Cells or Ranges of Cells
To add a single cell or a range of cells to your spreadsheet, first select a cell or range where you’d like to insert the new cell or range. Then either right-click the selected cell(s) and choose Insert or click the drop-down arrow beneath the Insert icon 
at Home > Cells.
at Home > Cells. An Insert dialog box will open; it gives you the choice to make room for the new cells by shifting cells either to the right or down. Make your selection, then click OK.
How to Add Rows or Columns
You can add a row or column by following the same steps you’d use to add a cell or range but selecting Entire row or Entire column from the dialog box before clicking OK.
Alternatively, you can select a column or row by clicking on its heading, then right-clicking and choosing Insert. Excel will automatically insert a column to the left of the column you selected or a row above the row you selected. To insert multiple columns or rows, select the number of columns or rows you’d like to insert, then right-click and choose Insert.
How to Delete Cells, Columns, or Rows
You can delete cells, cell ranges, or entire columns or rows in the same way you inserted them: right-click the selected cells and choose Delete or click the drop-down arrow
beneath the Delete icon 
at Home > Cells.
at Home > Cells.How to Hide and Unhide Columns or Rows
You can hide columns or rows that you don’t want to
appear on a spreadsheet. A hidden column will not appear onscreen or when you print. The easiest way to hide a row or column is to select a column, right-click, and then choose Hide.
To unhide a hidden column or row, select the rows that surround the hidden row, right-click, and choose Unhide. To find the columns or rows that surround the hidden
column or row, look for nonsequential labeling. For
instance, if you’ve hidden column C, then columns B and D will be adjacent to each other.
| Acknowledgments & Disclaimer |
