ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   all tabs control home (https://www.excelbanter.com/excel-discussion-misc-queries/78113-all-tabs-control-home.html)

ch

all tabs control home
 
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.

paul

all tabs control home
 
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.



All times are GMT +1. The time now is 02:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com