Transferring column width format from a worksheet?

S

Salmon Egg

To be specific, I will describe the situation for an address/telephone
spreadsheet. This sheet will columns of various widths. One for area
code needs only ton handle three digit entries while the basic number
needs eight characters if you include the hyphen. A street address could
be fairly long, 20 characters or more. A state code needs only two.

If I want another sheet with the same column widths as one I like, how
can you transfer the column width formatting? Paste Special format does
not seem to transfer column widths.

Bill
 
S

Salmon Egg

Gord Dibben said:
Have you tried paste special>column widths?


Gord Dibben MS Excel MVP
Click to expand...

Wow! I was so used to not seeing that possibility. Even after it was
added to more recent versions of Excel, I continued not to see it. I
also have visual deficiency.

Thanks for jolting me out of my rut.

Bill
 

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

Format column widths from one table to a separate table on same page 1
How do you create a new BLANK worksheet with same cell format as another? 5
Unable to set the desired column width for a table with merged cells 0
Unable to set the desired column width for a table with merged cells 0
Column widths in Excel file randomly expanding 0
Simple Chart Column Question - Hold Format Width 0
Column Width Problem 8
column width 1

Top