Working with Columns

  • Thread starter Thread starter Kaye
  • Start date Start date
K

Kaye

I have a spreadsheet with data in four columns. I need to
place information from another spreadsheet that is in 13
columns above the spreadsheet that has data in four
columns. This needs to be done without changing the size
of the columns in either spreadsheet. Can this be done?
If so, does anyone know how?
 
Kaye wrote....
I have a spreadsheet with data in four columns. I need to
place information from another spreadsheet that is in 13
columns above the spreadsheet that has data in four
columns. This needs to be done without changing the size
of the columns in either spreadsheet. Can this be done?
If so, does anyone know how?
Click to expand...

You can add rows above your data in the four columns. Just select a "bunch"
of rows, and then Insert | Rows.

With regard to your column widths, if the overlapping columns from the 13
column and 4 column data sets are of different widths, then you are stuck.
A column can only have ONE column width. You might want to merge cells (see
XL's help) for certain regions.

Can you let us know why the column widths can't change? That might provide
us with some alternative thoughts.

Best regards,
Kevin
 
Back
Top