ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   copying Excel column names and widths to a blank spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/145533-copying-excel-column-names-widths-blank-spreadsheet.html)

Louis B Moskowitz

copying Excel column names and widths to a blank spreadsheet
 
How can I copy Excel column names and widths to a new blank spreadsheet and
have them appear exactly the same as they did in the original spreadsheet ?

Roger Govier

copying Excel column names and widths to a blank spreadsheet
 
Hi Louis

Copy the source data, then on the new sheet Paste SpecialFormat
followed by Paste Special Values

--
Regards

Roger Govier


"Louis B Moskowitz" <Louis B wrote
in message ...
How can I copy Excel column names and widths to a new blank
spreadsheet and
have them appear exactly the same as they did in the original
spreadsheet ?





All times are GMT +1. The time now is 05:56 AM.

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