Excel shortcut keys for mac how to#

Excel keyboard shortcuts Microsoft Excel keyboard shortcuts for PC and Mac. Instead we could click on any cell and use Ctrl- A to select all of the data (up to the next blank row and column). Daily use Excel short-cuts (One stop solution) Computer, News 1. We could use the click-and-drag method on the data below, but if there were thousands of rows, it could take a long time. Sometimes it will be easier to use Excel Shortcut Keys for data selection. The shortcut to toggle absolute and relative references is F4 in Windows, and Command T on a Mac. For example, the shortcut for Edit Cell, in Windows is F2 and on a Mac, it's Control + U. Excel Shortcut Key to Select a Whole Data Set Finally, the fifth difference on a Mac is that some Excel shortcuts are just different. On a MAC, use the Command key instead of the Ctrl key.

Hold down the CTRL key and select the second set of rows/columns.

Selecting non-adjacent rows or columns is easy. Selecting Non-Adjacent Rows or Columns of Data They are available in Excel 2013-2021, Office 365. Surprisingly, these shortcuts are not new.

Still others are unaware of the shortcut keys that can make data selection easier than the click-and-drag method.

Excel shortcut keys for mac how to#

However, I have found that a lot of people have no idea about how to select non-adjacent rows or columns of data. Most people find it easy to select data in Excel by clicking and dragging the mouse. Free Agile Lean Six Sigma Trainer Trainingįree Excel Tips » Excel Data Selection with Shortcut Keys Excel Tips - Data Selection with Shortcut Keys Save Time on Data Analysis Using These Easy Shortcuts.Excel has shortcuts for easily navigating multiple sheets in a workbook.Press Option + Right arrow key to move to the next worksheet (to the right) in your Excel workbook.

Animated Lean Six Sigma Video Tutorials Press Command (Cmd) + Arrow Up key to go to the first cell in a column of contiguous data in Excel.