Worksheet Basics (Mac)

A worksheet consists of a 2 dimensional grid with columns and rows which intersect to create cells.

Columns are marked with letters. Once the first 26 columns have been labeled (A-Z), letters are doubled and then tripled to allow for 16,384 columns (up to XFD).

Rows are marked with numbers and there are over a million rows (1,048,576 to be exact). If you are attempting to work with a single data set that pushes these limits, my sympathies!

A cell is referenced by its column letter and row number.

 

Naming a Worksheet

There is more than one way to name/rename a worksheet.

1. Double click on the worksheet tab and type in the new name.

https://library.barnard.edu/sites/default/files/images/inline/title.jpg


2. Go to the dropdown menu Format on the top and select Sheet. On the side menu, click on Rename.

3. Hold down Control and click on the worksheet tab. Select Rename from the drop down menu.

 

Adding a New Worksheet

There are many ways to add a new worksheet.

1. The tab to the right of all of the other tabs has a 'new worksheet icon' on it. Simply clicking on this tab will create a new worksheet.

https://library.barnard.edu/sites/default/files/images/inline/newsheet.gif


2. Go to Insert in the Main Menu Bar and select Sheet, in the side menu, click on Blank Sheet.

3. Hold down Control and click on the worksheet tab. Select Insert Sheet from the drop down menu.

4. Click on the New Window icon under Layout.

https://library.barnard.edu/sites/default/files/images/inline/newsheet2.gif

 

Deleting a Worksheet

Go to Edit in the Main Menu Bar and select Delete Sheet

If you’ve typed anything in the worksheet, this error message will come up.

https://library.barnard.edu/sites/default/files/images/inline/deletepage.jpg


Once the sheet is deleted it is gone forever (undo is NOT an option), so always be certain before deleting that it is what you want to do.

 

Move a Worksheet within a Workbook

There are multiple ways to move a worksheet within a workbook:

1. Click on the worksheet tab and, holding the mouse button down, drag it to where you would like the worksheet to be. A small black arrow will appear showing you where you will be placing the sheet. All information in the worksheet is preserved during this process.

https://library.barnard.edu/sites/default/files/images/inline/move.gif


2. Go to Edit in the Main Menu Bar and select Move or Copy Sheet. A dialogue box will open.

3. Hold down Control, click on the worksheet tab and select Move or Copy from the drop down menu. This will open the same dialogue box as in option 2.

 

Creating a Copy of a Worksheet within a Workbook

There are multiple ways to create a copy of a worksheet within a workbook:

1. Hold down Control, click on the worksheet tab, select Move or Copy and select the worksheet directly behind where you want to place the copy. Check the Create a Copy box. The copy will have the same name as the original followed by a number in parenthesis, which you can rename as discussed above.

https://library.barnard.edu/sites/default/files/images/inline/copy.gif


2. Click on Edit in the main menu bar and select Move or Copy Sheet. This will open the same dialogue box and will refer to the worksheet you are currently in.

 

Move or Copy a Worksheet to a Different Workbook

After opening the dialogue box for moving a worksheet within the same workbook (using one of the methods discussed above), open the dropdown menu to select the workbook you would like to move the worksheet to. The workbook must be open to appear in the menu. You can also create a new workbook in the dialogue box. 

To leave a copy in the current worksheet check the Create a copy check box, otherwise the worksheet will be removed from the current workbook and moved to the chosen one.

https://library.barnard.edu/sites/default/files/images/inline/copynew.gif

 

Changing the Worksheet Tab Color

There are multiple ways to change a worksheet tab color:

1. Hold down Control, click on the sheet tab and go to Tab Color and select the color you would like. Note that the colors are very pale when you are working in the worksheet, but become brighter if you are in a different worksheet.

https://library.barnard.edu/sites/default/files/images/inline/tabcolor.gif


2. Click Format on the main menu bar, scroll over the Sheet tab and select Tab Color.

 

<< Back to Getting Started                  To the Ribbon >>

 

Return to Table of Contents

 

Questions, comments, concerns?
Send an email to the Empirical Reasoning Lab
Or drop by during the Lab's open hours.