Home » Questions » Computers [ Ask a new question ]

Excel 2007: what happened to the Auto Expand Selection tool?

Excel 2007: what happened to the Auto Expand Selection tool?

Older versions of Excel had a icon that would expand the selection to include any non-empty cells in all directions. It was an X shape with four arrowheads. You can still write VBA code to do this, but I really miss this tool. Did they just drop it from Excel 2007?

Asked by: Guest | Views: 38
Total answers/comments: 1
Guest [Entry]

"You can add the button to the quick access toolbar. Select More Commands in the Customize dialog. Then in the 'Choose commands from:' dropdown select 'Commands not in the ribbon' and it is called 'Select current region' (listed alphabetically). Then click add.

Ctrl+Shift+* will do the trick if you prefer."