ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   shortcut- deleting entire row (not just the data) (https://www.excelbanter.com/excel-discussion-misc-queries/449875-shortcut-deleting-entire-row-not-just-data.html)

[email protected]

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...

[email protected]

shortcut- deleting entire row (not just the data)
 
*delete

GS[_2_]

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



GS[_2_]

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



Bruce Sinclair[_2_]

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. :)





Szabolcs Endrefi

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

sumesh56

Quote:

Originally Posted by Szabolcs Endrefi (Post 1616848)
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


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com