Here's our Microsoft Office Tip for.. August 24, 1998
Click Here to see a complete list of all of our previously released Tips!
Add Sheets to Excel
If you need to add more worksheets to an exiting workbook, don't worry, you can add worksheets without doing any harm to existing data, but here's one peculiarity.
Let's say that your current workbook has three sheets. These sheets are named Sheet1, Sheet2, and Sheet3. Now, let's say that you want to add a new sheet that is to be named Sheet4. Right-click the Sheet3 tab and choose Insert..., Worksheet. You'll get a new sheet named Sheet4, but it will appear between Sheet2 and Sheet3. Excel inserts a new sheet before the selected sheet. But, you wanted it after Sheet3, right? So, use the left mouse button to grab the new Sheet4 tab, then drag it to the right of the Sheet3 tab. You'll see an arrow appear to show you the new sheet placement. When you release the mouse button, Sheet4 will appear after Sheet3.