Moving multiple worksheets

[Paul Hyett]

Is there a way to move more than one worksheet at a time to another
spreadsheet (Excel 2003)? When I tried this today, it locked Excel up.

 

[Per Jessen]

Hi Paul

This should work:

Select the sheets to move (select first sheet, then select next sheet(s)
while holding down CTRL key). Right click a selected sheet tab > Move or
Copy > To Book: Select book > OK

Hopes this helps.
....
Per

 

[Paul Hyett]

"Paul Hyett" <[email protected]> skrev i meddelelsen

Hi Paul

This should work:

Select the sheets to move (select first sheet, then select next
sheet(s) while holding down CTRL key). Right click a selected sheet tab

Hopes this helps.

Thank you - it does.

Wonder why trying it by the Edit menu made it lock up?