Skip to main content
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
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
Community Expert
September 28, 2023

Screenshot? You can upload one here.