copying Excel column names and widths to a blank spreadsheet

  • Thread starter Louis B Moskowitz
  • Start date
L

Louis B Moskowitz

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 ?
 
R

Roger Govier

Hi Louis

Copy the source data, then on the new sheet Paste Special>Format
followed by Paste Special Values
 
Top