Select Used Range With One Click
Most annoying thing is when you want to select a range of cells in your Excel sheet, and it stops at an empty column or row. Dose for Excel‘s Select Used Range utility can quickly select your range to the last used row and column despite of empty columns and rows.
Click DOSE » Select » Select Used Range
Usage:
- Select a cell where you want the selection starts from.
- And then apply this function by clicking on DOSE » Select » Select Used Range, and it will select all used range to the last used row and column, see screenshots:
More Features:
Excel Navigation
Navigation to Excel Sheets If you have many opened workbooks and want to navigate to…
Excel Clean Data
Clean Data in Excel — Trim, Change Case & Convert in One Click Messy spreadsheets…
Excel Remove Spaces
Remove Leading, Trailing, Extra & All Spaces in Excel – In One Click Stray spaces…
Excel Fill Blank Cells
Fill Blank Cells In Excel Range Fill blank cells in a range of cells could…
Excel Random Generator
Generate Random Data (Numbers, Date, String, etc…) Sometimes you want to generate some random data…
Excel Count Chars
Count Chars In Excel Count chars in a cell or in a selected range of…