Deleting columns

[surg4u1975]

Has anyone had this problem:

I have a spreadsheet with multiple tabs. On the first tab I can selec
a group of cells within a column, lets say B12 -- B45 and right click o
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 th
same group of cells except now when I right click it will only let m
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]

That definitely helps, and makes me feel a little stupid. Thanks fo
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