Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding several Excel files into one
I have about three separate Excel forms that I want to put into one file but
on their own spread sheet. Can this be done? If so, can it be done with me having to resize the cells. I've tried this before with cut and paste but I have to resize the cells. Too much for allot of cells. Thanks in advance |
#2
|
|||
|
|||
First do a PASTE SPECIAL and select Column Widths then do a simple paste.
"Kenny Dee" wrote: I have about three separate Excel forms that I want to put into one file but on their own spread sheet. Can this be done? If so, can it be done with me having to resize the cells. I've tried this before with cut and paste but I have to resize the cells. Too much for allot of cells. Thanks in advance |
#3
|
|||
|
|||
A simple solution is to use Edit Move or Copy. This process will create an
exact copy of your worksheets. Here's how: Open your destination workbook, then your source workbook. While in the source workbook in the desired worksheet, click Edit Move or Copy. Change "To book" to the destination workbook, and select the Before worksheet destination. Check the "Create a copy" box at the bottom to keep your present source workbook in tact. Repeat the same steps for yoour other workbook/worksheet. "Kenny Dee" wrote: I have about three separate Excel forms that I want to put into one file but on their own spread sheet. Can this be done? If so, can it be done with me having to resize the cells. I've tried this before with cut and paste but I have to resize the cells. Too much for allot of cells. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import data from files with different names to EXCEL D'base. | Excel Discussion (Misc queries) | |||
Automatically opening several Excel Files at startup | Excel Discussion (Misc queries) | |||
Excel Files Acting Weird | Excel Discussion (Misc queries) | |||
Excel Files Won't Open From Shortcut | Excel Discussion (Misc queries) | |||
Why do my links break when I burn multiple Excel files to a CD? | Excel Worksheet Functions |