ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Adding several Excel files into one (https://www.excelbanter.com/new-users-excel/35942-adding-several-excel-files-into-one.html)

Kenny Dee

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



Mike

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




SVC

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





All times are GMT +1. The time now is 06:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com