all tabs control home

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

[paul]

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.

[kcoutts]

Hi,

In Excel 365, is there a shortcut or easy set of steps to achieve Ctrl + Home on MULTIPLE worksheets simultaneously? Tip above does not seem to work for me.

[AliGW]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: link to be added here