A navigable list of workbook tabs? [closed]

asked 2012-10-03 19:08:24 +0100

hunteke
463 ●4 ●15 ●17

Over the past 2 months, I have found myself working with workbooks that contain an average of 80 tabs. Unfortunately, it is quite a pain to navigate to the tab I need, for example while reading a formula, writing a formula, or reading data. Is there an more efficient method of navigation than scrolling through the tabs at the bottom of the window, or using Ctrl+PgUp and +PgDn?

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 04:30:38.946107

answered 2012-10-03 20:09:22 +0100

w_whalley

3837 ●6 ●22 ●45

Try out the Navigator (F5). It has a Sheets section that will show sheet names. Click on a sheet name to move there. It may also be helpful to open the spreadsheet in more than one window (Window/New Window.) You can use the Navigator with these windows. Click on a sheet to activate it, then click on a sheet name in the navigator and this will set the current sheet independently of sheets in other windows.

edit flag offensive delete link

Comments

Damn; thought I looked through all the menus before asking this question. Clearly not. Thanks for the pointer.

hunteke ( 2012-10-05 09:21:54 +0100 )edit

add a comment

A navigable list of workbook tabs? [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 04:30:38.946107

1 Answer

Comments

Question Tools

Stats

Related questions

A navigable list of workbook tabs? [closed] edit

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2015-10-18 04:30:38.946107

1 Answer

Comments

Question Tools

Stats

Related questions

A navigable list of workbook tabs? [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 04:30:38.946107