Inserting part of a Spreadsheet into the Current Spreadsheet

N

nytwodees

I have a spreadsheet that has various sized columns. I would like to insert
or add to this spreadheet at the bottom or top of it, a group of 2 rows and 9
columns with the columns being of equal widths. Since my original
spreadsheet has columns of various widths, is it possible to attach or append
in any way with the equally columned width section?
 
K

Kassie

The answer is no. you can insert it to the right of your existing data,
though, where column widths will not be affected.

--
HTH

Kassie

Replace xxx with hotmail
 
M

MyVeryOwnSelf

I have a spreadsheet that has various sized columns. I would like to
insert or add to this spreadheet at the bottom or top of it, a group
of 2 rows and 9 columns with the columns being of equal widths. Since
my original spreadsheet has columns of various widths, is it possible
to attach or append in any way with the equally columned width
section?

Maybe something like this would help.

Save a second worksheet in a separate file, then close Excel.

Then, open the first file and use
Insert > Object > Create from file > Browse
and select the separate file.

(I have Excel 2003.)
 
N

nytwodees

Hi MyVeryOwnSelf:

I did what you suggested using Excel 2000 and it worked! Note in this
version of Excel the formating was truncated when I inserted the 2nd file. I
was able to see the whole inserted file in Print Preview mode however. That
is where I was able to see everything and was able to adjust the inserted box
to my preference.

Dan
 

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

Top