CTRL+End Goes Too Far in Excel and Google Spreadsheets

Irked. That's how you feel when you hit CTRL+End and you land way beyond the end of your data in Microsoft Excel or Google Spreadsheets.

CTRL+End overshoots the end of the data after a lot of data is deleted. Although you eliminated the data, the spreadsheet doesn't update what it considers to be the active range.

However, there's an easy fix.

First, delete all the rows that used to house the deleted data.

Second, save the spreadsheet to force it to update the active range.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.