Inconsistent Horizontal Column Alignment

Is anyone else experiencing a problem where new records entered into a Worksheet sometimes aligns the text horizontally at the top of the row, and other times at the bottom, or center?? I can't find any consistency in some of the columns, even if I've set the entire row to align top, or align center, or align bottom.

Any suggestions are appreciated.

Find more posts tagged with

Sheets

Comments

Mike Kampff

It's possible that the alignment was set on the prior records at the cell or row level, instead of the column level. In my experience, I haven't seen this issue, but that may be because I always format the whole column by highlighting the column header and then applying the format.

khankoff

Thanks, Mike. I'll give a shot to formatting entire columns. However, what I recall is that new columns might be aligned one way, and other columns aligned another, with no rhyme or reason. In other words, upon creation, they are not always aligned the same.

Andrée Starå

Hi Ken,

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Debbie Sawyer

This post intruiged me so I have done a little testing in a new Grid sheet and can say that New Text/Contact Lists/Dates/Dropdown Lists type Columns are Top Left aligned, Symbols & Checkboxes are Top Center aligned and Duration and Autonumber type columns appear Top Right aligned.

None of my New columns aligned to vertical centre or vertical bottom all Vertical Top.

My suggestion would be to use the Clear Formatting button on the columns that are coming in strangely (highlight the column and press the button that looks like a pencil eraser) and re-applying the alignment that you would like.

Maybe a shared user has been playing with formatting or if you inported the data maybe it retained some previous formatting?

Strange! Hope you get this sorted! It would frustrate me! haha

Kind regards

Debbie

Sign in to join the conversation!

Quick Links

Trending discussions

Notifications Currently Experiencing Issues?
Hi All, I seem to be having a bunch of notification issues, and I'm wondering if anyone else is experiencing issues. Please keep in mind I have had these automations in place for over 2 years already & they always worked as expected. Is this a system-wide issue, or should I connect with Smartsheet Support? Issue 1 -…
Dashboard % are not matching
Hi! I have a Dashboard feeding off pretty simple raw data. It's mainly detailing this is how many accounts we think we'll get, this is how many we've gotten and then provides a %. I wanted to add a chart just to pretty it up a bit but now the % done is reporting differently and I have no clue why. Here is the raw data: The…
New user; How to sort and format data by date
Hi! New user here. We have a basic sheet to track dates, hotel reservations, and the project. How can I format all dates to be uniform? My goal is to be able to sort by date or amount. Currently, we may have one date entry as 08/25/25 and another as 1/12/25. This really affects sorting.