Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

It is a simple Copy-Paste. But you have to paste only formats (with the Paste special option)

try this: 1- Select the entire sheet: click on the top-left corner (column and row headers) 2- Copy the sheet: <ctrl> + <c> (or with the mouse: Right Click > Copy) 3- Open a new sheet 4- Position en the the A1 cell (the default) 5- <ctrl> + <shift> + <v> ( or with the mouse: Right Click > Paste special > Paste special) 6- Paste only formats: on the menu: uncheck everything but Formats. Click on OK. (or just press Eter if OK button is highlighted)

It copies almost every format. But not thins like conditional formatting, I think.

It is a simple Copy-Paste. But you have to paste only formats (with the Paste special option)

try this: 1- Select the entire sheet: click on the top-left corner (column and row headers) 2- Copy the sheet: <ctrl> + <c> (or with the mouse: Right Click > Copy) 3- Open a new sheet 4- Position en the the A1 cell (the default) 5- <ctrl> + <shift> + <v> ( or with the mouse: Right Click > Paste special > Paste special) 6- Paste only formats: on the menu: uncheck everything but Formats. Click on OK. (or just press Eter Enter if OK button is highlighted)

It copies almost every format. But not thins like conditional formatting, I think.

It is a simple Copy-Paste. But you have to paste only formats (with the Paste special option)

try this: 1- Select the entire sheet: click on the top-left corner (column and row headers) 2- Copy the sheet: <ctrl> + <c> (or with the mouse: Right Click > Copy) 3- Open a new sheet 4- Position en the the A1 cell (the default) 5- <ctrl> + <shift> + <v> ( or with the mouse: Right Click > Paste special > Paste special) 6- Paste only formats: on the menu: uncheck everything but Formats. Click on OK. (or just press Enter if OK button is highlighted)

It copies almost every format. But not thins like conditional formatting, I think.

It is a simple Copy-Paste. But you have to paste only formats (with the Paste special option)

try this: 1- Select the entire sheet: click on the top-left corner (column and row headers) 2- Copy the sheet: <ctrl> + <c> (or with the mouse: Right Click > Copy) 3- Open a new sheet 4- Position en the the A1 cell (the default) 5- <ctrl> + <shift> + <v> ( or with the mouse: Right Click > Paste special > Paste special) 6- Paste only formats: on the menu: uncheck everything but Formats. Click on OK. (or just press Enter if OK button is highlighted)

(Not sure if the shortcut <ctrl> + >Shift> + <v> does the same on different OS. So you have the mouse way)

It is a simple Copy-Paste. But you have to paste only formats (with the Paste special option)

try this: 1- Select the entire sheet: click on the top-left corner (column and row headers) 2- Copy the sheet: <ctrl> + <c> (or with the mouse: Right Click > Copy) 3- Open a new sheet 4- Position en the the A1 cell (the default) 5- <ctrl> + <shift> + <v> ( or with the mouse: Right Click > Paste special > Paste special) 6- Paste only formats: on the menu: uncheck everything but Formats. Click on OK. (or just press Enter if OK button is highlighted)

(Not sure if the shortcut <ctrl> + >Shift> <shift> + <v> does the same on different OS. So you have the mouse way)

It is a simple Copy-Paste. But you have to paste only formats (with the Paste special option)

try this: 1- Select the entire sheet: click on the top-left corner (column and row headers) 2- Copy the sheet: <ctrl> + <c> (or with the mouse: Right Click > Copy) 3- Open a new sheet 4- Position en the the A1 cell (the default) 5- <ctrl> + <shift> + <v> On the menu bar: Edit > Paste Special ( or with the mouse: Right Click > Paste special > Paste special) 6- Paste only formats: on the menu: uncheck everything but Formats. Click on OK. (or just press Enter if OK button is highlighted)

(Not sure if the shortcut <ctrl> + <shift> + <v> does the same on different OS. So you have the mouse way)