Excel 2003

M

mmassey

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?
 
L

Luke M

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.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 2
Copying Conditional formatting 2
Set default cell format while retaining overrides 3
How can I copy print options from one tab to another tab? 2
Conditional Formatting 3
Format Painter Column Width 3
Filter Question 2
Copy and paste between workbooks 2

Top