[Fixed!] Excel Margins Disappeared (4 Possible Solutions)

Get FREE Advanced Excel Exercises with Solutions!

In this tutorial, I am going to show you 4 possible solutions to the Excel margins disappeared problem. You can quickly use these fixes even in large datasets to bring back the worksheet margin and modify it if you need to. Throughout this tutorial, you will also learn some important Excel tools and functions that will be very useful in any Excel-related task.


Excel Margins Disappeared: 4 Possible Solutions

We have taken a concise dataset to explain the steps clearly. The dataset has approximately 6 rows and 2 columns. Initially, we formatted all the cells containing dollar values in Accounting format. For all the datasets, we have 2 unique columns which are Product and Price. Although we may vary the number of columns later on if that is needed.

excel margins disappeared


1. Utilizing Margin Markers

In this first method, we will use the Margin Markers in Excel to try to fix the margins disappeared problem. Follow the steps below to do this.

Steps:

  • First, click on the File tab on top of the screen.

margin markers to solve the Excel margins disappeared problem

  • Now, click on the Print option in the left panel.

  • Next, click on the Show Margins option at the bottom-left corner of the screen.

  • Consequently, this will enable the Margin Markers which you can now adjust and try to make the margin visible again.


2. Recovering Disappeared Excel Margins by Changing Workbook Views

You can also try to change the workbook views in Excel if the margin has disappeared. Below are the detailed steps.

Steps:

  • To begin with this method, click on the View tab and go to Workbook Views.
  • Under this, click on Page Layout.

changing workbook views to solve the Excel margins disappeared problem

  • Next, take the mouse cursor just below the row header and double-click when the Show White Space indicator appears.

  • As a result, this should bring the margin back to the worksheet.

Thus you can add some margins by changing the workbook views.

Read More: How to Add Margin in Excel


3. Using Custom Margin

There is another option which is the Custom Margins option that can probably solve the Excel margins disappeared problem. You can try this solution by following the steps below.

Steps:

  • To start with, go to the Page Layout tab and click on the Margins drop-down under this tab.

using custom margin to solve the Excel margins disappeared problem

  • Then, click on Custom Margins.

  • Next, in the Page Setup window, manually adjust the margin using the arrow buttons and it should make the margin visible although it might take some iterations.
  • When you are done, click OK.

Read More: How to Apply Margin Setting in Excel


4. Editing Excel Options

If the above methods did not work for you, then you can still try to directly modify the margin setups in the Excel print options. Here is how to do it.

Steps:

  • For this, click on the File tab as we did previously.

editing excel options to solve the Excel margins disappeared problem

  • Then, click on the Print option in the left panel.
  • After that, click on the Normal Margins drop-down under Settings.

  • Finally, try and select from the available options which make the margin visible again.

Read More: How to Remove Print Margins in Excel


Things to Remember

  • You can use the shortcut Alt+P to go to the Page Layout tab quickly.
  • The Page Setup window gives the option to Print Preview to check the margin.
  • Changing the orientation of the page might be another possible way to modify the margin.
  • Use the shortcut Alt+F to go to the File tab in Excel.
  • Note that Excel gives the option to modify the margins of multiple worksheets at the same time.

Download Practice Workbook

You can download the practice workbook from here.


Conclusion

I hope that you were able to apply the fixes that I showed in this tutorial on 4 possible solutions to the Excel margins disappeared problem. As you can see, there are quite a few ways to achieve this. So wisely choose the solution that suits your situation best. If you get stuck in any of the steps, I recommend going through them a few times to clear up any confusion. If you have any queries, please let me know in the comments.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Nazmul Hossain Shovon
Nazmul Hossain Shovon

Hello, I am Nazmul Hossain. I am currently working full-time in Exceldemy as an Excel & VBA Content Developer. I have completed my bachelors in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. I am interested in working with MS Excel. I also like coding web applications a lot.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo