Cell changes alignment after data entry

  • Thread starter Thread starter Howard Moore
  • Start date Start date
H

Howard Moore

When I select a row and enter data with Excel 2002, some
of the cells change alignment to centered from not
centered upon hitting Enter. This problem did not occur
on the same worksheet using Excel 2000.

Any idea why, or how to prevent? My updates are current.
 
What did you type into the cells?

If you started with ^ (caret) and you have tools|options|transition
Tab|transition navigation keys checked, you'll get this behavior (it's to match
what Lotus 123 accepted).

(and you don't have any event macros running and the cells aren't formatted as
Centered???)
 

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

Shortcut key for aligning data in cell 3
cell will not center 14
Cell won't center contents 3
Align Left and Right in Same Cell 5
format cell: right align with indent 5
Excel Vba to change displayed year automatically. 14
Data Entry Cells 2
can't change the alignment of numbers in cells 5

Back
Top