ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I change location of figures within a column (https://www.excelbanter.com/excel-worksheet-functions/8751-how-do-i-change-location-figures-within-column.html)

1911dan

How do I change location of figures within a column
 
I would like to align both numbers and letters within a column to either
center or right or left. How do I do this

Thanks in advance,

Dan

JulieD

Hi Dan

choose tools / customise / options tab and tick or untick (depending on your
version) the option which refers to standard & formatting toolbars on one or
two rows - you want them on two rows.

now select your column and then on the formatting toolbar (the bottom one)
you will see three icons (to the right of the underline icon), these are the
left align, center align and right align icons - click on the appropriate
one.

Cheers
JulieD

"1911dan" wrote in message
...
I would like to align both numbers and letters within a column to either
center or right or left. How do I do this

Thanks in advance,

Dan





All times are GMT +1. The time now is 08:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com