Excel Worksheet Goes Blank
In excel 2003, sometimes excel shows a large amount of blank rows and empty columns that was previously deleted, and somehow the scrollbar thinks there’s still data when there isn’t any.
Excel worksheet goes blank. How to delete blank rows at bottom of excel sheet deleting unused blank rows from a sheet can help you reduce file size significantly and make your dashboard cleaner. All other excel spreadsheets are fine. Now, with the blank cells highlighted, click delete in the cells section of the home tab, and select delete sheet rows.
Select associate a file type or protocol with a specific program. In the ribbon, click the file tab and click options in the left navigation pane. I do not work with excel online but if i had this problem with a worksheet on my excel at home i would try to reset the used range.
Specifically, my problem is whenever i double click one of my excel 2007 files, excel opens as a blank/gray screen. If the cell is checked with the isblank formula, you will notice that it is not blank. I suggest you apply one after the other, and check each time you made a change whether it resolved the blank document issue in excel 2016.
Excel opening blank is a very irritating issue usually faced by the excel users while trying to open their excel files. I am using excel 2016 on windows 10. Was sick of the blank excel worksheet after double clicking on a known good.xlsx file.
On the set program associations screen, select select all, and then select save. Disabling the ignore dde feature. But that was getting old fast.
Select excel, then select choose default for this program. This suggestion is not correct. Active 2 years, 9 months ago.