Excel Sheets Nagivations

Z

Zain Ul Rafi

New Member
Joined
Jan 2, 2019
Messages
1
i work with 200+ sheet on a Single Excel workbook.
I need nevigation tips.

Specially. Jumping on Last Sheet 1st sheet. On my Office pc i see a button to jump to first and last sheet. But not on home pc.

Microsoft Professional Plus 2016
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Sort by date Sort by votes
Have you tried right click on the sheet left/right arrows? It brings up a list of all the sheets to choose. Also, ctrl click the left or right arrows to get to the first or last sheets.
Rick
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Solved
How to fix this database?
Replies
5
Views
103
Alex Blakenburg
A
W
  • Question
Determine occurrence position in an array?
Replies
2
Views
191
wbtczn
W
L
  • Question
Correct mistaken info
Replies
1
Views
127
Lux Aeterna
L
JenniferMurphy
  • Question
Does Excel have a tool like Word does for comparing two workbooks?
Replies
8
Views
3K
6StringJazzer
6StringJazzer
L
  • Solved
Excel's built-in web browser
Replies
3
Views
582
Fluff
Fluff

Forum statistics

Threads
1,215,444
Messages
6,124,891
Members
449,194
Latest member
JayEggleton

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top