Skip to main content
M
Matthew5C62
Inspiring
September 28, 2023
Answered

How do I centre ranged right text in a cell

  • September 28, 2023
  • 3 replies
  • 297 views

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.

    This topic has been closed for replies.
    Correct answer Peter Kahrel

    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

    Peter Kahrel
    Community Expert
    Peter KahrelCommunity ExpertCorrect answer
    Community Expert
    September 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.

    Peter Spier
    Community Expert
    Peter SpierCommunity Expert
    Community Expert
    September 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...

    brian_p_dts
    Community Expert
    brian_p_dtsCommunity Expert
    Community Expert
    September 28, 2023

    Screenshot? You can upload one here.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices