software

Copied a worksheet, now both original and copy have quot;^quot; 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 quot;^quot; back in the cell. HELP!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 :-)
------------------------------*------------------------------*----------------
quot;LBoogiequot; gt; wrote in message
...
gt; Copied a worksheet, now both original and copy have quot;^quot; in the cells,
gt; causing
gt; formatting to be off. Words won't center horizontally or vertically and
gt; can't
gt; retype cell contents w/out it putting the quot;^quot; back in the cell. HELP!
gt;
Unfortunately, that didn't work. However, I did quot;untickquot; the navigation keys
before I copied the worksheet. Could this be the reason the quot;^quot; is in the
cells? How do I get rid of it? Thanks for your response and input!

quot;Ken Wrightquot; wrote:

gt; Try Tools / Options / Transition / Untick 'Transition navigation keys' if it
gt; is ticked.
gt;
gt; --
gt; Regards
gt; Ken....................... Microsoft MVP - Excel
gt; Sys Spec - Win XP Pro / XL 97/00/02/03
gt;
gt; ------------------------------Â*------------------------------Â*----------------
gt; It's easier to beg forgiveness than ask permission :-)
gt; ------------------------------Â*------------------------------Â*----------------
gt;
gt;
gt;
gt; quot;LBoogiequot; gt; wrote in message
gt; ...
gt; gt; Copied a worksheet, now both original and copy have quot;^quot; in the cells,
gt; gt; causing
gt; gt; formatting to be off. Words won't center horizontally or vertically and
gt; gt; can't
gt; gt; retype cell contents w/out it putting the quot;^quot; back in the cell. HELP!
gt; gt;
gt;
gt;
gt;

Try
Editgt;Replace....Find ^ ....Replace (leave blank)quot;LBoogiequot; wrote:

gt; Unfortunately, that didn't work. However, I did quot;untickquot; the navigation keys
gt; before I copied the worksheet. Could this be the reason the quot;^quot; is in the
gt; cells? How do I get rid of it? Thanks for your response and input!
gt;
gt; quot;Ken Wrightquot; wrote:
gt;
gt; gt; Try Tools / Options / Transition / Untick 'Transition navigation keys' if it
gt; gt; is ticked.
gt; gt;
gt; gt; --
gt; gt; Regards
gt; gt; Ken....................... Microsoft MVP - Excel
gt; gt; Sys Spec - Win XP Pro / XL 97/00/02/03
gt; gt;
gt; gt; ------------------------------Â*------------------------------Â*----------------
gt; gt; It's easier to beg forgiveness than ask permission :-)
gt; gt; ------------------------------Â*------------------------------Â*----------------
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;LBoogiequot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Copied a worksheet, now both original and copy have quot;^quot; in the cells,
gt; gt; gt; causing
gt; gt; gt; formatting to be off. Words won't center horizontally or vertically and
gt; gt; gt; can't
gt; gt; gt; retype cell contents w/out it putting the quot;^quot; back in the cell. HELP!
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;

Good idea. Thanks.

quot;ufo_pilotquot; wrote:

gt; Try
gt; Editgt;Replace....Find ^ ....Replace (leave blank)
gt;
gt;
gt; quot;LBoogiequot; wrote:
gt;
gt; gt; Unfortunately, that didn't work. However, I did quot;untickquot; the navigation keys
gt; gt; before I copied the worksheet. Could this be the reason the quot;^quot; is in the
gt; gt; cells? How do I get rid of it? Thanks for your response and input!
gt; gt;
gt; gt; quot;Ken Wrightquot; wrote:
gt; gt;
gt; gt; gt; Try Tools / Options / Transition / Untick 'Transition navigation keys' if it
gt; gt; gt; is ticked.
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Regards
gt; gt; gt; Ken....................... Microsoft MVP - Excel
gt; gt; gt; Sys Spec - Win XP Pro / XL 97/00/02/03
gt; gt; gt;
gt; gt; gt; ------------------------------Â*------------------------------Â*----------------
gt; gt; gt; It's easier to beg forgiveness than ask permission :-)
gt; gt; gt; ------------------------------Â*------------------------------Â*----------------
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;LBoogiequot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; Copied a worksheet, now both original and copy have quot;^quot; in the cells,
gt; gt; gt; gt; causing
gt; gt; gt; gt; formatting to be off. Words won't center horizontally or vertically and
gt; gt; gt; gt; can't
gt; gt; gt; gt; retype cell contents w/out it putting the quot;^quot; back in the cell. HELP!
gt; gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;

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

Regards
Ken.................quot;LBoogiequot; gt; wrote in message
...
gt; Unfortunately, that didn't work. However, I did quot;untickquot; the navigation
gt; keys
gt; before I copied the worksheet. Could this be the reason the quot;^quot; is in the
gt; cells? How do I get rid of it? Thanks for your response and input!
gt;
gt; quot;Ken Wrightquot; wrote:
gt;
gt;gt; Try Tools / Options / Transition / Untick 'Transition navigation keys' if
gt;gt; it
gt;gt; is ticked.
gt;gt;
gt;gt; --
gt;gt; Regards
gt;gt; Ken....................... Microsoft MVP - Excel
gt;gt; Sys Spec - Win XP Pro / XL 97/00/02/03
gt;gt;
gt;gt; ------------------------------*------------------------------*----------------
gt;gt; It's easier to beg forgiveness than ask permission :-)
gt;gt; ------------------------------*------------------------------*----------------
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;LBoogiequot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Copied a worksheet, now both original and copy have quot;^quot; in the cells,
gt;gt; gt; causing
gt;gt; gt; formatting to be off. Words won't center horizontally or vertically and
gt;gt; gt; can't
gt;gt; gt; retype cell contents w/out it putting the quot;^quot; back in the cell. HELP!
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;