#Mac excel hotkey for anchor cell how to
#Mac excel hotkey for anchor cell mac os x

End: Moves the cursor to the last cell of the current row in a column containing data.

#Mac excel hotkey for anchor cell mac os x

As Mac OS X users are not familiar with shortcut sequences. Home: Moves the cursor to the first cell of the current row. Cmd+C to copy the selection) and shortcuts using sequences (ex. In the ‘Paste Special’ dialog box, click on the Formulas option. In the options that appear, click on ‘Paste Special’. These save time with navigating the worksheet.

#Mac excel hotkey for anchor cell how to

Ctrl+End: Moves the cursor to the last cell on the sheet that contains data. Copy the cell (use the keyboard shortcut Control + C in Windows or Command + C in Mac) Select all the cells where you want to apply the same formula. In this video I share 7 keyboard shortcuts (plus variations) on how to select cells and ranges on a worksheet.

'Most useful' is certainly in the eye of the beholder. Navigation and selection shortcuts: Ctrl+Home: Moves the cursor to the first cell in the sheet (A1). The shortcutsįill selected cells with an entry you typed in one cellįill data down or to the right through selected cellsĬtrl] and (semicolon) or Ctrl and : (colon)

Note: This article is also available as a PDF download. Here are 10 timesavers that put the short in shortcut. But on a practical level, mastering 10 genuinely useful shortcuts will get you a lot farther than a vague knowledge of 50 shortcuts you seldom use and can't remember. It's great to know the resources are out there.

Value If Error) Enter Formula Refresh All Anchor Cell Name Cell Jump to Cell Use. You can tap the Help files, hunt the info down via Google, or download a comprehensive list, like this Excel cheat sheet. Mac Excel 2008 / 2011+ Quick Reference The Most Important Keyboard. As we've observed before, there's no shortage of information on Microsoft Office keyboard shortcuts.