Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default shortcut- deleting entire row (not just the data)

Is there a short cut to deleted the "entire" selected row or coloum (not just the data in it)!!!

please help...
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default shortcut- deleting entire row (not just the data)

*delete
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,514
Default shortcut- deleting entire row (not just the data)

Is there a short cut to deleted the "entire" selected row or coloum
(not just the data in it)!!!

please help...


Right-click the row header[s] and choose Delete from the popup menu!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,514
Default shortcut- deleting entire row (not just the data)

*delete

Pressing the *Del* key while cells are selected just clears the
contents of the entire selection!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default shortcut- deleting entire row (not just the data)

In article , GS wrote:
Is there a short cut to deleted the "entire" selected row or coloum
(not just the data in it)!!!

please help...


Right-click the row header[s] and choose Delete from the popup menu!


... or if you use that a lot (like me :) ), add the delete row command to your
quick bar. IIRC, that will delete the row or rows that you have currently
selected at least one cell on. Use with care. :)






  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default shortcut- deleting entire row (not just the data)

2014. március 3., hétfÅ‘ 0:16:22 UTC+1 idÅ‘pontban Bruce Sinclair a következÅ‘t Ã*rta:
In article , GS wrote:

Is there a short cut to deleted the "entire" selected row or coloum


(not just the data in it)!!!




please help...




Right-click the row header[s] and choose Delete from the popup menu!




.. or if you use that a lot (like me :) ), add the delete row command to your

quick bar. IIRC, that will delete the row or rows that you have currently

selected at least one cell on. Use with care. :)


hold CTRL and hit the "-" (minus) sign on the numeric keyboard.

Excel will then ask you what you want: shift left, shift right, entire row or entire column.

Best,

Szabi
  #7   Report Post  
Senior Member
 
Posts: 118
Default

Quote:
Originally Posted by Szabolcs Endrefi View Post
2014. március 3., hétfÅ‘ 0:16:22 UTC+1 idÅ‘pontban Bruce Sinclair a következÅ‘t Ã*rta:
In article , GS wrote:

Is there a short cut to deleted the "entire" selected row or coloum


(not just the data in it)!!!




please help...




Right-click the row header[s] and choose Delete from the popup menu!




.. or if you use that a lot (like me :) ), add the delete row command to your

quick bar. IIRC, that will delete the row or rows that you have currently

selected at least one cell on. Use with care. :)


hold CTRL and hit the "-" (minus) sign on the numeric keyboard.

Excel will then ask you what you want: shift left, shift right, entire row or entire column.

Best,

Szabi
thanks for the direction. it is really handy tool.have a nice day Szabi
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
Deleting entire row Robert Crandal[_2_] Excel Programming 3 April 28th 13 02:06 PM
Keyboard shortcut to select entire column Melissa Excel Discussion (Misc queries) 6 May 4th 10 04:21 PM
Deleting entire row daisy2008 Excel Programming 6 December 9th 08 09:19 PM
Keyboard shortcut or selecting entire column Precious_Stone Excel Worksheet Functions 2 July 18th 06 05:37 PM
I need shortcut in Excel for coping text only and not the entire c UABCSA Excel Discussion (Misc queries) 4 April 14th 05 01:58 AM


All times are GMT +1. The time now is 02:34 PM.

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

About Us

"It's about Microsoft Excel"