top of page
Writer's pictureDavid Pang

How to Use the Paste Formats Shortcut (Alt + E + S + T) in Google Sheets

Use the Paste Formats shortcut from Excel (Alt + E + S + T) in Google Sheets
Use the Paste Formats shortcut from Excel (Alt + E + S + T) in Google Sheets

Paste Formats is a powerful tool to help you quickly standardize formatting in your model, improving the trust others will have in your work when rev. It allows you to apply the formatting from other cells to the cells that you've selected, without any impact to the values in those cells. Often it's easier, especially with complex formatting designs, to just copy what you've done somewhere else to another section of the model. An example of this is if you've applied conditional formatting to your cells. In this article, I will show you how to activate this feature in Google Sheets by shortcut, just like you would in Excel


The most common shortcut for Paste Special in Excel is Alt + E + S + T. You can use this shortcut in Sheets, first by pressing Alt + E + S to bring up the Paste Special menu, and then by hitting T which will navigate you to the Paste Formats option. Hit "OK" to apply the shortcut


The SheetWhiz Paste Special Menu in Google Sheets
The SheetWhiz Paste Special Menu in Google Sheets

Steps for Paste Formats:

  1. Install the SheetWhiz Chrome Extension for free

  2. Refresh a Google Sheet and login when prompted. The SheetWhiz logo will appear in the upper right hand corner of the screen

  3. Copy the area you'd like to Paste and then hit Alt + E + S to bring up the shortcut menu. Make sure you press and release each key before pressing the next key, just like you would in Excel

    1. If you are on a Mac, use Option + E + S as there is no Alt key on the Mac keyboard

  4. Once the menu is up, you can navigate the menu just like you would in Excel by hitting the letter that is underlined in each of the options. For Paste Formats, this would be:

    1. Paste Formats:

      1. Alt + E + S + T (PC)

      2. Option + E + S + T (Mac)

  5. [Optional] Furthermore, you can change the Paste Special menu shortcut to a more convenient shortcut by clicking the button in the SheetWhiz menu and changing the key

Customize the paste special shortcut with SheetWhiz





30 views0 comments

Commenti


bottom of page