7 Tricks To Fix Excel Worksheet Opens Minimized Problem

Summary:

Isn’t it quite an annoying task to maximize or resize the Excel application each time when you open it? Or how do you stop Excel from opening in a small window?

If you are looking for some best fixes to resolve Excel spreadsheet keeps minimizing problems then definitely this blog is going to help you out.

How To Fix Excel Worksheet Opens Minimized?

1# Quick Access Toolbar
2# Adjust Window Size
3# Printing Time Issue
4# Open Excel In Safe Mode
5# Disable add-in
6# Run Excel In Compatibility Mode
7# Maximize It From The Taskbar

Method 1# Quick Access Toolbar

Excel 2010 And Earlier

To fix Excel Worksheet opens minimized issue you can add a full-screen button on the Quick Access Toolbar.

Here are the steps that you should follow to fix Excel file not opening in full screen issue.

Excel 2013 And Later:

  • From the Excel ribbon make a tap overView” Now go to the “workbook views” group and make a right-click over “Full screen” option.
  • Now from the menu list choose “Add to quick access toolbar”
  • After this, you will see a small square size icon get added over your Quick Access Toolbar section.
  • When you press this icon you will notice that your Excel workbook gets opened in full-screen size.
  • In this opened full-screen window entire of your Excel ribbon completely goes disappeared.

Excel 2013 And Later:

  • Go to the left section of your Quick Access Toolbar and hit the arrow sign. Now choose the more command option from the drop-down menu.
  • This will open the “Excel options” window and then from the left panel choose the “Quick Access Toolbar> command not in the ribbon> toggle full-screen view>ok”.
  • After this, you will see a small square size icon get added over your Quick Access Toolbar section.
  • By pressing this icon you can easily toggle between full and minimized screen. By hitting the escape key you can take exit from the full-screen mode.

Method 2# Adjust Window Size

Sometime after opening the Excel spreadsheet all the cells, a gridline, column or row name seems missing.

Well, this Excel worksheet opens minimized issues that can be easily rectified by Adjusting Windows size.

Here are the steps to fix Excel file not opening in full-screen issue by adjusting the Excel windows size.

  • Open your Excel spreadsheet.
  • Go to the View tab in the Window section; hit the Arrange All option from the windows.
  • In the opened window of “Arrange Windows” you have to choose Tiled > OK.
  • You will see that the full screen of your spreadsheet starts appearing with the entire contents.

Note: but you have to repeat this procedure each time when you open the affected file. So it is not a permanent fix to resolve Excel worksheet opens minimized problem.

Method 3# Printing Time Issue

If your Excel keeps opening in small window at the time of printing the document then follow down the below-given steps.

1: Open your Excel file and make a tap over the File tab from the Excel ribbon.

2: From the opened drop-down menu choose print option.

3: At the bottom section of the opened print window hit the “Page Setup” option.

4: On the opened “page setup” window, go to the “page” tab and adjust 100%. to normal size. Tap to the ok button to save entire changes.

In this way, your excel file will attain the original size of the Excel file.

Method 4# Open In Safe Mode

By running your Excel application in the safe mode, you can prevent your Excel program to get executed without loading Excel add-ins. In this COM add-ins are get excluded.

  • Hit Windows + R key from your keyboard.
  • After that in the opening run window type, Excel.exe/safe, and press the enter button.

open excel in safe mode

  • Now you will see that your Excel file gets opened in the safe mode.

open excel in safe mode 1

Method 5# Disable Add-in

Excel closes automatically after opening file when some faulty add-ins start causing the issue. Such Excel add-ins conflict and interferes with your Excel program. So you need to immediately fetch and remove the faulty add-in. here are the steps that you need to follow:

  • Restart your Excel application normally.
  • Hit the File> Options> Add-ins.

Inspect issues with Add-ins 1

  • Now in the Excel option window, select the COM Add-ins from your drop-down menu and hit the Go button.

Inspect issues with Add-ins 2

  • Unselect all the checkboxes and hit the OK button.

Add-Ins-in-Excel

  • Restart your Excel application and check whether the issue has been resolved or not.

One by one enable the add-ins if Excel opens and closes immediately problem keeps continued.

Method 6# Run Excel In Compatibility Mode

If the same Excel Worksheet Opens Minimized issue still persists check the run your Excel application in compatibility mode:

  • Browse in the following location:

C:\Program Files or programs files (X86)\Microsoft Office\Office15

Or C:\Program Files\Microsoft Office 15\root\Office15

  • Make a right-click over Excel.exe<Properties<Compatibility
  • Uncheck the option of “Run this Program in Compatibility Mode”.
  • Tap to Apply >Ok option.

Method 7# Maximize It From The Taskbar

  • You can open Excel in maximized window by placing your mouse cursor over the Excel file appearing in the taskbar.
  • Now from the pop-up menu choose the “maximize”.

FAQ (Frequently Asked Question):

How Do I Get Excel To Open Maximized?
  • If you want that always your Excel file gets open in the maximized window. In that case, you need to make a right-click over Excel shortcut icon and then choose the “Properties” option.
  • Switch to the Shortcut tab and change the “maximized” option from the dropdown menu which is appearing next to Run.

Excel file gets open in the maximized window

After this, whenever you open the Excel file it will get open in full screen.

How Do I Make Excel Fit The Screen?

If you have worked with a large size Excel spreadsheet then you must be familiar with the hassle of scrolling right-left or top–down.

Well, this problematic situation can be easily tackled by making the Excel workbook fit into the screen.

For this, you have to use the Zoom feature to make your Excel spreadsheet size smaller so that it can easily fit into your screen.

But this, won’t give the result you desire as sometimes it will make your workbook smaller or sometimes larger.

For the exact fitting of the Excel spreadsheet on the screen, you need to reduce the width by removing the extra space.

Follow down the below-given steps:

  • Choose the cell row from your Excel spreadsheet range that you wish to see (suppose it’s from B4 to E4).
  • Hit the View> Zoom and then choose Fit Selection.
  • Tap the OK button.

Now you will see that all your selected cells get exactly fit into the width of the screen. No need to get tensed whether you have selected the cells from a single row or column because Excel will make measurements as per the longest dimension.

Note: with this tip, even the larger Excel spreadsheet can also fit into the screen.

Wrap Up:

Now you don’t need to struggle with Excel Worksheet opens minimized problems anymore. Just give it a try to the above-listed fixes.

Apart from this if unfortunately, your Excel workbook data go missing or gets corrupted then in that case you should go with the professional recommended MS Excel Repair Tool to repair corrupt, damaged as well as errors in Excel files. 

This tool allows to easily restore all corrupt Excel files including the charts, worksheet properties cell comments, and other important data. With the help of this, you can fix all sorts of issues, corruption, errors in Excel workbooks.

* Free version of the product only previews recoverable data.

This is a unique tool to repair multiple excel files at one repair cycle and recovers the entire data in a preferred location. It is easy to use and compatible with both Windows as well as Mac operating systems. This supports the entire Excel version and the demo version is free.



Priyanka is an entrepreneur & content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.