all tabs control home

C

ch

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.
 
P

paul

right click down on one of the tabs(not the first one),select all sheets,ctrl
home selet sheet 1,save, close
 
Top