Thank you for your feedback!

This will select all cells in the entire row all the way to XFD. Holding down the mouse key you can also highlight multiple rows by scrolling down the numbers. You can also click on the top left corner of the worksheet directly above the 1 and directly to the left of the A.

Keyboard shortcuts in Excel for Mac

You can also change the row height or column width with the mouse, but you must select either columns OR rows, NOT a range of cells. After selecting the columns or rows you can scroll the mouse over the column letters row numbers and the cursor will change to look approximately like this when it scrolls over the borders between columns or rows:. Holding down the mouse or clicker you can drag the column or row to be the width that you want. You can also double click on the double arrow cursor and the columns will automatically fit to the size of the contents in the cells. All selected columns or rows will be changed.

Sometimes in Excel you'll get this: This happens when the size of the number is wider than the width of the cell.

Cell Manipulations (Mac)

Bob Jones AKA: CyberTaz Replied on March 21, However you do have at least two other options: If the objects are in close proximity to one another: Select one object, then hold Shift or Command you don't need to use both while clicking each of the others, or Select one object, then click the Selection Pane tool in the Arrange group on the Shape Format contextual tab.

Thanks for marking this as the answer. How satisfied are you with this reply?


  • Select a Large Range of Cells With the Shift Key;
  • Excel video training.
  • canon mg2160 driver download for mac.
  • programa padre 2014 para mac.

Thanks for your feedback, it helps us improve the site. How satisfied are you with this response? Some smaller keyboards do not have this key.

Select a Range of Cells By Clicking and Dragging

Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents. Apply the currency format with two decimal places negative numbers appear in red with parentheses. Apply the number format with two decimal places, thousands separator, and minus sign - for negative values.


  • reset mac mini firewire port!
  • logmein download mac os x.
  • Quick Excel Tip – Quickly Select Cells In A Range – Chris West's Blog.
  • does mac app store work on pc.
  • vice city mac mod installer?
  • Excel shortcuts for Windows and Mac | Exceljet.
  • mac os x mountain lion airplay not working.

Extend the selection to the last nonblank cell in the same column or row as the active cell. Alternate between hiding objects, displaying objects, and displaying placeholders for objects. Select cells in a row that don't match the value in the active cell in that row. You must select the row starting with the active cell. Move from left to right within the selection, or move down one cell if only one column is selected. Move from right to left within the selection, or move up one cell if only one column is selected. If you'd like to change the direction of these shortcuts using the mouse, on the Excel menu, click Preferences , click Edit , and then, under.

Multiple Object Selection Arrow for Excel for Mac - Microsoft Community

After pressing Return, move selection , select the direction you want to move in. Excel for Mac uses the function keys for common commands, including Copy and Paste. For quick access to these shortcuts, you can change your Apple system preferences so you don't have to press the FN key every time you use a function key shortcut. Changing system function key preferences affects how the function keys work for your Mac, not just Excel. After changing this setting, you can still perform the special features printed on a function key.

How to Select Rows and Columns in Excel with Mac Keyboard Shortcut

Just press the FN key. If a function key doesn't work as you expect it to, press the FN key in addition to the function key. If you don't want to press the FN key each time, you can change your Apple system preferences:. Change function key preferences with the mouse. On the Keyboard tab, select the check box for Use all F1, F2, etc. The following table provides the function key shortcuts for Excel for Mac. Use a screen reader to explore and navigate Excel. Basic tasks using a screen reader with Excel. Microsoft wants to provide the best possible experience for all our customers.

If you have a disability or questions related to accessibility, please contact the Microsoft Disability Answer Desk for technical assistance. The Disability Answer Desk support team is trained in using many popular assistive technologies and can offer assistance in English, Spanish, French, and American Sign Language. Please go to the Microsoft Disability Answer Desk site to find out the contact details for your region.

If you are a government, commercial, or enterprise user, please contact the enterprise Disability Answer Desk. Office Accessibility.