software

Has anyone had this problem:

I have a spreadsheet with multiple tabs. On the first tab I can select
a group of cells within a column, lets say B12 -- B45 and right click on
them, get the option 'Delete...' and it asks if I want to shift left,
up, entire row, or entire column. Now, on the second tab I select the
same group of cells except now when I right click it will only let me
delete rows.

Any ideas as to what I am missing here?--
surg4u1975
------------------------------------------------------------------------
surg4u1975's Profile: www.excelforum.com/member.php...oamp;userid=28718
View this thread: www.excelforum.com/showthread...hreadid=494209Do you have an autofilter active on that sheet? If yes, Excel will only let
you delete entire rows.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;surg4u1975quot; wrote:

gt;
gt; Has anyone had this problem:
gt;
gt; I have a spreadsheet with multiple tabs. On the first tab I can select
gt; a group of cells within a column, lets say B12 -- B45 and right click on
gt; them, get the option 'Delete...' and it asks if I want to shift left,
gt; up, entire row, or entire column. Now, on the second tab I select the
gt; same group of cells except now when I right click it will only let me
gt; delete rows.
gt;
gt; Any ideas as to what I am missing here?
gt;
gt;
gt; --
gt; surg4u1975
gt; ------------------------------------------------------------------------
gt; surg4u1975's Profile: www.excelforum.com/member.php...oamp;userid=28718
gt; View this thread: www.excelforum.com/showthread...hreadid=494209
gt;
gt;


That definitely helps, and makes me feel a little stupid. Thanks for
the help, and for putting up with infantile questions.--
surg4u1975
------------------------------------------------------------------------
surg4u1975's Profile: www.excelforum.com/member.php...oamp;userid=28718
View this thread: www.excelforum.com/showthread...hreadid=494209You're very welcome....
and please don't apologize. After all, you DID post the question in the New
Users forum, right?

***********
Regards,
Ron

XL2002, WinXP-Proquot;surg4u1975quot; wrote:

gt;
gt; That definitely helps, and makes me feel a little stupid. Thanks for
gt; the help, and for putting up with infantile questions.
gt;
gt;
gt; --
gt; surg4u1975
gt; ------------------------------------------------------------------------
gt; surg4u1975's Profile: www.excelforum.com/member.php...oamp;userid=28718
gt; View this thread: www.excelforum.com/showthread...hreadid=494209
gt;
gt;