logo ASAP Utilities

Tip of the Day | Saturday February 14th, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Extend Selection to the Rightmost Used Column

Easily extend your selection of cells to the right until the last used column in your worksheet without scrolling manually.
This tool is especially useful when Excel's built-in shortcuts don't work as expected:
  • 'Control+Shift+' stops at empty cells, which can be limiting if your data has gaps.
  • 'Control+Shift+End' selects extra rows, but you only want to extend horizontally.
    Unlike Excel's shortcuts, this tool recognizes the last used column that contains any content, including values, formulas, formatting, or other cell usage. Use it to quickly copy a formula to the rightmost used column or extend your selection without scrolling to find the last relevant column.
    By default, you can launch this tool using the Control+Alt+Shift+ shortcut.

    Screenshots

    Select  ›  Extend Selection to the Rightmost Used Column

    Starting this tool


    Select  ›  Extend Selection to the Rightmost Used Column

    Choose your language preference below

    English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語



  • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    🏆 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.