| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting part of a Spreadsheet into the Current Spreadsheet
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting part of a Spreadsheet into the Current Spreadsheet
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 "nytwodees" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting part of a Spreadsheet into the Current Spreadsheet
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.) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting part of a Spreadsheet into the Current Spreadsheet
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 "MyVeryOwnSelf" wrote: 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.) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a spreadsheet recognize the current directory it is in? | Excel Discussion (Misc queries) | |||
| How do I take gridlines off part of a spreadsheet? | Excel Discussion (Misc queries) | |||
| I can't insert a worksheet into my current spreadsheet file | Excel Worksheet Functions | |||
| How do I make my spreadsheet so part of it has it's own scrollbar | Excel Discussion (Misc queries) | |||
| Using a current spreadsheet to populate a new one | Excel Discussion (Misc queries) | |||
Linear Mode
