July 1, 2011

Microsoft Excel - Paste Formatting with One Keystroke

If you have several disconnected cells to share a format, such as bold text, it can be a hassle to select each cell one at a time, open its cell-format dialog box, and make the changes you want.

The quick solution is to format one of the cells, and then select all of the others by pressing Ctrl, and clicking them one by one. Once they're all highlighted, press F4 to apply the formatting to all of them at once.

Quick and easy!

No comments:

Post a Comment