Excel: some cells in sheet won't center when directed to

March 30, 2012 at 10:20:03
Specs: Windows XP, Pentium() 4 CPU 3GHz, 1.99 GB RAM
Some of my cells will not respond when I apply centering, either with the centering icon or the Format Cells; Alignment; Horizontal Center. Other cells in the same sheet act normally.

See More: Excel: some cells in sheet wont center when directed to

Report •

#1
March 30, 2012 at 11:38:52
Are you importing this data from outside Excel?

Make sure there aren't any stray space characters or other unprintable stuff.

You can use the =TRIM() and =CLEAN() functions to strip out all unwanted characters.

Something like =CLEAN(TRIM(A1))

MIKE

http://www.skeptic.com/


Report •

#2
March 30, 2012 at 12:11:33
Thanks, Mike!

No, this was created in Excel. The really = odd thing about this was that one minute the cells were formatting just fine, and I did something that made all the columns the same width (unintentional), and I couldn't undo that. So when I resized them manually, some, not all, of them will no longer take the formatting commands.

Also, they don't have extra spaces. I've tried deleting and reinserting manually the data and it makes no difference.


Report •

#3
March 30, 2012 at 13:50:01
OK, so I ran a Microsoft Office Diagnostic. It found some things and fixed them, and I restarted the machine and Voila! the problem was corrected.

Thanks for your help!

M


Report •

Related Solutions

#4
March 30, 2012 at 13:54:32
OOPS. I opened the wrong document. The offending document still has the problem. and I was so excited! Sigh! And still need help!

M


Report •

#5
March 30, 2012 at 15:44:32
How are the cells Formatted?

If it is Formatted as Accounting, then it is designed to have the dollar sign ($)
at the far left of the cell and the number at the far right.

MIKE

http://www.skeptic.com/


Report •

#6
April 6, 2012 at 11:39:06
Not as accounting. And no $. Thanks, though.

Report •

#7
April 6, 2012 at 12:04:54
Here's a few more thing to try.

Try these formulas on one of the offending cells that won't allow you to apply centering

=CELL("prefix",A1)

This will show the alignment of the cell.
Shows a (tick mark) ' for left, ^ for center, "" for right.
Nothing is shown for numeric entries.

=CELL("protect",A1)

This will show the type of cell protection.
1 for a locked,
0 for unlocked.

=CELL("format",A1)

This will show the "number" format of the cell.
There is a whole list of codes it can return, but G is for General
you can look up the =CELL() function in Help to get the whole list.

See if that gives any clues as to what's going on.

MIKE

http://www.skeptic.com/


Report •

Ask Question