Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Kenny Dee
 
Posts: n/a
Default 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   Report Post  
Mike
 
Posts: n/a
Default

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   Report Post  
SVC
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import data from files with different names to EXCEL D'base. thunderfoot Excel Discussion (Misc queries) 2 June 10th 05 11:05 AM
Automatically opening several Excel Files at startup Peo Sjoblom Excel Discussion (Misc queries) 0 June 8th 05 05:20 PM
Excel Files Acting Weird Anat Excel Discussion (Misc queries) 0 March 29th 05 03:07 AM
Excel Files Won't Open From Shortcut ConfusedNHouston Excel Discussion (Misc queries) 5 December 31st 04 06:25 PM
Why do my links break when I burn multiple Excel files to a CD? akrr-rasmussen Excel Worksheet Functions 1 November 17th 04 02:39 AM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"