• Global community
• Language:
• Deutsch
• English
• EspaÃ±ol
• FranÃ§ais
• PortuguÃªs
• æ—¥æœ¬èªžã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£
Dedicated community for Japanese speakers
• í•œêµ­ ì»¤ë®¤ë‹ˆí‹°
Dedicated community for Korean speakers
Exit
• How do I centre ranged right text in a cell

# How do I centre ranged right text in a cell

Explorer ,
Sep 28, 2023 Sep 28, 2023

Copied

I have some tables with cells of various sizes that all contain numbers, which are ranged right to align to numbers right - but I also want to centre the ranged right numbers. Is there a keyboard shortcut to do this easiler.

TOPICS
Performance , Scripting

Views

143

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Community Expert , Sep 29, 2023 Sep 29, 2023

I'm sure that what Mathew is after is this: centre the longest number in the column, then right-align all the other numbers to that longest number.

Matthew: no, there's no keyboard shortcut for that. You need a script.It's likely that such a script is around, try googling it.

3 Replies 3
Community Expert ,
Sep 28, 2023 Sep 28, 2023

Copied

Screenshot? You can upload one here.

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Community Expert ,
Sep 28, 2023 Sep 28, 2023

Copied

I think the simple answer is your numbers can either be right aligned or center aligned (or decimal aligned if they are decimals), but number strings of varying length cannot be both right and scenter aligned at the same time...

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Community Expert ,
Sep 29, 2023 Sep 29, 2023

Copied

LATEST

I'm sure that what Mathew is after is this: centre the longest number in the column, then right-align all the other numbers to that longest number.

Matthew: no, there's no keyboard shortcut for that. You need a script.It's likely that such a script is around, try googling it.