How to Zoom in When Zoom Slider Is Not Working in Excel

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.

Right-Clicking on Status Bar to Zoom in Excel

  • Then, click on Zoom Slider.

  • Now, you will find a Status Bar in the Excel Workbook.

Right-Clicking on Status Bar to Zoom in Excel

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.

Using Zoom Feature from View Tab to Zoom When Zoom Slider Is Not Working in Excel

  • 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%.

Using Zoom Feature from View Tab to Zoom When Zoom Slider Is Not Working in Excel

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.

Use of Keyboard Shortcuts to Zoom When Zoom Slider Is Not Working in Excel

  • Now, to zoom out Press CTRL +ALT+ Minus Sign on your Keyboard.

  • Then, you will find the worksheet zoomed out to 85%.

Use of Keyboard Shortcuts to Zoom When Zoom Slider Is Not Working in Excel

  • After that, to zoom in Press CTRL +ALT + Plus Sign on your Keyboard.

  • Finally, you will find the worksheet zoom in to 100%.

Use of Keyboard Shortcuts to Zoom When Zoom Slider Is Not Working in Excel

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.

Using Scroll Wheel to Zoom

  • 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%.

Using Scroll Wheel to Zoom


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.

Applying VBA Code to Zoom When Zoom Slider Is Not Working in Excel

  • 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.

Applying VBA Code to Zoom When Zoom Slider Is Not Working in Excel

  • 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

Applying VBA Code to Zoom When Zoom Slider Is Not Working in Excel

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.

Applying VBA Code to Zoom When Zoom Slider Is Not Working in Excel

  • 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%.

Applying VBA Code to Zoom When Zoom Slider Is Not Working in Excel

  • 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.

Applying VBA Code to Zoom When Zoom Slider Is Not Working in Excel

  • 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!


Related Articles

Arin

Arin

Hello, I'm Arin. I graduated from Khulna University of Engineering and Technology (KUET) from the Department of Civil Engineering. I am passionate about learning new things and increasing my data analysis knowledge as well as critical thinking. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo