Looking for ways to know how to zoom when the zoom slider is not working in Excel? Sometimes, we may find that the zoom slider is not added or is not working in Excel. This problem can be solved following some easy steps. Here, you will find 5 ways to zoom when the zoom slider is not working in Excel.
Download Practice Workbook
5 Alternative Ways to Zoom in When Zoom Slider Is Not Working in Excel
Here, you will find 5 step-by-step ways to zoom in or out in Excel when the Zoom Slider is not working.
1. Right-Clicking on Status Bar to Zoom in Excel
Here, we have a worksheet where the Status Bar is not added in Excel. In the first method, we will show you how to add the Zoom Slider if it is not added to your worksheet by Right-clicking on the Status Bar.
Follow the steps given below to do it on your own
Steps:
- In the beginning, go to the Status Bar and Right-click.
- Then, click on Zoom Slider.
- Now, you will find a Status Bar in the Excel Workbook.
Read More: Excel VBA: Zoom to Fit Screen (4 Suitable Examples)
2. Using Zoom Feature from View Tab to Zoom When Zoom Slider Is Not Working in Excel
We can also zoom in on Excel by using the Zoom Feature from View Tab when the Zoom Slider is not working in Excel. Here, we can see that the Workbook is 80% zoomed. We will change it to 100%.
Go through the steps given below to do it on your own.
Steps:
- Firstly, go to the View tab >> click on Zoom.
- Now, the Zoom box will open.
- Then, select 100%.
- After that, click on OK.
- Finally, you will see that the worksheet has zoomed in to 100%.
Read More: How to Zoom in Excel Graph (With Easy Steps)
3. Use of Keyboard Shortcuts to Zoom When Zoom Slider Is Not Working in Excel
Now, we will show you how to use Keyboard Shortcuts to zoom in or out when the Zoom Slider is not working in Excel. To zoom in we will use CTRL +ALT+ Plus Sign and zoom out we will use CTRL + ALT+ Minus Sign.
Steps:
- In the beginning, you can see that the Excel workbook is 100% zoomed.
- Now, to zoom out Press CTRL +ALT+ Minus Sign on your Keyboard.
- Then, you will find the worksheet zoomed out to 85%.
- After that, to zoom in Press CTRL +ALT + Plus Sign on your Keyboard.
- Finally, you will find the worksheet zoom in to 100%.
Read More: How to Zoom Out in Excel (7 Quick Methods)
4. Using Scroll Wheel to Zoom
We can also zoom in on Excel when the Zoom Slider is not working by using CTRL in Keyboard and Scroll Wheel Up or Down. Follow the steps given below to do it on your own.
Steps:
- Firstly, you can see that the Excel workbook is 100% zoomed in.
- Then, to zoom out press CTRL and Scroll Wheel Down.
- Now, you will find the worksheet zoomed out to 85%.
- After that, to zoom in Press CTRL on your Keyboard and Scroll Wheel Up.
- Finally, you will find the worksheet zoom in to 100%.
5. Applying VBA Code to Zoom When Zoom Slider Is Not Working in Excel
In the final method, we will show you how to zoom in or out when the Zoom Slider is not working in Excel. Go through the steps given below to do it on your own.
Steps:
- In the beginning, you can see that the Excel workbook is 80% zoomed.
- Then, go to the Developer tab >> click on Visual Basic.
- Now, Microsoft Visual Basic for Application box will open.
- After that, click on Insert >> select Module.
- Then, write the following code in your Module.
Sub Zoom_In_Worksheet()
Dim Increase_by As Integer
Increase_by = 5
On Error GoTo MaximumZoomReached
ActiveWindow.Zoom = ActiveWindow.Zoom + Increase_by
On Error GoTo 0
Exit Sub
MaximumZoomReached:
MsgBox "Can't zoom in any more", vbExclamation
End Sub
Sub Zoom_Out_Worksheet()
Dim decrease_by As Integer
decrease_by = 5
On Error GoTo MinimumZoomReached
ActiveWindow.Zoom = ActiveWindow.Zoom - decrease_by
On Error GoTo 0
Exit Sub
MinimumZoomReached:
MsgBox "Can't zoom out any more", vbExclamation
End Sub
Code Breakdown
- First, we created Sub Procedure as Zoom_In_Worksheet().
- Then, we declared Increased_by as Integer.
- After that, we used the On Error GoTo statement to go to the MaximumZoomReached label.
- Next, we used a formula to add the Increased_by value with the Zoom value of the Active Window.
- Now, we set the On Error GoTo statement to 0.
- After that, we created a MsgBox with a text as the MaximumZoomReached label.
- Similarly, we created Sub Procedure as Zoom_Out_Worksheet().
- Then, we declared decreased_by as Integer.
- Afterward, we used the On Error GoTo statement to go to the MinimumZoomReached label.
- Next, we used a formula to subtract the decreased_by value with the Zoom value of the Active Window.
- Now, we set the On Error GoTo statement to 0.
- Finally, we created a MsgBox with a text as the MinimumZoomReached label.
- Next, click on the Save button and go back to your worksheet.
- After that, go to the Developer tab >> click on Macros.
- Now, the Macros box will appear.
- Then, select Zoom_In_Worksheet.
- After that, click on Run.
- Now, you will find the worksheet zoom in to 85%.
- Next, to zoom out, go to the Developer tab >> click on Macros.
- Again, the Macros box will appear.
- Then, select Zoom_Out_Worksheet.
- After that, click on Run.
- Finally, you will find the worksheet zoom out to 80%.
Read More: How to Zoom Out on Excel Online (4 Quick Ways)
Conclusion
So, in this article, you will find 5 ways to zoom when the zoom slider is not working in Excel. Use any of these ways to accomplish the result in this regard. Hope you find this article helpful and informative. Feel free to comment if something seems difficult to understand. Let us know any other approaches which we might have missed here. And, visit ExcelDemy for many more articles like this. Thank you!