Copy and Paste Formats
I want to copy and paste a worksheet's format to a new workbook. Paste Format does not paste all the format info, i.e. colors, column width. How do I do this?
March 27th, 2015 9:02am
Select all the cells (use Ctrl-A), copy (Ctrl-C), paste in the other workbook / sheet (Ctrl-V) and then immediately press <Delete>
- Edited by Bernie Deitrick, Excel MVP 2000-2010Microsoft community contributor 18 hours 21 minutes ago
- Marked as answer by wwolfe01 9 hours 18 minutes ago
Free Windows Admin Tool Kit Click here and download it now
March 27th, 2015 9:08am
You cannot copy column width together with rest of stuff (otherwise than copying all). If you want to copy width, use "paste special".
March 27th, 2015 9:16am
Select all the cells (use Ctrl-A), copy (Ctrl-C), paste in the other workbook / sheet (Ctrl-V) and then immediately press <Delete>
- Edited by Bernie Deitrick, Excel MVP 2000-2010Microsoft community contributor Friday, March 27, 2015 1:07 PM
- Marked as answer by wwolfe01 Friday, March 27, 2015 10:10 PM
Free Windows Admin Tool Kit Click here and download it now
March 27th, 2015 1:07pm
You cannot copy column width together with rest of stuff (otherwise than copying all). If you want to copy width, use "paste special".
March 27th, 2015 1:15pm
This topic is archived. No further replies will be accepted.
Other recent topics
