If you find any post useful then, please do share with others. Thanks!

Popular Posts

Contact

Email me

Need help and that also free? I like to learn this way, in case of any question or for a small task, please feel free to email me with details and example data, if required.

Monday, January 14, 2019

Excel Format Painter > formatting to an entire column/row

Format Painter is the most helpful feature to copy formatting from one cell and applying to others.

With a couple of clicks, we can copy formatting like number format, font, size, color, cell background color, cell borders and text alignment etc.

The feature is available on the home tab in the clipboard group.




Basic use is very simple. Select the cell whose formatting you want to copy and click on Format Painter button. The pointer will change to brush. Now click on the cell where you want to apply the formatting.

Simple way to copy cell formatting to an entire column/row.


  • Select the cell with the desired format and press Ctrl + C to copy its contents and formats
  • Select the entire column or row which we want to format by clicking on its heading
  • Right click the selection and under paste options (Excel 2013), select the option ‘Formatting’. 


This way we will copy just the formatting in entire column, easily.