|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 3rd, 2006, 07:32 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
why is there a "^" in the cell?
Copied a worksheet, now both original and copy have "^" in the cells, causing
formatting to be off. Words won't center horizontally or vertically and can't retype cell contents w/out it putting the "^" back in the cell. HELP! 
|
|
#2
April 3rd, 2006, 07:41 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
why is there a "^" in the cell?
Try Tools / Options / Transition / Untick 'Transition navigation keys' if it
is ticked. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "LBoogie" wrote in message ... Copied a worksheet, now both original and copy have "^" in the cells, causing formatting to be off. Words won't center horizontally or vertically and can't retype cell contents w/out it putting the "^" back in the cell. HELP!
|
|
#3
April 3rd, 2006, 09:33 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
why is there a "^" in the cell?
Unfortunately, that didn't work. However, I did "untick" the navigation keys
before I copied the worksheet. Could this be the reason the "^" is in the cells? How do I get rid of it? Thanks for your response and input! "Ken Wright" wrote: Try Tools / Options / Transition / Untick 'Transition navigation keys' if it is ticked. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------Â*------------------------------Â*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------Â*------------------------------Â*---------------- "LBoogie" wrote in message ... Copied a worksheet, now both original and copy have "^" in the cells, causing formatting to be off. Words won't center horizontally or vertically and can't retype cell contents w/out it putting the "^" back in the cell. HELP!
|
|
#4
April 4th, 2006, 01:19 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
why is there a "^" in the cell?
Try
EditReplace....Find ^ ....Replace (leave blank) "LBoogie" wrote: Unfortunately, that didn't work. However, I did "untick" the navigation keys before I copied the worksheet. Could this be the reason the "^" is in the cells? How do I get rid of it? Thanks for your response and input! "Ken Wright" wrote: Try Tools / Options / Transition / Untick 'Transition navigation keys' if it is ticked. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------Â*------------------------------Â*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------Â*------------------------------Â*---------------- "LBoogie" wrote in message ... Copied a worksheet, now both original and copy have "^" in the cells, causing formatting to be off. Words won't center horizontally or vertically and can't retype cell contents w/out it putting the "^" back in the cell. HELP!
|
|
#5
April 5th, 2006, 03:01 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
why is there a "^" in the cell?
Good idea. Thanks.
"ufo_pilot" wrote: Try EditReplace....Find ^ ....Replace (leave blank) "LBoogie" wrote: Unfortunately, that didn't work. However, I did "untick" the navigation keys before I copied the worksheet. Could this be the reason the "^" is in the cells? How do I get rid of it? Thanks for your response and input! "Ken Wright" wrote: Try Tools / Options / Transition / Untick 'Transition navigation keys' if it is ticked. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------Â*------------------------------Â*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------Â*------------------------------Â*---------------- "LBoogie" wrote in message ... Copied a worksheet, now both original and copy have "^" in the cells, causing formatting to be off. Words won't center horizontally or vertically and can't retype cell contents w/out it putting the "^" back in the cell. HELP!
|
|
#6
April 5th, 2006, 09:09 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
why is there a "^" in the cell?
Yep, and you've had the answer to getting rid of it :-)
Regards Ken................. "LBoogie" wrote in message ... Unfortunately, that didn't work. However, I did "untick" the navigation keys before I copied the worksheet. Could this be the reason the "^" is in the cells? How do I get rid of it? Thanks for your response and input! "Ken Wright" wrote: Try Tools / Options / Transition / Untick 'Transition navigation keys' if it is ticked. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "LBoogie" wrote in message ... Copied a worksheet, now both original and copy have "^" in the cells, causing formatting to be off. Words won't center horizontally or vertically and can't retype cell contents w/out it putting the "^" back in the cell. HELP!
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| cell color index comparison | MINAL ZUNKE | New Users | 1 | June 30th, 2005 07:11 AM |
| Possible Lookup Table | Karen | Worksheet Functions | 5 | June 8th, 2005 09:43 PM |
| Copy cell format to cell on another worksht and update automatical | kevinm | Worksheet Functions | 21 | May 19th, 2005 11:07 AM |
| Changing Cell References | Katrina | Worksheet Functions | 1 | September 22nd, 2004 05:37 PM |
| Do you have what it takes... | Frank Kabel | Worksheet Functions | 1 | February 22nd, 2004 08:30 PM |
Linear Mode
