Excel insert rows shortcut mac

Excel Shortcut: Insert rows | Exceljet

Rows Keyboard shortcut: Pete Pete 11 1. Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.

Shortcuts to insert/delete rows and columns

Email Required, but never shown. Post Your Answer Discard By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service , privacy policy and cookie policy , and that your continued use of the website is subject to these policies.

Related Drag from a blank part of the sheet around objects. Option-drag to select objects outward from the starting point.

  • how to retrieve deleted emails from trash on mac;
  • how to set up default wifi on mac.
  • media composer 5 keygen mac;
  • bloquer les chiffres sur clavier mac.
  • Keyboard shortcuts for Google Sheets - Computer - Docs Editors Help.

Option-drag in the bottom-right corner of the table. To delete rows and columns that have data, option-drag.

Insert or delete a row or column within the table: Move the pointer over a row number or column letter, click the arrow, then choose a command from the menu that appears. Insert multiple rows or columns at once: Anywhere in the table, select a number of rows or columns equal to the number of rows or columns you want to insert, click the arrow next to one of the selected row numbers or column letters, then choose Add Rows Above or Add Rows Below or Add Columns Before or Add Columns After.

Delete multiple rows or columns at once: Adding header rows, header columns, or footer rows converts existing rows or columns into headers or footers. For example, if you have data in the first row of a table and you add a header row, the first row is converted to a header row that contains the same data.


Add or delete headers and footers: To remove all headers or footers, set the number to zero. Freeze header rows and columns: To learn how to show table headers on every page of a printed spreadsheet, see Print a spreadsheet. Select the rows or columns you want to hide.

NMSU KnowledgeBase

Move the pointer over a row number or column letter, then click the down arrow that appears and choose Hide Selected Rows or Hide Selected Columns. A gray bar appears between the column letters or row numbers to show where columns and rows are hidden. To show hidden rows or columns, select a row or column adjacent to the hidden ones.