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.
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.
Copy link to clipboard
Copied
Screenshot? You can upload one here.
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...
Copy link to clipboard
Copied
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.