View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Yep.

Just click on the first worksheet tab and ctrl-click on subsequent.

(or click and shift-click to extend the range of selected worksheets)

Be careful to ungroup (rightclick on one of the grouped worksheets tabs) and
select "ungroup sheets") when you're done.

(you can get them all by rightclicking on a worksheet tab and choosing "select
all sheets", too.)

jaking wrote:

I am trying to migrate Lotus 123 spreadsheets to Excel.

Multi sheet spreadsheets are "Grouped" in order that changes in format (add or
delete lines, columns, etc) on one sheet are made to all sheets.

Does Excel have a similar function?


--

Dave Peterson