How to Left Align a Spreadsheet When Printing in Google Sheets


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. 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 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.

click the file tab

 

 

Step 3: Click the Print option at the bottom of the menu.

click the print option on the menu

 

 

Step 4: Click the Formatting tab at the right side of the window.

click the formatting tab

 

 

Step 5: Click the dropdown menu under Horizontal in the Alignment section of the menu, then click the Left option.

how to left align a spreadsheet in google sheets

 

 

Step 6: Click the Next button at the top-right corner of the window.

click the next button

 

 

Step 7: Confirm the rest of the Print settings on this menu, then click the Print button to print the left-aligned spreadsheet.

print in google sheets

 

 

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.

birthday t-shirts for boys
vintage t rex t-shirt