pasting column and row width and heights

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

Guest

When I copy data where the column width and the row heights have been changed why doesn't it keep the column width and row heights?
 
can't answer the "why" question but

if after pasting the data and with the paste range still highlighted you
choose edit / paste special and tick column widths and then ok you'll be
half way there.

(this works in excel 2000 and above)

Cheers
JulieD

"Pasting column width and row heights" <Pasting column width and row
(e-mail address removed)> wrote in message
When I copy data where the column width and the row heights have been
Click to expand...
changed why doesn't it keep the column width and row heights?
 
And if you copy the whole row/column, then the rowheight/columnwidth will be
brought with.
 
You must log in or register to reply here.

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

row height 1
Need help on formatting row height 1
excel 2007 copy row heights 3
Copy Row Heights 4
Copying excel worksheets to new worksheet 2
rows and columns on worksheet 1
Changing Row Height/Column Width 4
Row Height-Auto Adjust to Content? 5

Back
Top