A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old March 14th, 2006, 07:47 PM posted to microsoft.public.excel.setup
external usenet poster
 
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  
Old March 16th, 2006, 10:29 PM posted to microsoft.public.excel.setup
external usenet poster
 
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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
cell's background color not printed correctly [email protected] Tables 2 December 19th, 2005 12:44 PM
how do i protect cells in a shared worksheet Debi General Discussion 3 September 30th, 2005 11:15 PM
Conditional formatting...cont. from 9/25 Guenzak General Discussion 4 September 26th, 2005 10:55 PM
Can I sum only highlighted cells in a worksheet? Mr Harlow Worksheet Functions 2 August 29th, 2005 11:16 PM
Multiple Conditional Formats for A Chart (Please Help)? Jon Peltier Charts and Charting 0 September 19th, 2003 09:40 PM


All times are GMT +1. The time now is 04:48 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.