shortcut-> deleting entire row (not just the data)

[saibhargav927]

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

please help...

 

[saibhargav927]

*delete

 

[GS]

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

*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]

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

2014. március 3., hétfő 0:16:22 UTC+1 időpontban Bruce Sinclair a következőt írta:

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

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

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

coloum --
--

(not just the data in it)!!!-- --

--

--
please help...-- -

-

-
Right-click the row header and choose Delete from the popu

menu!-



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

quick bar. IIRC, that will delete the row or rows that you hav 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, entir
row or entire column.

Best,

Szabi[/QUOTE]
thanks for the direction. it is really handy tool.have a nice day Szab