Mac excel select row shortcut

Related shortcuts Display Delete dialog box. Ctrl -. Delete columns. Delete rows. Delete cells. Display Insert Dialog box. Insert columns. Insert rows. Your site is undoubtedly the best I have ever come across for learning excel. Lucid and clear. Amazing job done by you guys!

Excel Shortcuts PC Mac

Display Format Cells with Font tab selected. Ctrl Shift F. Apply or remove bold formatting. Ctrl B. Apply or remove italic formatting. Ctrl I. Apply or remove underscoring. Ctrl U. Apply or remove strikethrough formatting. Ctrl 5.

Excel Shortcuts to Select Rows, Columns, or Worksheets

Add or remove the shadow font style. Add or remove the outline font style. Align center. Align left. Align right. Alt H 6. Remove indent. Alt H 5. Increase font size one step. Alt H FG. Decrease font size one step. Alt H FK. Apply general format. Apply currency format. Apply percentage format. Apply scientific format. Apply date format.

Apply time format. Apply number format. Ctrl Shift! Add border outline. Add or remove border right. Alt R. Add or remove border left. Alt L. Add or remove border top. Alt T. Add or remove border bottom.

Keyboard shortcuts in Excel for Mac

Alt B. Add or remove border upward diagonal. Alt D. Add or remove border horizontal interior. Alt H. Add or remove border vertical interior. Alt V. Remove borders. Toggle absolute and relative references. Open the Insert Function Dialog Box. Shift F3. Autosum selected cells. Toggle formulas on and off. Insert function arguments. Ctrl Shift A. Enter array formula. Ctrl Shift Enter. Calculate worksheets.

Fn F9. Calculate active worksheet.

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

Shift F9. Force calculate all worksheets. Ctrl Alt F9. Evaluate part of a formula. Expand or collapse the formula bar. Ctrl Shift U. Display function arguments dialog box. Define name. Ctrl F3. Define name using row and column labels. Ctrl Shift F3. Paste name into formula. Accept function with autocomplete. Display Insert Dialog box.

In this topic

Insert rows. Insert columns. Display Delete dialog box.

Ctrl -. Delete rows. Delete columns. Delete cells. Delete contents of selected cells. Hide columns. Ctrl 0. Hide rows. Ctrl 9. Unhide rows. Ctrl Shift 9. Unhide columns. Ctrl Shift 0. Group rows or columns.

List of Excel Shortcuts

Ungroup rows or columns. Open Group Dialog Box. Open Ungroup Dialog Box. Hide or show outline symbols. Ctrl 8. Zoom in. Zoom out.

Frequently used shortcuts

Ctrl Alt -. Select entire pivot table. Toggle pivot table field checkbox. Group pivot table items. Ungroup pivot table items. Hide pivot table item. Create pivot chart on same worksheet. Create pivot chart on new worksheet. Open pivot table wizard. Alt D P.

Insert new worksheet. Shift F Go to next worksheet. Ctrl PgDn. Go to previous worksheet. Ctrl PgUp. Move to next pane. Fn F6. Move to previous pane. Shift F6. Go to next workbook. Ctrl Tab. Go to previous workbook. Ctrl Shift Tab. Minimize current workbook window. Ctrl F9. Maximize current workbook window. Ctrl F Select adjacent worksheets. Perhaps you want to highlight a row or column to make it stand out in your spreadsheet, or maybe you are trying to copy the row or column and move it elsewhere.

Whatever it is you may be doing, selecting the entire row or column with this shortcut will speed up the process. All rights reserved. Ecommerce Software by Shopify. Menu 0. The Excel Skinny A blog about Excel and its users. Selecting the Entire Column: