![]() ![]() We will learn all the different ways one by one in this tutorial. There are different ways to zoom in your Excel document. If you want to increase the size of your excel workbook, you can zoom in and increase the percentage upto 400% by moving the zoom slider to the right. ![]() Follow the below steps to directly zoom in from the excel status bar. Point your mouse cursor to the plus symbol located in the right hand side of excel status bar. Move the bar to the point you want to zoom in on the excel workbook. Unlike in the below image, we have zoomed it to 200%. Note: Zooming in will only alter the view of the document. You can zoom out your document by moving the zoom slider to its left side. Unlike in the below image, we have zoomed out to 20%. Method 3: Zoom to a specific percentageįollow the given below steps to zoom a specific percentage in your workbook:įrom the Excel ribbon bar, click on view -> zoom. Either select any zooming percentage from the magnification section or choose the custom option and on its checkbox, enter any number between 10 and 400.Ĭlick on OK to execute the zoom out percentage. To zoom some selected cells, follow the given below steps: Method 4: Zoom in specific range of cells If you try to enter a number smaller than 10 or greater than 400, Excel will immediately throw an alert box stating "The number must be in the range of 10 to 400." You will notice your sheet has been zoomed in. Select the range of cells that you wish to zoom out.įrom the Excel ribbon bar, click on view -> zoom to Selection.Īs you can see below, Excel will automatically zoom it out to its maximum limit i.e, 400%. The advantage of using Excel is it provides shortcuts for almost every feature. It provides various mouse and keyboard shortcuts to zoom in and zoom out on your Excel sheet. It also allows the users to create their custom zoom buttons to access this feature quickly. Zoom in and zoom out your Excel workbook using your mouse.For WindowsĬheck out the following great strategies for zooming in and out using the mouse or the keyboard in Excel. To use this shortcut, make sure that your mouse has a wheel in its central part. Zoom in and zoom out your Excel workbook using a keyboard (only for 2016 or later versions).Press the 'Ctrl' button on your keyboard while rolling the mouse wheel forward (to zoom in) or backward (to zoom out) direction. To zoom in press Ctrl + Alt + plus sign (+).If your system has Excel 2016 or a later version, you can use the keyboard shortcut to quickly zoom in or zoom out. To zoom out press Ctrl + Alt + minus sign (-).Add zoom buttons to your customized Quick Access Toolbar.You can also create a customized Quick Access Toolbar and add zoom buttons to it by following the below given steps:įrom the Excel ribbon bar, click on the File tab. In the Project Window right-click the VBAProject (PERSONAL.XLSB) and click Insert > Module on the shortcut menu.The Excel options window will be displayed.Press Alt + F11 to open the Visual Basic Editor. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |