Share via

BOTTOM align in EXCEL cells

Anonymous
2019-11-03T01:43:32+00:00

Hi There,

I CANNOT get numbers to align at the bottom of a cell in EXCEL.  Oddly, in the past when I've had this problem the only way I've been able to simulate bottom alignment has been to choose CENTER.  At that point, my numbers would often align at bottom to the of the cell.  Choosing BOTTOM would cause the numbers to migrate UP?!?!?! 

It feels as though it's related to the padding built into the various fonts I might be using.  In WORD, I can correct for this by choosing line spacing that is less than SINGLE (.8, for example), but EXCEL doesn't give me that option.

Thanks so much for any help.

CR

PS  I would have attached a copy or pasted a copy into this message but was unable to do either.  Here's a screen shot, which won't show any underlying formatting issues.  It does show the problem - both with text and numbers - though.   Not a good day at the (Microsoft) Office....

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144K Reputation points Volunteer Moderator
    2019-11-03T07:41:24+00:00

    Please upload your file (maybe with anonymous data) on an online file hoster like www.dropbox.com and post the download link here.

    A macro to anonymize data in selected cells can be downloaded here:

    https://www.dropbox.com/s/rkfxuh85j5wyj9y/modAnonymize.bas?dl=1

    Please do not use OneDrive, we need a 1:1 copy of the file.

    Andreas.

    0 comments