Allow delete/insert cells to del/insrt highlighted rows/columns

[DOT-TE3]

The delete cells or insert cells buttons don't allow the user to
delete/insert when a complete row/column is highlighted.

This ability disappeared in our recent upgrade to Excel 2003. It allowed 1
button to do the work of 2 based on how cells were highlighted.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-24c91ddd7cb4&dg=microsoft.public.excel.setup

 

[David McRitchie]

I'm not familiar with such a toolbar button, usually if a key works two
different ways it is builtin and the Shift key is what changes how it works.
So it doesn't quite sound like what you describe..

You can accomplish same by using Edit, Delete
or Ctrl+- (hyphen)

You can extend a selection to entire columns with Ctrl+SpaceBar
You can extend a selection to entire rows with Shift+SpaceBar

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

The delete cells or insert cells buttons don't allow the user to
delete/insert when a complete row/column is highlighted.

This ability disappeared in our recent upgrade to Excel 2003. It allowed 1
button to do the work of 2 based on how cells were highlighted.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-24c91ddd7cb4&dg=microsoft.public.excel.setup