| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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
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
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
Linear Mode
