Copy column widths from one spreadsheet to another

D

drumbeat54

I need to copy (reapply) the column widths from my formatted
spreadsheet to another one. I get an new copy of the spreadsheet each
week from our finance admin with updated data and I want to copy over
just the column widths (and if possible hide certain columns) without
overwriting the updated spreadsheet's cell formats (font color and
highlights). I know about Format Painter but it seems to overwrite the
cell formats and other highlights.
Thanks, Joe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy column headings AND formula totals to blank spreadsheet 1
Copy and past ... and maintain all formats including column widths 2
How do I copy spreadsheet data as shown to another spreadsheet? 2
Copy part of one sheet to another while maintaining formatting 7
How do you copy and past data from one spreadsheet to another? 1
copying Excel column names and widths to a blank spreadsheet 1
How to copy & paste row heights and column widths to another page 2
Lookups - how to obtain data from a master spreadsheet into another 5

Top