Cell won't center contents
Our company has a spreadsheet containing several columns of information in a
data list. A handful of cells within these columns absolutely baffle me by not allowing any changes to alignment (left, center or right) whatsoever. These cells all contain single digit numbers that remain left-aligned no matter what I've tried (we need them centered). There is no protection on any of these cells or the entire sheet or workbook, and these cells are formatted exactly the same as others that do allow alignment changes. None of the cells are merged with any others. I'm an advanced Excel user, but this one has me scratching my head. Thanks for any suggestions! -- Steve C |
Answer: Cell won't center contents
Hi Steve,
I understand your frustration with the alignment issue in your Excel spreadsheet. Here are a few things you can try to center the contents of those cells:
I hope one of these solutions works for you. Let me know if you have any other questions or concerns! |
Cell won't center contents
No leading or following spaces I take it?
"Steve C" wrote: Our company has a spreadsheet containing several columns of information in a data list. A handful of cells within these columns absolutely baffle me by not allowing any changes to alignment (left, center or right) whatsoever. These cells all contain single digit numbers that remain left-aligned no matter what I've tried (we need them centered). There is no protection on any of these cells or the entire sheet or workbook, and these cells are formatted exactly the same as others that do allow alignment changes. None of the cells are merged with any others. I'm an advanced Excel user, but this one has me scratching my head. Thanks for any suggestions! -- Steve C |
Cell won't center contents
None. Each of these cells contains a single digit and I've even retyped them
all to make sure. -- Steve C "tim m" wrote: No leading or following spaces I take it? "Steve C" wrote: Our company has a spreadsheet containing several columns of information in a data list. A handful of cells within these columns absolutely baffle me by not allowing any changes to alignment (left, center or right) whatsoever. These cells all contain single digit numbers that remain left-aligned no matter what I've tried (we need them centered). There is no protection on any of these cells or the entire sheet or workbook, and these cells are formatted exactly the same as others that do allow alignment changes. None of the cells are merged with any others. I'm an advanced Excel user, but this one has me scratching my head. Thanks for any suggestions! -- Steve C |
Cell won't center contents
Try formatting the cell as General.
An accounting format (or clicking the Currency icon) could cause this trouble. Steve C wrote: Our company has a spreadsheet containing several columns of information in a data list. A handful of cells within these columns absolutely baffle me by not allowing any changes to alignment (left, center or right) whatsoever. These cells all contain single digit numbers that remain left-aligned no matter what I've tried (we need them centered). There is no protection on any of these cells or the entire sheet or workbook, and these cells are formatted exactly the same as others that do allow alignment changes. None of the cells are merged with any others. I'm an advanced Excel user, but this one has me scratching my head. Thanks for any suggestions! -- Steve C -- Dave Peterson |
All times are GMT +1. The time now is 08:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com