Excel Worksheet Goes Blank

Press alt + f11 keys to enable the microsoft visual basic for applications window.

Excel worksheet goes blank. Loop through rows until blank with vba. In this article we will learn the ways you can delete unused rows from a worksheet fast. Select start, then select control panel.

The only thing that worked for me was to open the workbook using the excel vba editor (alt f11).you can type the following at the immediate windows (ctrl g if it doesn't display initially):application.workbooks.open filename:=filename.xls, corruptload:=xlextractdata Your job involves adding data to the end of a very large excel worksheet. This suggestion is not correct.

This causes the file size of the workbook to be larger than necessary and may result in more printed. As such, excel would not open the workbook and just show a blank screen. But looking at full screen i can see it.

If the cell is checked with the isblank formula, you will notice that it is not 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. Unfortunately, none of the above worked for me.

This can happen when a user inadvertently forgets to save a worksheet as a new copy. But that was getting old fast. Click here to watch this video on youtube.

Coworker wanted me to double check her work and when i open the spreadsheet it comes up blank (just gray) not even showing the columns and rows. In many cases, the excel sheet disappeared by itself. Then in the unhide dialog box > click sheet you desire to unhide;