View Single Post
  #7   Report Post  
sumesh56 sumesh56 is offline
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