Alt + H + I + R in Google Sheets (Insert Sheet Rows)
Inserts a row above the current selection.
Add to Chrome (14 Days Free)In Excel: Home tab, Insert & Delete. In ShortieCuts' key-tip menu: "Insert 1 Row Above".
What Alt + H + I + R Does in Excel
Inserts a row above the current selection.
How to Use Alt + H + I + R in Google Sheets
- Add the ShortieCuts extension to Chrome and open any Google Sheet.
- Select the cells you want to work on (if the command needs a selection).
- Press Alt (or Option on Mac). Excel-style key-tips appear over the sheet.
- Press H, I, then R. ShortieCuts runs Insert Sheet Rows, just like Excel.
Without an extension: Google Sheets doesn't support Excel's Alt key-tips, so Alt + H + I + R won't run Insert Sheet Rows on its own.
Related Shortcuts
| Keys | Shortcut |
|---|---|
| Alt HIC | Insert Sheet ColumnsInserts a column to the left of the current selection. |
| Alt HIS | Insert SheetAdds a new worksheet tab to the workbook. |
| Alt HDR | Delete Sheet RowsDeletes the entire rows of the selected cells. |
| Alt HDC | Delete Sheet ColumnsDeletes the entire columns of the selected cells. |
| Alt HDD | Delete CellsOpens the Delete dialog, where you choose to shift cells left or up, or delete the entire row or column. |
| Alt HDS | Delete SheetDeletes the active worksheet tab. |
| Alt HVV | Paste ValuesPastes only the values of the copied cells. |
| Alt HVF | Paste FormulasPastes the copied formulas without bringing over the source cells' formatting. |
FAQ
Does Alt + H + I + R work in Google Sheets?
Not on its own. Google Sheets doesn't have Excel's ribbon key-tips, so typing Alt + H + I + R won't run Insert Sheet Rows. With the ShortieCuts Chrome extension installed, Alt + H + I + R works in Google Sheets the same way it does in Excel.
What does Alt + H + I + R do in Excel?
Insert Sheet Rows. Inserts a row above the current selection.
How do I use Alt + H + I + R on a Mac?
With ShortieCuts, press Option instead of Alt, then H, then I, then R: Option + H + I + R. The same key-tips appear as on Windows.
Is ShortieCuts free?
ShortieCuts has a free 14-day trial with no credit card needed. After the trial, Pro is $7.99 a month or $69.99 a year.