I have version 2003 of excel and love hot keys... Often at work I have to
format rows and columns to others nearby.. I have tried to figure out the
hotkey for the format painter and cannot it would help out tremendously... So
does anyone know the hotkey to copy the formatting of other cells and paste
the format to others?

Well, you could try
Ctrl+c (copy)
Alt+est (Paste special - format)

If you recorded a macro, this is exactly the same as what the format painter
does.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"mmassey" wrote:

I have version 2003 of excel and love hot keys... Often at work I have to
format rows and columns to others nearby.. I have tried to figure out the
hotkey for the format painter and cannot it would help out tremendously... So
does anyone know the hotkey to copy the formatting of other cells and paste
the format to others?

I don't believe there is one.

You could go through these convoluted steps.

CTRL + c to copy A1........arrow over to F1.....SHIFT + Arrow down to F6

Alt + e, s, t, Enter, Esc


Gord Dibben MS Excel MVP

On Thu, 4 Feb 2010 06:52:04 -0800, mmassey
wrote:

I have version 2003 of excel and love hot keys... Often at work I have to
format rows and columns to others nearby.. I have tried to figure out the
hotkey for the format painter and cannot it would help out tremendously... So
does anyone know the hotkey to copy the formatting of other cells and paste
the format to others?