Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Right click on column and Delete is greyed out?

Okay, I'm not entirely new to Excel, normally I can right click on a column
(with or without text) and then choose delete to delete it. Since having
upgraded to 2003 professional, this option appears to be hit or miss. Most
times it's greyed out, sometimes it's not.

If I open Excel (new workbook) and type anything in a given column, most of
the time I don't have the ability to delete the column. Point is, these are
not linked or special spreadsheets I'm working with. I am running with the
latest updates as well...

Any suggestions?

Thanks,

Larry
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 186
Default Right click on column and Delete is greyed out?

Hi Larry,
One possibiity, although it seems remote:

http://groups.google.com/group/micro...143bcd606eff5c


--
Ken Hudson


"Larry Cooke" wrote:

Okay, I'm not entirely new to Excel, normally I can right click on a column
(with or without text) and then choose delete to delete it. Since having
upgraded to 2003 professional, this option appears to be hit or miss. Most
times it's greyed out, sometimes it's not.

If I open Excel (new workbook) and type anything in a given column, most of
the time I don't have the ability to delete the column. Point is, these are
not linked or special spreadsheets I'm working with. I am running with the
latest updates as well...

Any suggestions?

Thanks,

Larry

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Right click on column and Delete is greyed out?

Thanks for the link Ken, though I'm not sure it would apply to me as I'm not
using any macros in these cases. I just checked and there aren't any macro's
in the sheet(s).

I just may reinstall office and see if that cures the problem...

Larry

"Ken Hudson" wrote:

Hi Larry,
One possibiity, although it seems remote:

http://groups.google.com/group/micro...143bcd606eff5c


--
Ken Hudson


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 18
Default Right click on column and Delete is greyed out?

Remote chance here since you said this happens to new sorkbooks too, but are
you working with a shared workbook that someone else is editing? I often see
"normal" options disabled when working with shared workbooks...

Good luck...
stebro




"Larry Cooke" wrote:

Okay, I'm not entirely new to Excel, normally I can right click on a column
(with or without text) and then choose delete to delete it. Since having
upgraded to 2003 professional, this option appears to be hit or miss. Most
times it's greyed out, sometimes it's not.

If I open Excel (new workbook) and type anything in a given column, most of
the time I don't have the ability to delete the column. Point is, these are
not linked or special spreadsheets I'm working with. I am running with the
latest updates as well...

Any suggestions?

Thanks,

Larry

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default Right click on column and Delete is greyed out?

No, not working on shared workbooks at the time.

The plot thickens though, I remembered last night that I had installed some
security files (ADO stuff for Visual Office Studio I think...) Anyhow, the
IT guy at our office created a worksheet that required this add-on from
Visual Studio. He mentioned to me that he's having the exact same problem
too so I think I may have found the source of the problem, just not sure what
we need to do to correct though...

Thanks,

Larry

"stebro" wrote:

Remote chance here since you said this happens to new sorkbooks too, but are
you working with a shared workbook that someone else is editing? I often see
"normal" options disabled when working with shared workbooks...

Good luck...
stebro


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I combine spreadsheets and documents in one file? Trish Excel Discussion (Misc queries) 3 November 9th 06 09:17 PM
macro unouwanme Excel Discussion (Misc queries) 9 August 31st 06 09:38 PM
delete duplicate record but only determine 1 column data AskExcel Excel Worksheet Functions 3 January 28th 06 01:11 PM
Code to delete rows and column cells that have formulas in. GarToms Excel Worksheet Functions 1 January 18th 06 01:04 PM
ISSUE: Using VBA to Delete a Column cincode5 Excel Discussion (Misc queries) 1 January 27th 05 01:06 AM


All times are GMT +1. The time now is 12:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"