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