Deleting columns
 

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

Deleting columns
 

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

Deleting columns
 

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

Deleting columns
 

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