Show-Me Academy Menu | FAQ | About | Contact |

Show me how to manage worksheets in Microsoft Excel 2007

Excel -> Microsoft Excel 2007

Problem: I need to be able to add, edit, reorder, and delete worksheets in Excel.

Open Microsoft Excel 2007
Right-click the first worksheet ("Sheet1")
Click the "Insert..." item
On the "Insert" window, ensure that the "Worksheet" icon is highlighted and click the "OK" button
Right-click the new worksheet ("Sheet4")
Click the "Delete" item
Right-click the first worksheet ("Sheet1")
Click the "Rename" item
Type a new name for the worksheet
Right-click the renamed worksheet
Click the "Move or Copy..." item
On the "Move or Copy" window, move the renamed worksheet by designating it to be placed before another worksheet (or designate it to be placed at the end)
Right-click the renamed worksheet
Click the "Move or Copy..." item
On the "Move or Copy" window, check the "Create a copy" checkbox
Click "OK"
Right-click the renamed worksheet
Click the "Tab Color" item and choose a new color in the resulting color palette window that appears on the right
Right-click the renamed worksheet
Click the "Hide" item
Right-click any of the remaining worksheets
Click the "Unhide..." item
On the "Unhide" window, select the hidden worksheet and click "OK"
Right-click any of the worksheets
Click the "Select All Sheets" item
Type a value in any cell on the currently-displayed worksheet
Select any of the other worksheets and confirm that the same value has been entered into the same cell
Click the "Insert Worksheet" button directly to the right of the last worksheet
Click-and-drag the newly-created worksheet to the left and release it, confirming that it has moved positions
Create several new worksheets and then observe the behavior of the arrow navigation buttons directly to the left of the first worksheet