Drop the command on the toolbar wherever you want it by releasing the mouse button. You will see a vertical line showing you where the icon would appear if you dropped it. Click on “Zoom To One Page” at the bottom of the list and drag it out of the dialog box to any Excel toolbar on your screen. Scroll down the list of commands on the right side of the Commands dialog box.
To make your life even easier, you can customize any Excel: Mac toolbar with a one-click command for displaying one worksheet at a time.Ĭlick the “View” menu from the menu bar across the top of your screen.Ĭhoose “Customize Toolbars and Menus.” The Customize Toolbars and Menus dialog box appears. Second Way: Customize your Excel:Mac 20 Toolbars Now only one sheet shows up at a time from your workbook. Choose “One Page” from bottom of the list. If your toolbars have only icons, you can identify the Zoom command as a rectangular field with a percentage number in it and a dropdown arrow on the right side of it.Ĭlick the dropdown arrow on this rectangle to see a selection of page sizes and other options.
Choose “Toolbars” then “Standard” to place a checkmark beside it.įind the Zoom command on the Standard Toolbar.
If you don’t see this toolbar, click the “View” menu on the menu bar across the top of your screen. Commands on the toolbars will appear as icons only, or they may have text under the icons. The Standard toolbar is the one that has the commands for “New,” “Open” and so on. 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. Changing Excel:Mac 20 Default View Options
0 kommentar(er)
