Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I merge two excel sheets from one excel workbook
Hi
I have one excel workbook which has two forms created in different sheets. They have different column and row formats. Is they a way I can make that two forms in different sheets, one form in one sheet.(I mean one form underneath the other) Thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I merge two excel sheets from one excel workbook
Not easily if you want different column widths for each part of the one
sheet. You could take a picture of the second sheet using the Camera Tool and paste that under the area on the first sheet. Set all cells under the picture to white background so's the gridlines won't show through. Gord Dibben MS Excel MVP On Wed, 10 Dec 2008 13:06:03 -0800, Ash wrote: Hi I have one excel workbook which has two forms created in different sheets. They have different column and row formats. Is they a way I can make that two forms in different sheets, one form in one sheet.(I mean one form underneath the other) Thanks in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I merge two excel sheets from one excel workbook
But the camera tool does not work when I select the sheet and press the camera icon to take a pic. Please advice Thanks "Gord Dibben" wrote: Not easily if you want different column widths for each part of the one sheet. You could take a picture of the second sheet using the Camera Tool and paste that under the area on the first sheet. Set all cells under the picture to white background so's the gridlines won't show through. Gord Dibben MS Excel MVP On Wed, 10 Dec 2008 13:06:03 -0800, Ash wrote: Hi I have one excel workbook which has two forms created in different sheets. They have different column and row formats. Is they a way I can make that two forms in different sheets, one form in one sheet.(I mean one form underneath the other) Thanks in advance |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I merge two excel sheets from one excel workbook
Select the range you want to take a picture of.
Say A1:M32 Click on Camera tool and you will get a + sign appear. Click anywhere on the sheet and a picture of the selected range will appear. Copy or Cut that picture......switch to other sheet and EditPaste SpecialPicture(Enhanced Metafile) Or just select a range and SHIFT + EditCopy PictureAs shown on screenFormatPictureOK EditPaste.........only one choice.......enhanced metafile. Gord On Wed, 10 Dec 2008 16:41:01 -0800, Ash wrote: But the camera tool does not work when I select the sheet and press the camera icon to take a pic. Please advice Thanks "Gord Dibben" wrote: Not easily if you want different column widths for each part of the one sheet. You could take a picture of the second sheet using the Camera Tool and paste that under the area on the first sheet. Set all cells under the picture to white background so's the gridlines won't show through. Gord Dibben MS Excel MVP On Wed, 10 Dec 2008 13:06:03 -0800, Ash wrote: Hi I have one excel workbook which has two forms created in different sheets. They have different column and row formats. Is they a way I can make that two forms in different sheets, one form in one sheet.(I mean one form underneath the other) Thanks in advance |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I merge two excel sheets from one excel workbook
I can do that great but won't i be able to fill the form online????
Please advice "Gord Dibben" wrote: Select the range you want to take a picture of. Say A1:M32 Click on Camera tool and you will get a + sign appear. Click anywhere on the sheet and a picture of the selected range will appear. Copy or Cut that picture......switch to other sheet and EditPaste SpecialPicture(Enhanced Metafile) Or just select a range and SHIFT + EditCopy PictureAs shown on screenFormatPictureOK EditPaste.........only one choice.......enhanced metafile. Gord On Wed, 10 Dec 2008 16:41:01 -0800, Ash wrote: But the camera tool does not work when I select the sheet and press the camera icon to take a pic. Please advice Thanks "Gord Dibben" wrote: Not easily if you want different column widths for each part of the one sheet. You could take a picture of the second sheet using the Camera Tool and paste that under the area on the first sheet. Set all cells under the picture to white background so's the gridlines won't show through. Gord Dibben MS Excel MVP On Wed, 10 Dec 2008 13:06:03 -0800, Ash wrote: Hi I have one excel workbook which has two forms created in different sheets. They have different column and row formats. Is they a way I can make that two forms in different sheets, one form in one sheet.(I mean one form underneath the other) Thanks in advance |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I merge two excel sheets from one excel workbook
I said it wouldn't be easy<g
Column widths and row heights are properties of the entire column and row. Having different column widths for top and bottom half of a sheet is not possible.............that's why I posted the "make a picture" method but that obviously won't work in your situation. To have an editable sheet without a picture would require merging cells in the lower or upper half to get the appearance of differing column widths. I hesitate to recommend merged cells but is probably your only option. Merged cells can give rise to a number of problems with sorting, filtering, copying, pasting and other functions. Gord On Wed, 10 Dec 2008 19:19:01 -0800, Ash wrote: I can do that great but won't i be able to fill the form online???? Please advice "Gord Dibben" wrote: Select the range you want to take a picture of. Say A1:M32 Click on Camera tool and you will get a + sign appear. Click anywhere on the sheet and a picture of the selected range will appear. Copy or Cut that picture......switch to other sheet and EditPaste SpecialPicture(Enhanced Metafile) Or just select a range and SHIFT + EditCopy PictureAs shown on screenFormatPictureOK EditPaste.........only one choice.......enhanced metafile. Gord On Wed, 10 Dec 2008 16:41:01 -0800, Ash wrote: But the camera tool does not work when I select the sheet and press the camera icon to take a pic. Please advice Thanks "Gord Dibben" wrote: Not easily if you want different column widths for each part of the one sheet. You could take a picture of the second sheet using the Camera Tool and paste that under the area on the first sheet. Set all cells under the picture to white background so's the gridlines won't show through. Gord Dibben MS Excel MVP On Wed, 10 Dec 2008 13:06:03 -0800, Ash wrote: Hi I have one excel workbook which has two forms created in different sheets. They have different column and row formats. Is they a way I can make that two forms in different sheets, one form in one sheet.(I mean one form underneath the other) Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge 2 Excel sheets | Excel Discussion (Misc queries) | |||
Merge sheets to Workbook | Excel Worksheet Functions | |||
I have 100 excel sheets how can I merge all data into one sheet | Excel Worksheet Functions | |||
merge data in different excel sheets of same format in one sheet | Excel Worksheet Functions | |||
How can I merge and purge two excel work sheets? | New Users to Excel |