Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
8

How do I centre ranged right text in a cell

Explorer ,
Sep 28, 2023 Sep 28, 2023

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
290
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

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.

Translate
Community Expert ,
Sep 28, 2023 Sep 28, 2023

Screenshot? You can upload one here.

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

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...

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Sep 29, 2023 Sep 29, 2023
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.

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