Column Insert

  • Thread starter Thread starter at&t
  • Start date Start date
A

at&t

If I select a cell and right click, I can see _I_-nsert-... highlighted
and insert function would work.

but if I select the whole column and right click, my _I_-nsert-... is
not highlighted and insert function does not work...

Is this my setting or option problem? looked everywhere and couldn't
figure out......
 
Are yoiu running Excel '97 and have you Merged cells in the column?

To locate merged cells, select the first cell in the column and drag
that selection downwards, the selected range will become multiple
columns if merged cells exist.

--
 
Bryan. it's Excel 2002 and I even open a brand new sheet and I'm stil
not getting that _I_nsert... word when right click if I select a whol
column to try to insert a column.
It's very frustrating. thanks in advance if anyone can think o
anything...
 
With Excel closed, try deleting the C:\Documents and Settings\~~your
user~~\Application Data\Microsoft\Excel\Excel~~.xlb file, starting
Excel will re-create this file.

--
 
IT WORKED! i'd never have figured this out. you're my hero

what's that file all about?
 
The default settings and options that you have selected in Excel.

good to see it worked
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

En and Em dashes 9
Right click mouse menu for insert does not work 2
Re: Cut and "insert cut cells" in Excel 2007 doesn't work. 9
Data in cells disappear temporarily 5
VB Functions not found 4
Column Inserting and sorting problem 3
Creating names for individual cells over a range 1
Help with INSERT statement. 2

Back
Top