In many cases a spreadsheet will look better on the printed page if all of the spreadsheet data is aligned at the center of the page. You may even find that merging some of your cells and centering is useful as well. There’s something about centering information on a page that is just more visually appealing. Unlike Microsoft Excel, Google Sheets will horizontally center your spreadsheet by default.
But there are certain spreadsheet layouts that look better when they are left aligned, and you may find that you need to make this change to your spreadsheet. Our tutorial below will show you where to find the setting that controls the page’s horizontal alignment so that you can select the left alignment option.
- How to merge cells in Google Sheets
- How to wrap text in Google Sheets
- How to alphabetize in Google Sheets
- How to subtract in Google Sheets
- How to change row height in Google Sheets
How to Change the Page Alignment for a Google Sheets Spreadsheet
These steps were performed on a spreadsheet in Google Sheets. The default alignment for printing spreadsheets in this application is center alignment. This means that a sheet with one column would print that column at the center of the sheet. Changing the printing alignment using the steps below will cause that spreadsheet to print the first column so that it is aligned with the left side of the page instead.
Step 1: Open your Google Drive at https://drive.google.com/drive/my-drive and double-click the spreadsheet that you would like to print with left alignment.
Step 2: Click the File tab at the top of the window.
Step 3: Click the Print option at the bottom of the menu.
Step 4: Click the Formatting tab at the right side of the window.
Step 5: Click the dropdown menu under Horizontal in the Alignment section of the menu, then click the Left option.
Step 6: Click the Next button at the top-right corner of the window.
Step 7: Confirm the rest of the Print settings on this menu, then click the Print button to print the left-aligned spreadsheet.
Would you like to print your spreadsheet without the gridlines that separate the individual cells? Learn how to hide gridlines in Google Sheets and print a page that only has your data on it.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.