Software School Design and Training
Software trainer, published author, web and multimedia developer

Excel 2013 keeps long-standing glitch. Here’s how to fix it.

November 14th, 2012

Since the beginning of Microsoft Excel’s existence, it had a relatively minor, but annoying glitch: if you deleted cells all the way at the bottom or all the way to the right of a worksheet, Excel would still “remember” that those cells once had data. So when you press Ctrl + End to move the cursor to the end of the worksheet, the cursor wouldn’t go to what became the last-filled cell in the worksheet after you made your deletion; the cursor would go to the row and column of what used to be the last column and row of the worksheet.

 

To illustrate: in the sheet below, if you press Ctrl + End, the cursor will go to cell F11 (assuming no notation in G11):

 

 

What happens if you delete the data in rows D through F, and in rows 9 through 11, so the sheet looks like this (again, assuming no formatting or notation in rows 8 or 11)?

 

When pressing Ctrl + End, the cursor still goes to cell F11. To fix it, so the cursor goes to cell C8, instead:

Put the mouse pointer at the top of column D, so the pointer turns to a down arrow:


 

Drag to the right, so columns D through F are selected. Then right-click and select Delete from the pop-up menu.


Now do the same for the rows. Position the mouse pointer to the left of row 9, so the mouse pointer becomes a right arrow:


Drag downward, to select rows 9 through 11:


Again, right-click and select Delete from the pop-up menu.


Save the workbook. Now when you press Ctrl + End, the cursor will go to the correct cell: C8.


 

P.S. You can find free Visual Basic scripts that you can install that will fix this error, also. But using the method above, you don’t have to go through that.

 

 

 

Tags:

blog comments powered by Disqus