Inserting Worksheets
When you create a new workbook, it contains three worksheets. You can easily add additional worksheets to a workbook.
Start With More
You can change the number of worksheets Excel places in a new workbook by opening the Tools menu, selecting Options, clicking the General tab, and then changing the number under the Sheets in New Workbook option. Click OK to save your changes.
Follow these steps to add a worksheet to a workbook:
Select the worksheet before which you want the new worksheet inserted. For example, if you select Sheet2, the new worksheet (which will be called Sheet4 because the workbook already contains 3 worksheets) will be inserted before Sheet2.
Open the Insert menu.
Select Worksheet. Excel inserts the new worksheet, ...
Get Ten Minute Guide to Excel 97 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
