Copy and paste formatting with keyboard in Excel 2007?

  • Thread starter Thread starter ajkessel
  • Start date Start date
A

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.
 
ajkessel said:
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.
Click to expand...

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.
 
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.
 
Back
Top