Go to first/last tabs
In the previous versions of Excel, I was able to go the first/last tab by using the arrow buttons adjacent to the ones that move the tabs left or right. I am using spreadsheets with many tabs and I found this feature quite useful in the past to go to the end or beginning of all the tabs.
I don't understand why there are now two redundant ways to scroll through the tabs. I have not seen a difference between the left/right arrows and the ellipsis to either side of the tabs. Why don't you bring back the go to first/last tab arrows.
You can navigate to the first and last sheet in the workbook by holding down the CTRL key while clicking on the Scroll Sheet Left or Right buttons.
63 commentsComments are closed
The lack of these buttons is very inconvenient, I don't know why they were removed as they were helpful in the event the first sheet is an index as I frequently encounter in my job. It is very annoying and time consuming to scroll all the way back through 500 sheets to get back to the index. I have tried using Macro keys which works temporarily, but is now resulting in an error and I have to go back to the manual scrolling. The absence of these buttons is slowing down my job efficiency, so please add these back in for the functionality of the people who use hundreds of worksheets in one excel document frequently!!
Dennis Taylor commented
Although not instantaneous, holding down both the Ctrl and PgDn keys will quickly activate the last worksheet in the current workbook; holding down both the Ctrl and PgUp keys will quickly activate the first worksheet in the workbook
Zack Barresse commented
The arrows will only navigate the sheets, not actually make an activation. The elipses will actually make an activation on the next visible sheet on the far left/right.
You can also right-click the left/right arrows and get the activate sheet dialog box.
And I agree, I miss those buttons. :)