How to Create Tabs in an Excel Spreadsheet
- 1). Open Microsoft Excel 2007 on your computer. Notice at that there are four tabs at the bottom that say "Sheet 1," "Sheet 2" and so on. Each of these tabs is a separate worksheet. Simply click on the tab to open that worksheet.
- 2). Add more tabs to the spreadsheet. You can do this two ways, both of which give you the same result. You can press the "Shift" and F11 keys. Or, you can right click on one of the tabs and click Insert. Click "Worksheet" and then click "OK."
- 3). Copy an existing worksheet into a new worksheet tab. Right click on the tab that you want to copy and select "Move or Copy." Check the box in front of "Create a Copy." Click "OK." An identical worksheet will be created.
- 4). Rearrange tabs. If you want to move a specific worksheet, right click on it. Select "Move or Copy." Click on the worksheet that you want to put it in front of or select "Move to End." Click "OK."
- 5). Rename the tabs so that you know what information is in each worksheet. Right click on the tab and select "Rename." The tab's text will be highlighted in black. Simply start typing the title for the tab.
- 6). Delete unused worksheet tabs. Right click on the tab for the worksheet that you do not want and select "Delete." The worksheet will be removed.
Source...