Copy format of cell to whole column – shortcut

How do you copy the format of a cell to its whole column. Easy with the mouse, faster with the keyboard.

Alt H F P (to copy format)

Ctrl+Space (to select the whole column).

You’re already done. Also works with Shift+Space to copy the format to the whole row.

Try it, you might like it.

Thomas

Advertisements

One comment on “Copy format of cell to whole column – shortcut

  1. marot90 says:

    Well, that definetely is faster than doing it manually. Although Mac users might have a problem here, since apparently they cant rebidn hotkeys and standard hotkeys are pretty badly placed. For those and everyone else who cant use hotkey, there is only the slow way (guide for copying format: http://www.excel-aid.com/excel-copy-formatting-cells.html ). Hope that helped someone, in my first weeks with excel i also hardly used hotkeys. Though i really recommend learning them. I mean come on, compare the effort between the guide i gave you to the two hotkey clicks described by Thomas. Not even a contest.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s