Google Sheets puts numbers on the right side of a cell by default. To move them to the left, select the cells and click Format > Alignment > Left, or press Ctrl + Shift + L (Command + Shift + L on a Mac).
These steps are for Google Sheets in a web browser on Windows, Mac and Chromebook, plus the Google Sheets app for Android, iPhone and iPad. You need edit access to the spreadsheet. Google covers the menus in Edit & format a spreadsheet and the shortcuts in Keyboard shortcuts for Google Sheets.
How to Left Align Numbers With the Format Menu
- Open the spreadsheet in Google Sheets.
- Select the cells. Drag across a range, click a column letter to select the whole column, or press Ctrl + A (Command + A on a Mac) to select the whole sheet. The selection turns blue.
- Click Format in the menu bar. The Format menu opens.
- Point to Alignment. A submenu opens with the horizontal and vertical options.
- Click Left.

The numbers move to the left edge of each cell. Text and dates in the selection move left too. The values themselves don’t change, so formulas that use these cells give the same results.
How to Left Align From the Toolbar
- Select the cells.
- Click the Horizontal align button in the toolbar. Its icon is a set of short horizontal lines. On a narrow window, Sheets may tuck it into the overflow menu at the right end of the toolbar.
- Click the Left icon in the small menu that opens.
The same menu has Center and Right. To center or right align numbers instead, follow either method and pick that option.
The font size control is in the same toolbar as the alignment buttons. Here’s how to make the font bigger in Google Sheets.
Alignment Keyboard Shortcuts
Select the cells first, then press the keys. Google lists these shortcuts:
| Action | Windows and Chromebook | Mac |
|---|---|---|
| Left align | Ctrl + Shift + L | Command + Shift + L |
| Center align | Ctrl + Shift + E | Command + Shift + E |
| Right align | Ctrl + Shift + R | Command + Shift + R |
| Select column | Ctrl + Space | Ctrl + Space |
| Select row | Shift + Space | Shift + Space |
| Select all | Ctrl + A | Command + A |
There are no shortcuts for vertical alignment. Press Ctrl + / (Command + / on a Mac) inside Sheets to see Google’s shortcut list.
Should You Left Align Numbers?
Right alignment is the default for a reason. When every number in a column has the same number of decimal places, right alignment lines up the ones, tens and decimal points, so you can compare amounts at a glance. Left aligned amounts of different lengths lose that.
Left alignment works well for numbers that act like labels rather than amounts, such as order numbers, employee IDs, ZIP codes and years used as column headings. It also helps when a column mixes short numbers with text and you want one clean edge.
How to Put the Currency Symbol on the Left and the Number on the Right
Accountants often want the dollar sign at the left edge of the cell with the amount on the right. A custom number format can do this.
- Select the cells.
- Click Format > Number > Custom number format.
- Type $* #,##0.00 in the box.
- Click Apply.

In Google’s number format syntax, an asterisk repeats the next character, here a space, to fill the rest of the cell. That pushes the dollar sign to the left and the amount to the right, whatever alignment the cell has. For other ways to show money, read about using currency formatting in Google Sheets.
How to Vertically Center Cell Data
- Select the cells.
- Click Format > Alignment.
- Choose Middle. You can also pick Top or Bottom.
The data moves to the middle of the cell from top to bottom. You’ll notice it most in tall rows or cells with wrapped text. To make rows taller, learn how to change row height in Google Sheets. You can combine any horizontal and vertical option, like left and middle.
Default Alignment for Different Kinds of Data
Google Sheets aligns each kind of data differently until you change it:
- Text: left and bottom.
- Numbers, currency and dates: right and bottom.
- TRUE/FALSE values: center and bottom.
- Checkboxes: center and middle.

