ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Format pasting using keyboard shortcuts (https://www.excelbanter.com/excel-discussion-misc-queries/22797-format-pasting-using-keyboard-shortcuts.html)

Griff

Format pasting using keyboard shortcuts
 
Hi,

I am working on a Spreadsheet project where I have to use the keyboard to
Copy & Paste a Format from one cell to another.

Does anyone know how this can be done.

In Word to Copy & Paste a Format it is CTRL Shift C, CTRL Shift V which does
not appear to be the case in Excel.

Regards,

Lynda



JulieD

Hi Griff

not as easy as Word but
Control & C to copy

Alt & E then S then T and enter
to paste format

(personally, i would use the format painter icon on the standard toolbar)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Griff" wrote in message
...
Hi,

I am working on a Spreadsheet project where I have to use the keyboard to
Copy & Paste a Format from one cell to another.

Does anyone know how this can be done.

In Word to Copy & Paste a Format it is CTRL Shift C, CTRL Shift V which
does
not appear to be the case in Excel.

Regards,

Lynda






All times are GMT +1. The time now is 02:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com