Tip of the Day | Thursday May 21st, 2026
Discover new tools to get things done.
Delete and Reset Empty Ending Rows and Columns on Selected Sheets
Fix incorrect last-cell detection and remove unused empty rows and columns at the bottom and right of your data range across multiple sheets. This tool is useful when our "Reset Excel's Last Used Cell" tool cannot fully reset the last cell, often due to excessive empty rows or columns still being recognized as part of the used range. If Control+End takes you far beyond your actual data, Excel still considers those empty cells as used, which can cause:Fix Excel's Last Cell Issue - Microsoft Support
https://support.microsoft.com/en-us/topic/244435 Tip: Press Control+End to check if Excel selects a blank cell far beyond your actual data. If it does, this tool can fix that.
Screenshots
Example screenshot: 1 Before
Example screenshot: 2 After
Starting this tool
- Click ASAP Utilities › Columns & Rows › 20. Delete and Reset Empty Ending Rows and Columns on Selected Sheets
- Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
©1999-2026 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.