Deleting columns

  • Thread starter Thread starter surg4u1975
  • Start date Start date
S

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
 
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
 
That definitely helps, and makes me feel a little stupid. Thanks fo
the help, and for putting up with infantile questions
 
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
 
Back
Top