Anything Under the Sun

1.) Inserting and Deleting Rows and Columns

* To Insert a Row or Column
Select the Row or Column Heading(s) where you want to insert the column or row.
Right-click the selected Row or Column Heading(s) and select Insert from the Shortcut Menu.

* To Delete a Row or Column
Select the Row or Column Heading(s) that you want to delete.
Right-click the selected Row or Column Heading(s), and then select Delete from the Shortcut Menu.

2.) Splitting and Freezing a Window

* To Split Panes
Select a cell. On Window Menu, click Split.

* To Freeze Panes
In the Window Menu, click Free Panes.

* To Unfreeze Panes
In the Window Menu, click Unfreeze Panes.

3.) Hiding and Displaying Rows and Columns

* To Hide Row(s) / Column(s)
Select the row(s) or column(s) heading.
On the Format Menu, point to Row or Column and choose Hide.

* To Unhide Row(s) / Column(s)
On the Format Menu, point to Row or Column, then choose Unhide.

4.) Adjusting the Zoom Setting

* To Change the Zoom Setting
In the Zoom Box, click the size that you want, or enter a number from 10 to 400.

5.) Switching to Different Sheets in a Workbook

Switch to a workbook by clicking its Sheet Tab at the bottom of the screen.
Right-click the Sheet Tab Scroll that lists all the worksheets in the Shortcut Menu.

6.) Inserting and Deleting Worksheets

* To Add a New Worksheet
On the Insert Menu, choose Worksheet.
Press Shift + F11.

* To Delete a Worksheet
On the Edit Menu, choose Delete Sheet.
Right-click on the Sheet Tab and select Delete from the Shortcut Menu.

7.) Renaming Worksheets

Double-click the Sheet Tab, and then enter a new name for the worksheet.
Right-click the Sheet Tab, and then select Rename from the Shortcut Menu, and enter the new name of the worksheet.
In the Format Menu, click Sheet, choose Rename. Enter a new name of the worksheet.

8.) Moving and Copying Worksheets

* To Move the Worksheet along the Same Sheet Tab
Click the sheet on the Sheet Tab to be moved.
Drag the selected sheet along the Sheet Tabs. A small triangle and a blank paper appear as you drag the sheet.
Release the mouse at the point where you want to move the sheet to.

* To Copy the Worksheet along the Same Sheet Tab
Click the sheet on the Sheet Tab to be copied.
Hold down the CTRL key and drag the selected sheet along the Sheet Tabs. A small triangle appears and a paper with a plus sign as you drag the sheet.
Release the mouse before you release the CTRL key.

* To Use the Move or Copy Dialog Box
Right-click the sheet on the Sheet Tab to be moved.
Click Move or Copy.
To move or copy the selected sheets to a new workbook, click New Book.
Click OK.

9.) Adding Color to Sheet Tabs

Select the sheet(s) that you want to color.
In the Format Menu, point Sheet, and then choose the Tab Color.
Select the color that you want to apply, and then click OK.

10.) Working with Several Workbooks and Windows

Click the Select All Button to select all the cells in a worksheet.
Switch between open window by selecting Window Menu, and then selecting the name o the workbook that you want to view.
In the Window Menu, click Arrange All to view multiple windows at the same time.
Click the Window Maximize Button to maximize a window, or click the window Restore Button to return the window to its original size.

11.) Referencing External Data

* To Reference a Cell of Range in another Worksheet (Typing)
Click the cell into which you want to enter the reference.
Type the equal sign (=).
Click the workbook on the Taskbar (if the sheet containing the cells that you want to reference is in another workbook).
Click the Sheet Tab of the worksheet containing the cell that you want to reference. Click the cell or range that you want to reference.
Press Enter.

* To Reference a Cell or Range in Another Worksheet (Clicking)
Click the cell into which you want to enter the reference.
Type the equal sign (=).
Click the workbook on the Taskbar (if the sheet containing the cells that you want to reference is in another workbook.)
Click the Sheet Tab of the worksheet containing the cell that you want to reference. Click the cell or range that you want to reference.
Press Enter.

* To Reference a Cell or Range through the Paste Special Command
Click the cell you want to be referred to.
Right-click the cell, and then choose Copy.
Switch to the worksheet or workbook in which you want to put the reference.
Click the cell that you want to enter the reference.
Right-click the cell, and then choose Paste Special.The Paste Special Dialog Box appears.
Click the paste Link Button.