right click down on one of the tabs(not the first one),select all sheets,ctrl
home selet sheet 1,save, close
--
paul
remove nospam for email addy!



"ch" wrote:

I can't seem to find a way to do it, but I'd like to. It would be very
helpful in spreadsheets with many tabs. Before I save a workbook I use
control home and page up to get all sheets to the top of the data. Is there
a faster way to do this? Many thanks for replies.