Deleting columns

[surg4u1975]

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?

[Ron Coderre]

Do 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-Pro


"surg4u1975" wrote:

>
> 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: http://www.excelforum.com/member.php...o&userid=28718
> View this thread: http://www.excelforum.com/showthread...hreadid=494209
>
>

[surg4u1975]

That definitely helps, and makes me feel a little stupid. Thanks for the help, and for putting up with infantile questions.

[Ron Coderre]

You'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-Pro


"surg4u1975" wrote:

>
> 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: http://www.excelforum.com/member.php...o&userid=28718
> View this thread: http://www.excelforum.com/showthread...hreadid=494209
>
>