Number format (General, Percentage, Currency, etc.).
![google doc copy formatting shortcut google doc copy formatting shortcut](https://s1.yimg.com/bt/api/res/1.2/JyRUt3w6o1GI81VYxKH2AQ--/YXBwaWQ9eW5ld3M7cT04NQ--/http://media.zenfs.com/en_us/sbs/sbc/Business2Community/Google-Docs-Short-Cut.png)
With just a couple of clicks, it can help you reproduce most, if not all of the formatting settings, including: It works by copying the formatting of one cell and applying it to other cells. When it comes to copying formatting in Excel, Format Painter is one of the most helpful and underused features. Copy formatting to an entire column/row with Paste Special.Copy formats down a column using the Fill Handle.
#GOOGLE DOC COPY FORMATTING SHORTCUT HOW TO#
![google doc copy formatting shortcut google doc copy formatting shortcut](https://i.pinimg.com/736x/04/33/0d/04330de87a41f4dd89ab1d88b6366bd0--keyboard-shortcuts-google-chrome.jpg)
These techniques work in all versions of Excel 2016, 2013, 2010 and earlier.Īfter you've put a lot of effort in calculating a worksheet, you would usually want to add some finishing touches to make it look nice and presentable. This short tutorial shows how to copy formatting in Excel using Format Painter, Fill Handle and Paste Special options.