Go to the first source worksheet (Vienna), click in the cell that contains the data to link (B5) and squiggly lines will surround it (figure 2).The shortcut keys differ between Windows and Mac keyboards. In the destination worksheet, click in the cell that will contain the link formula and type an equal sign, but do NOT press Enter (figure 1 below). CTRL + d Fill selected cell with the content in the cell above selected cell.Open the Excel workbook containing the worksheets. Command + Y Repeat the last action. Shift + F11 Insert a new sheet. CTRL + Shift + Tab Switch to the previous open worksheet (Mac) F11 Start a new chart sheet.If this option is not checked the cursor will move to the Formula Bar.Displays the Paste Name dialog box. (Advanced, Editing options - allow editing directly in cells). This is only available when the following option is ticked. To move to first cell in worksheet, CtrlHome.Allows you to edit the active cell directly, putting the cursor at the end.Calculates the Active / Selected worksheets in the Active workbook.Displays the Shortcut menu for the selected item.Inserts a new worksheet (before the active sheet) into the active workbook.Saves. You will see the text "Add to Selection" appear in the status bar.Smart Recalculation. This allows you to select non contiguous blocks of cells using the keyboard arrow keys.
0 Comments
Leave a Reply. |
Details
AuthorNicole ArchivesCategories |