Inserting and Deleting Worksheets

graphics/07inf08.jpg

graphics/one_icon.jpg

Right-click the tab of the worksheet that you want a new worksheet placed in front of, and select Insert from the shortcut menu.

graphics/tow_icon.jpg

The Insert dialog box opens. Double-click the type of worksheet you want to insert (select Worksheet). A new worksheet (the next sheet number in the sequence) appears.

graphics/three_icon.jpg

To delete a worksheet, right-click the worksheet tab and select Delete from the shortcut menu. The worksheet is removed from the workbook.

INTRODUCTION

When the default three worksheets per workbook just aren't enough, you will need to insert additional worksheets. Other times, you'll discover you no longer need a worksheet included in a workbook and need to delete it. (Just be sure when you delete worksheets that you definitely no longer need the information.)

TIP

Inserting Worksheets

You can also open the Insert menu and select Worksheet to automatically insert a worksheet into your workbook in front of the currently selected worksheet. If you need to rearrange the worksheets, see the next task.

TIP

Workbook Buttons

If the worksheet tabs aren't visible with a large number of worksheets, you can use the workbook buttons to the left of the worksheet tabs. Click the following buttons: > (next right) or < (next left); |< (first worksheet) or >| (last worksheet).



Easy Microsoft Office 2003
Easy Microsoft Office 2003
ISBN: 0789729628
EAN: 2147483647
Year: 2003
Pages: 281
Authors: Nancy Lewis

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net