how do I merge two excel sheets from one excel workbook

[Ash]

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

 

[Gord Dibben]

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

 

[Ash]

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]

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 Edit>Paste
Special>Picture(Enhanced Metafile)

Or just select a range and SHIFT + Edit>Copy Picture>As shown on
screen>Format>Picture>OK

Edit>Paste.........only one choice.......enhanced metafile.


Gord

 

[Ash]

I can do that great but won't i be able to fill the form online????

Please advice

 

[Gord Dibben]

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