DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download free 15-day trial | Purchase | FAQ | Contact

Expand Selection in Excel

DigDB allows you to expand multiple selections horizontally, vertically, or both, to the end of current region, the end of the sheet's data area, or the end of the sheet.

This is especially useful after you select cells by some conditions, and you want to expand the selections to entire row or column or region for further data formatting or manipulation.

    Expand Selection in Excel
    Practice file - expand-selection-demo.xls (16k)

  1. Invoke 'DigDB->Selected Area->Expand...'

    Expand Selection in Excel

  2. Select how to expand, then click the 'Expand >>' button. '<< Back' allows you to go back to the original selection.

    Expand Selection in Excel

  3. Expand to End of Current Table - Horizontally

    Expand Selection in Excel

  4. Expand to End of Sheet's Data Area - Horizontally (A sheet's data area can be viewed as the area formed by the top and bottom non-empty rows and the left-most and right-most non-empty columns).

    Expand Selection in Excel

  5. Expand to End of Sheet - Horizontally

    Expand Selection in Excel

  6. << Back - Go back to the original selection

    Expand Selection in Excel

  7. Expand to End of Current Table - Vertically

    Expand Selection in Excel

  8. Expand to End of Sheet's Data Area - Vertically

    Expand Selection in Excel

  9. Expand to End of Sheet - Vertically

    Expand Selection in Excel

  10. You can expand in both directions, starting from either the current top left corner or from A1. At any time, you can click the 'Back' button to go back to your original selections.

Need more?


Features | Testimonial | Download | Purchase | FAQ | Contact

Copyright © 1999-2007 All rights reserved

DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes?

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft Office Marketplace logo
Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.