If you are in Windows Vista: Go to the top left corner - click the 'Microsoft' button. In the drop down menu - click new ---> new workbook.
If you are running Windows 8.1 ---> go to the file tab (top left corner of your open workbook -->click on new ---> choose the first item - blank workbook.
Testimonial: "Thank you. However, the answer provided does not help. I know how to create a spreadsheets. Specifically, I would like to know how to go directly to another spreadsheet in my workbook without clicking on the tab."
Sorry I misunderstood your question, and even with further explanation, I don't understand what you want to do. To go from one spreadsheet to the next you click on the sheet number (or name you have renamed it) at the bottom. To not do this would be like wanting to read the next page of a book, without turning the page. I really think I am misunderstanding what you are wanting to do. sorry.
I understand what your have replied. But what I would like to do program a cell to automatically go to the sheet number (or the name I have renamed it) at the bottom.
×
Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.
Click on the "Insert" tab at the top of the document.
Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.
Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.
Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.
Hit the "OK" button at the bottom of the Create Table dialog box to create your table.
161 views
Usually answered in minutes!
×