Google Sheets Tips
none
How to Align Text in Google Sheets
SHARE THIS Article
Google Sheets supports horizontal alignment (left, center, right) and vertical alignment (top, middle, bottom). You can combine them in one cell, which gives nine common layouts for headers, labels, and numeric columns.
Why alignment matters in reports
Consistent alignment makes a P&L or budget table easier to scan: account names left, amounts right, section titles centered. Formatting alone does not fix stale data. Once the layout looks right, LiveFlow FP&A can keep the numbers under those headers updating from QuickBooks.
Horizontal alignment
Shortcuts
Select the cells to align.
Use Ctrl + Shift + L (Windows) / ⌘ + Shift + L (Mac) for left, Ctrl + Shift + E / ⌘ + Shift + E for center, or Ctrl + Shift + R / ⌘ + Shift + R for right.
If a shortcut conflicts with your browser, use the toolbar method below.
Toolbar
Select the cells.
Click the Horizontal align icon on the toolbar.
Choose left, center, or right.
Format menu
Select the cells.
Go to Format → Alignment.
Choose a horizontal option.
Vertical alignment
There is no widely reliable default shortcut for vertical align in Sheets. Use the toolbar or menu.
Toolbar
Select the cells.
Click the Vertical align icon.
Choose top, middle, or bottom.
Format menu
Select the range.
Go to Format → Alignment.
Choose a vertical option (top, middle, or bottom).
Tip: pair Wrap text with middle vertical align when header labels span two lines in a fixed row height.
Why finance teams use LiveFlow
Alignment is presentation. Live data is the substance. LiveFlow FP&A syncs QuickBooks Online (and other books) into Google Sheets so your carefully aligned report stays current without another export-and-reformat cycle.
CTA: Book a demo of LiveFlow FP&A for Google Sheets.
Supercharge your financial reporting