copying Excel column names and widths to a blank spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ?
 
Hi Louis

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

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

How do I stop cell contents from spilling into the next cell? 4
column width 3
Column widths - strange problem 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Inserting part of a Spreadsheet into the Current Spreadsheet 3
Spreadsheet column width from html 2
Column widths in Excel 2013 16
Header Columns 2

Back
Top