Last answered:

30 Jun 2023

Posted on:

27 Jun 2023

4

A short cut made even shorter...

Related to this lesson on going to A1 for each sheet in a workbook....especially if I have a lot of tabs, I like to hold shift and select all tabs in my workbook, then go to cell A1 in the sheet that is active after selecting all sheets.  Saving the file and then opening it will have all sheets in cell A1.  Also, if you have many tabs, you can right click on any tab and choose 'Select all sheets' and then proceed to go to cell A1 in the active sheet.  Hope this is useful.

1 answers ( 0 marked as helpful)
Instructor
Posted on:

30 Jun 2023

0

Great info, Lisa!! Thanks so much for contributing! Appreciate it.

Submit an answer