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: 203

Total answers/comments: 1

Comments display order:

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