Copy and paste formatting with keyboard in Excel 2007?

[ajkessel]

Is there any way to copy and paste formatting from one cell to another
in Excel (2007 or otherwise)? I'm looking for an analog of ctrl-shift-
c / ctrl-shift-v from Word.

 

[Harlan Grove]

Is there any way to copy and paste formatting from one cell to another
in Excel (2007 or otherwise)? I'm looking for an analog of ctrl-shift-
c / ctrl-shift-v from Word.

I don't believe there's a [Ctrl]+[Shift]+C in Excel to copy just
formats, but [Ctrl]+[Shift]+V will display the Paste Special dialog,
and you could then press T and [Enter] to paste formats only.

Or you could put the following macro into your Personal.XLSM file.

Sub PasteFormats()
Selection.PasteSpecial Paste:=xlPasteFormats
End Sub

and assign it a keyboard shortcut.

 

[Sascha]

Hi,

I only now the "Format Painter" (brush icon) - to copy and paste formatting
from one cell to an other.
I think there is no keyboard shortcut availible in Excel.