View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Szabolcs Endrefi Szabolcs Endrefi is offline
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