Numbers Sitting on the Left by Themselves?
If a number is already on the left and you never changed its alignment, Sheets is probably treating it as text. Text numbers look fine but give wrong totals and don’t sort as numbers. Common causes and fixes:
- A leading apostrophe. Typing ‘123 tells Sheets to keep the entry as text. Click the cell, delete the apostrophe in the formula bar and press Enter.
- Spaces before or after the number, often from pasted data. In an empty column, type =TRIM(A2) (use your first cell), then copy the formula down. TRIM removes leading, trailing and repeated spaces.
- Text that looks like a number. Use =VALUE(A2), which converts text in a number, date or time format into a number.
- The cells are set to a text format. Select them and click Format > Number > Number or Automatic, then type the values again.
After a formula fix, copy the new column, then right-click the original column and choose Paste special > Values only. Delete the helper column. To confirm the fix, type =SUM(A2:A20) with your own range. A sensible total means the cells hold real numbers.
Numbers stored as text can also slip past color rules, such as when you make cells red if a number is less than zero.
How to Add Space Before Text in a Cell
Google Sheets doesn’t have an indent button for cells. Two workarounds:
- Type spaces before the text in the cell.
- Use a custom number format: click Format > Number > Custom number format, type a few spaces followed by @, and click Apply. In Google’s syntax, @ displays the text entered in a cell, so the spaces show up in front of it.
The text moves away from the left edge, and the cell still counts as left aligned.
How to Left Align in the Google Sheets App
The app on Android, iPhone and iPad uses a Format panel instead of the menu bar.
- Open the spreadsheet in the Google Sheets app.
- Tap a cell. To include more cells, drag the blue markers.
- Tap Format. Its icon is a capital A with lines.

- On the Text tab, tap Left text align. Center text align and Right text align are next to it, and Top align, Middle align and Bottom align are below.
- Tap the sheet to close the panel.
The keyboard shortcuts don’t work in the app unless you use a hardware keyboard with a tablet.
Copy the Alignment to Other Cells
- Click a cell that already has the alignment you want.
- Click Paint format (the paint roller) in the toolbar.
- Drag across the cells that should match.
Paint format copies all of the cell’s formatting, including the font, colors and number format, not only the alignment. Double-click Paint format to apply it to several ranges, then click it again to stop.
When the Shortcut Does Nothing
- The shortcut does nothing. Press Esc if you’re still typing in a cell, then try again. A browser extension may also use the same keys. In Chrome, go to chrome://extensions/shortcuts to check. If you turned on Enable compatible spreadsheet shortcuts under Help > Keyboard shortcuts, some keys may follow another program’s layout, so turn it off to test.
- Alignment options are gray. You probably have view-only or comment-only access, or the cells are in a protected range. Ask the owner for edit access.
- A merged cell won’t align one part. A merged cell is one cell, so alignment applies to the whole block. To unmerge it, read about merging cells in Google Sheets.
- The numbers jump back to the right. Check the cells for a custom number format with an asterisk, which controls where the value sits regardless of alignment.
How to Check or Undo the Change
Select a cell and open Format > Alignment. A check mark shows the alignment it has now. To reverse a change right away, press Ctrl + Z (Command + Z). To reset alignment along with fonts, colors and number formats, use Format > Clear formatting, which puts numbers back on the right.
Sheets Alignment Questions
Why are my numbers on the right in Google Sheets?
That’s the default for numbers, currency and dates. Select the cells and choose Format > Alignment > Left to move them.
Does left aligning numbers change their values?
No. Alignment only changes where the value appears in the cell. Totals, sorting and formulas work the same way.
Can I make left alignment the default for new numbers?
Google doesn’t list a setting for default alignment. Select the whole column or sheet and left align it, and new numbers you type in those cells pick up the setting.
Why won’t my numbers align the way I set them?
A custom number format that uses an asterisk can fix the position of the value. Clear the formatting and apply your alignment again.
Can I align text in the Google Sheets app on my phone?
Yes. Tap the cells, tap Format, and choose an option on the Text tab. Tap the sheet to close the panel.
To tidy long entries next, learn how to wrap text in Google Sheets.
Related Guides

Matthew Burleigh is the founder, head writer, and editor of Solve Your Tech, which he launched in 2012. He has written technology tutorials since 2008 and worked in IT since 2003, including small-business support, IT management, and consulting. He holds Bachelor’s and Master’s degrees in Computer Science from Arizona State University.
Matthew writes practical guides for Windows, iPhone and iPad, Microsoft Office, Outlook, Google apps, and Android. Solve Your Tech’s guides are checked step by step against the device or app maker’s own documentation and tested on his own devices whenever he has the hardware or software, with clear steps, sources, and update dates.
Read more about Matthew and how Solve Your Tech writes and updates its guides, or report a correction.