Look Who it Was Random video

Excel - Mastering Excel: Maximizing Sheet Tab Visibility & Easy Navigation - Episode 1160

499 views · Published 17 December 2009 · 2:14 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Mastering Excel: Maximizing Sheet Tab Visibility & Easy Navigation.

Welcome to another episode of the MrExcel podcast, where we bring you the best tips and tricks for mastering Excel. In today's episode, we'll be discussing a question sent in by Riham, who had a great idea for organizing his many worksheets. However, as much as we would love to see sheet tabs appear in two rows, unfortunately, it's not possible. But don't worry, we have some other tricks up our sleeves to help you make the most out of your sheet tabs.

Firstly, did you know that you can adjust the size of your scroll bar to see more sheet tabs? Simply click on the scroll bar and drag it to the right to reveal more tabs. And if you want to quickly jump to the beginning or end of your sheet tabs, just use the left-right arrows. But here's a little-known trick - right-click on the arrows and you'll see a list of the first 15 sheets. Click on "More Sheets" to see a complete list of all your sheets. This is a great way to quickly navigate through your many worksheets.

Now, if you have Easy-XL, you're in luck. This amazing tool has a feature called "Open Workbooks" that allows you to hover over a workbook and see a list of all the worksheets within it. And that's not all, the worksheet Navigator feature also lets you easily jump to a specific sheet, protect, print, or even combine multiple sheets. Easy-XL truly makes managing your worksheets a breeze.

Thank you, Riham, for your question and for inspiring us to share these helpful tips with our viewers. And thank you for tuning in to another episode of the MrExcel podcast. Don't forget to check out Easy-XL for even more Excel mastery. See you next time!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) Question from Riham Can Sheet Tabs Appear in Two Rows?
(00:12) Riham's idea and its limitations
(00:22) Maximizing sheet tabs visibility
(00:35) Using the scroll bar and right-clicking for more options
(01:14) Alternative solutions with Easy-XL
(01:38) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Left-right navigation of sheet tabs
Maximizing sheet tabs
More Sheets option
Obscure Excel tricks
Protect, Print, Combine functions in Easy-XL
Right-clicking for sheet list
Scroll bar size
Sheet tabs
Two rows of sheet tabs
Worksheet Navigator in Easy-XL


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152775/


Riham asks if there is any way to arrange the sheet tabs in two rows. While there is not, episode 1160 shows various ways of dealing with the issue.

More from this channel