
Locate the Standard Toolbar at the very top of your Excel file, or workbook.

First Way: Use the Standard Toolbar Zoom Option These instructions work for both Excel: Mac 20. If you want to change the view to see only one worksheet at a time, there are two simple ways to configure it. Perhaps you have data on only the first page or you want to focus on only one page at a time. This default configuration includes a view wherein you see multiple worksheets. When you open workbooks in Excel:Mac 20, you are presented with a default screen setup. The same goes for Microsoft, try though they may. No company can anticipate the desires of every consumer every time.


You can simply drag and drop the scroll bar to the required position. Unfortunately, Mac will move page by page regardless of where you click the sidebar. Generally you may expect the content to move to the scroll bar position where you have clicked on the sidebar. Simply enabling scroll bar is not sufficient in most cases.
#NEED ZOOM SCROLL BAR ON EXCEL FOR MAC 2011 FOR MAC HOW TO#
Related: How to manage desktop in Mac? Scroll Bar Movement Choose this option to work smoothly with your documents. This is a good option, in our opinion, to bring the scroll bar permanently back regardless of you have external mouse or not. That means, you will see the scroll bars only when you move the cursor up or down using double finger swipe. This option does the same function as previous option without external mouse.

And toggle the scroll bar based on trackpad movement when you have no external mouse. So enabling automatic option will basically show the scroll bars when you have a mouse plugged. You can move the bars either using mouse or using trackpad, arrow keys or spacebar. You will permanently see the scroll bars. Now plugin your mouse using a cable or USB and check the document.
