why is there a "^" in the cell?

L

LBoogie

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!
 
K

Ken Wright

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 :)
------------------------------­------------------------------­----------------
 
L

LBoogie

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!
 
K

Ken Wright

Yep, and you've had the answer to getting rid of it :)

Regards
Ken.................
 

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

Move Chart with Text 0
Creating Labels Over 3-Up Image 2
Vertical short line in front of word 0
Table Preferred width is changed when pasting 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
Pasting a cell into bookmarked table from excel vba 1
force alignment? 7
List all tables, including document structure 0

Top