in Google Chrome: Alt+i,r other browsers: Alt+Shift+i,r (with rows selected) ⌘+Option+= ... Sheet commands shortcuts . Google Sheets has heaps of shortcuts you can use to format cells. Ctrl+U (Windows/Chrome OS) or Cmd+U (macOS): Underline. These were a few of the best Google Sheets shortcuts that are frequently used by professionals and amateurs alike. Shortcut to Zoom-in and Zoom-out in Google Sheets Another way to zoom in and zoom out in Google Sheets is by changing the zoom of the entire browser. What’s your Favorite Google Sheets Shortcut. Tom Ellis 9548. marked this as an answer. The best Google Sheets tips are the ones that save you serious time. That's why I use the Format Painter to take cells that are already formatted and paint those same styles into other cells. Paste Value Only (or Paste format only) When you copy and paste cells in Google Sheets, it will copy the value in the cell as well as the formula and the formatting of the cell (including the conditional formatting).With this shortcut, you can copy the cell and only paste the value in some other cell. Click on the cells that you want to copy the format from, then the Format Painter, then the cells you want to paste the styles to. Formatting commands shortcuts. Click Format Painter . To start using the format painter, start off by clicking in a cell that you want to copy the format from. Creating manual shortcuts can be a drag compared to the two methods above, but you should find it useful if you have a bunch of Docs, Sheets… Format Painter. Function commands shortcuts. Format Cells. Thanks again. TIP: Double-click the Format Painter button to lock the format. recommended this. Start off by highlighting the cells that you want to copy the format from. 6. Also, this formula based solution will work in another range. Google user. File commands shortcuts. I currently work round it by manually copying the format and then using CTRL+Y but the format painter would be easier. Navigation commands shortcuts. As you start using these shortcuts, you will narrow down to a few shortcuts that you use more than others and there even might be a few that aren’t listed above. It has quickly gained a lot of fan following and I see a lot of people migrating from other spreadsheets applications to Google Sheets. Number format shortcuts. Next, find the paint roller icon on the menu, and click on it. View commands shortcuts . 101 Google Sheets Keyboard Shortcuts Google Sheets is a relatively new spreadsheet tool in the market. Create Desktop Shortcut Manually. How do I remove multiple Hyperlinks at once in Google Sheets please? That feature is not currently available in Google Sheets. Data commands shortcuts. To instantly copy that formatting to a new destination, select the desired new cell. Original Poster. These are the shortcuts you use to do things like italicize or bold text, or format cell data to exponents: Ctrl+B (Windows/Chrome OS) or Cmd+B (macOS): Bold. To quickly copy an existing format on your sheet to other cells, use the Format Painter tool: Select the cells that contain your desired format. Although this method is not ideal in many cases, it does have various shortcuts that you can use. Ctrl+I (Windows/Chrome OS) or Cmd+I (macOS): Italicize. ... Use Format Painter. Menus access shortcuts. 1 Recommended Answer 4 Replies 60 Upvotes ... copy the content and then apply paste special -> paste value from the shortcut menu.