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

How do I centre ranged right text in a cell

Explorer ,
Sep 28, 2023 Sep 28, 2023

Copy link to clipboard

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

Translate

Translate

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

Votes

Translate

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

Copy link to clipboard

Copied

Screenshot? You can upload one here.

Votes

Translate

Translate

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 guidelines
Community Expert ,
Sep 28, 2023 Sep 28, 2023

Copy link to clipboard

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

Votes

Translate

Translate

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 guidelines
Community Expert ,
Sep 29, 2023 Sep 29, 2023

Copy link to clipboard

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.

Votes

Translate

Translate

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 guidelines