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. Throughout this tutorial, you will also learn some important excel tools and functions which will be very useful in any excel related task.
Download Practice Workbook
You can download the practice workbook from here.
4 Possible Solutions If Excel Margins Are Disappeared
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.
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.
- First, click on the File tab on top of the screen.
- 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.
- To begin with this method, click on the View tab and go to Workbook Views.
- Under this, click on Page Layout.
- 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.
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 use try this solution by following the steps below.
- To start with, go to the Page Layout tab and click on the Margins drop-down under this tab.
- 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.
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.
- For this, click on the File tab as we did previously.
- 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.
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.
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. Lastly, to learn more excel techniques, follow our ExcelDemy website. If you have any queries, please let me know in the comments.