Number 233 - September 2002

EXCEL Sheet Addition with Excel 97/2000
Office Tips edited by John Heenan, NOCCC - July 08, 2002
For Excel 97/2000 users, if you need to add more worksheets to an existing 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. 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.     Copyright - 1995-2002 by North Orange County Computer Club. All rights reserved. Articles by NOCCC authors may be reprinted by other user groups without permission provided they are unaltered and the publication acknowledges the author thereof and NOCCC. Articles contained herein by authors from other organizations retain their original copyright.
Number 233 - September 2002