Once found, look for a name that isn't listed in your workbook with a worksheet tab.For now, find your project and expand the folders to expose the workbook objects (the individual worksheets and the ThisWorkbook object). You'll recognize them because they will have your worksheet names in brackets.

If you closed all other workbooks and there are more than a few projects showing, then you've got something else going on that we can cover in detail later. The number of projects displayed depends on the number of open Excel workbooks and addins.The window has minor differences between Excel versions, but they all share the same expanding/collapsing tree behavior.The project explorer should already be open on the left side of the screen.The final task is to look for hidden worksheets. Not just hidden, but very hidden (I'm not making this up). if the range changed then you're done. If it's the same, then you still have a problem.Once you've pressed Enter, put your cursor on the line where you used the ? and press Enter.If we don't use a question mark, then we're telling VBA to perform an action. That's because the question mark is used when we want VBA to display text, so we can see a value or status. Note the first command used a ? and this doesn't. If the range looks normal ( not excessively large) then the problem is not your range.Make sure the suspected worksheet is open and active.The VBA Wayĭon't be afraid of the big bad VBA, it's a great tool and what we're doing well only take a few seconds. Give it a shot. If that doesn't work, well - try VBA real quick. You 'shouldn't' need to close your workbook after saving it, but I won't advise against it. Yes, the two Ctrl+ Shift+ End lines are redundant, but I think your can survive the 15 keystrokes. Select the first empty row - the whole row.Go to the of your data on the right side and select the first empty column - the whole column.Begin by closing any other Excel sessions, so the current workbook is the only workbook open.Please humor me for the sake of completeness and to keep that from happening to you: Today I had an issue where my VBA merged sheets vertically and my worksheet inexplicably bloated horizontally. I was initially confused and concerned because I've only had vertical bloat and didn't think to check horizontally, until my reset attempt failed twice. The second difference is that I've never been stuck like you, it always resets after saving. Big help there, right?Ī few possible solutions follow: Horizontal/Vertical Bloats I'm a keyboard guy so I've always used Alt+ E+ D. That shouldn't matter one bit, but stranger things have happened. The first is that I've never tried to right-click -> delete. There are only two differences I can identify: I frequently reset bloated books using the methods that don't work for you. I appreciate the the extra effort you've taken to document your efforts. Thank you. To clarify, I've seen this answer (and tried it) and this KB article (and tried it as well) - no cigar.

Before marking this as a duplicate, note I've intentionally exhausted other options in my search for an answer. I've read up on the VBA equivalent of doing this manually, and it seems that this SO Question refers to the same thing - the Worksheet.UsedRange property.īefore I dive into VBA - is there something I can do manually to fix this? However, after saving the file, closing it, and opening it up again - pressing ctrl+ End still throws me to the last cell. I then proceeded to clear the formatting from all of the unused rows, and then - just in case - selected all the blank rows (beneath my data) using alt+ Shift+ ↓ and alt+ Shift+ →, then right-click and delete. Oddly enough, that cell was in the last possible row in the sheet (i.e.

I narrowed most of the weight down to one sheet, and did ctrl+ End to check what is the last cell in that sheet. To understand where the weight is coming from, I've used the method described in this SU question. I have an Excel file that is larger than 7MB.

Manually delete row psequel