Alt + H + F + I + R in Google Sheets (Fill Right)
Copies the leftmost cell of the selection across the rest of the selection, the standard way to roll a formula across a timeline.
Add to Chrome (14 Days Free)In Excel: Home tab, Fill & Clear. In ShortieCuts' key-tip menu: "Fill Right".
What Alt + H + F + I + R Does in Excel
Copies the leftmost cell of the selection across the rest of the selection, the standard way to roll a formula across a timeline.
How to Use Alt + H + F + 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, F, I, then R. ShortieCuts runs Fill Right, just like Excel.
Built-in Google Sheets alternative: Ctrl + R (Cmd + R on Mac) also fills right.
Related Shortcuts
| Keys | Shortcut |
|---|---|
| Alt HFID | Fill DownCopies the top cell of the selection down through the rest of the selection. |
| Alt HFIS | Fill SeriesOpens the Series dialog to fill a range with a stepped sequence of numbers or dates. |
| Alt HEA | Clear AllClears everything from the selected cells: contents, formatting and comments. |
| Alt HEF | Clear FormatsRemoves all formatting from the selected cells but keeps their values and formulas. |
| Alt HEC | Clear ContentsClears the values and formulas from the selected cells but keeps their formatting. |
| Alt HEM | Clear Comments and NotesRemoves the comments and notes attached to the selected cells. |
| Alt HER | Remove HyperlinksRemoves hyperlinks from the selected cells while leaving the text in place. |
| Alt HVV | Paste ValuesPastes only the values of the copied cells. |
FAQ
Does Alt + H + F + I + R work in Google Sheets?
Not on its own. Google Sheets doesn't have Excel's ribbon key-tips, so typing Alt + H + F + I + R won't run Fill Right. With the ShortieCuts Chrome extension installed, Alt + H + F + I + R works in Google Sheets the same way it does in Excel.
What does Alt + H + F + I + R do in Excel?
Fill Right. Copies the leftmost cell of the selection across the rest of the selection, the standard way to roll a formula across a timeline.
How do I use Alt + H + F + I + R on a Mac?
With ShortieCuts, press Option instead of Alt, then H, then F, then I, then R: Option + H + F + I + R. The same key-tips appear as on Windows.
Is there a built-in Google Sheets shortcut for Fill Right?
Ctrl + R (Cmd + R on Mac) also fills right.
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.