| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Insert
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...... -- at&t ------------------------------------------------------------------------ at&t's Profile: http://www.excelforum.com/member.php...o&userid=33378 View this thread: http://www.excelforum.com/showthread...hreadid=532064 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column Insert
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. -- at&t Wrote: 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...... -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=532064 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column Insert
Bryan. it's Excel 2002 and I even open a brand new sheet and I'm still not getting that _I_nsert... word when right click if I select a whole column to try to insert a column. It's very frustrating. thanks in advance if anyone can think of anything.... -- at&t ------------------------------------------------------------------------ at&t's Profile: http://www.excelforum.com/member.php...o&userid=33378 View this thread: http://www.excelforum.com/showthread...hreadid=532064 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column Insert
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. -- at&t Wrote: Bryan. it's Excel 2002 and I even open a brand new sheet and I'm still not getting that _I_nsert... word when right click if I select a whole column to try to insert a column. It's very frustrating. thanks in advance if anyone can think of anything.... -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=532064 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column Insert
IT WORKED! i'd never have figured this out. you're my hero what's that file all about? -- at&t ------------------------------------------------------------------------ at&t's Profile: http://www.excelforum.com/member.php...o&userid=33378 View this thread: http://www.excelforum.com/showthread...hreadid=532064 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column Insert
The default settings and options that you have selected in Excel. good to see it worked -- at&t Wrote: IT WORKED! i'd never have figured this out. you're my hero what's that file all about? -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=532064 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert duplicate rows based on numeric value in column | Excel Discussion (Misc queries) | |||
| match and count words | Excel Worksheet Functions | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| Lookup then Match and insert value from next column | Excel Worksheet Functions | |||
| How can I sort an entire spreadsheet from a list | Excel Worksheet Functions | |||
Hybrid Mode
