Varying column widths

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

Guest

I have 2 excel sheets - one is 20 columns wide the 2nd is 7 columns wide.
The 20 column sheet has a general information section at the top that I would
like to add to the 7 coulmn spreadsheet. However, when I copy and paste it
"spreads out" or goes way beyond the width due to the number of columns. I
have tried paste special object and entering the excel sheet that way and it
doesn't fit properly and too many cells are shown. Any other way to do this?
 
If you only want it up there for appearance purposes, you can try:

Copy the selection.
Click the cell where you want to paste it.
Hold down shift, the click EDIT and paste picture.
Then you can resize the picture.

Or.....
Perhaps you have a problem with merged cells in your copy area. Try unmerging
 

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

Column width in inches??? 3
Pick list width 4
worksheet change question 1
Remove date format? 3
column width 2
Column width 1
varying column widths 4
Excel 2007 Is it possible to vary the column width between rows? 3

Back
Top