This week we’re going to learn how to copy and paste in Microsoft Excel for Mac with shortcuts. Although they are 2 separate shortcuts, copy and paste almost always are executed one after the other. The copy shortcut has to be one of the most used shortcuts for Microsoft Excel.
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. Double click on the worksheet tab and type in the new name. Go to the dropdown menu Format on the top and select Sheet. On the side menu, click on Rename. 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. 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. Go to Insert in the Main Menu Bar and select Sheet, in the side menu, click on Blank Sheet. Hold down Control and click on the worksheet tab. Select Insert Sheet from the drop down menu.
Click on the New Window icon under Layout. 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. 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. Go to Edit in the Main Menu Bar and select Move or Copy Sheet.
Outlook on mac keeps asking for password. A dialogue box will open. 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 as discussed above. 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 ), 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.
- среда 21 ноября