Alt + E + S + F in Google Sheets (Paste Special Formulas)
Alt + E + S opens the classic Paste Special dialog and F chooses Formulas, pasting the copied formulas without their formatting.
Add to Chrome (14 Days Free)In Excel: Classic menu tab, Classic Paste Special (Alt + E + S). In ShortieCuts' key-tip menu: "Formula Only".
What Alt + E + S + F Does in Excel
Alt + E + S opens the classic Paste Special dialog and F chooses Formulas, pasting the copied formulas without their formatting.
How to Use Alt + E + S + F 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 E, S, then F. ShortieCuts runs Paste Special Formulas, just like Excel.
Without an extension: Google Sheets doesn't support Excel's Alt key-tips, so Alt + E + S + F won't run Paste Special Formulas on its own.
Related Shortcuts
| Keys | Shortcut |
|---|---|
| Alt ESV | Paste Special ValuesThe classic Excel 2003-era sequence: Alt + E + S opens Paste Special, then V pastes values only. |
| Alt ESX | Paste Special All Except BordersAlt + E + S opens the classic Paste Special dialog and X chooses All Except Borders. |
FAQ
Does Alt + E + S + F work in Google Sheets?
Not on its own. Google Sheets doesn't have Excel's ribbon key-tips, so typing Alt + E + S + F won't run Paste Special Formulas. With the ShortieCuts Chrome extension installed, Alt + E + S + F works in Google Sheets the same way it does in Excel.
What does Alt + E + S + F do in Excel?
Paste Special Formulas. Alt + E + S opens the classic Paste Special dialog and F chooses Formulas, pasting the copied formulas without their formatting.
How do I use Alt + E + S + F on a Mac?
With ShortieCuts, press Option instead of Alt, then E, then S, then F: Option + E + S + F. 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.