Sunday, October 5, 2014

How To Format The Entire Cells In A Workbook With Just Only A Single Click

Do you know the very shorter way to format the entire cells in a worksheet?

Fortunately, this following method is the best trick as far as I have ever known. It helps you to format the entire cells in a workbook to be the only one unique format. More, it does not complicate at all.

Here comes the step-by-step shortcut:
  • Select the original format cell as wanted. (Ex. Cell B3).
  • Click on the “Format Painter” icon on the top left corner.
  • Press the “Ctrl” “A” buttons on your keyboard.
Done! The outcome should be the same as the images beneath.

Before format
After format
See more other tips:
Would you like to surf my other blogs?

1 comment:

  1. WOW...! It's simple, but I really don't know how to format entire cell with this method.
    Thanks for this tips

    ReplyDelete