Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
DOT-TE3
 
Posts: n/a
Default Allow delete/insert cells to del/insrt highlighted rows/columns

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/comm...ic.excel.setup
  #2   Report Post  
Posted to microsoft.public.excel.setup
David McRitchie
 
Posts: n/a
Default Allow delete/insert cells to del/insrt highlighted rows/columns

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

"DOT-TE3" wrote in message ...
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/comm...ic.excel.setup


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy/Paste how to avoid the copy of formula cells w/o calc values Dennis Excel Discussion (Misc queries) 10 March 2nd 06 10:47 PM
How do I count cells that have are highlighted a certain color? NicoleE Excel Worksheet Functions 1 September 2nd 05 09:14 PM
Can I sum only highlighted cells in a worksheet? Mr Harlow Excel Worksheet Functions 2 August 29th 05 11:16 PM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:09 AM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM


All times are GMT +1. The time now is 04:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"