Ever found yourself frustrated with Excel printouts that lack gridlines, making your meticulously organized data look like a jumbled mess? Don't worry, you're not alone. By default, Excel doesn't print gridlines, but with a few simple steps, you can make your spreadsheets easier to read when printed.
Let's dive into how to get Excel to print with lines, ensuring your data stays as organized on paper as it is on screen.
Before You Begin: A Quick Word on Printer Settings
Before we begin, ensure your printer settings are configured correctly. Sometimes, printers can override Excel's print settings, so double-check your printer's properties to avoid any surprises.
Now, let's get started with customizing Excel's print settings.
Print Area vs. Entire Sheet
Before activating the gridlines, decide whether you want to print the entire sheet or just a specific area. To select a print area, highlight the cells you want to print before following the steps below. If you want to print the entire sheet, skip this step.
To select a print area, click and drag your cursor over the cells you want to print, then press 'Ctrl + A' to select everything. To deselect any unwanted cells, right-click and uncheck the '++] Visible' option.
Activating Gridlines in Excel
Now, let's activate the gridlines. Follow these steps:
1. Click on 'File' in the ribbon, then select 'Print'. Alternatively, press 'Ctrl + P'.
2. In the 'Print' window, click on the 'Page setup' link at the bottom.
3. Under the 'Sheet' tab, check the box next to 'Gridlines'.
4. Click 'OK' to close the 'Page setup' window, then click 'Print' in the 'Print' window to preview your printout.
Adjusting Print Scale for Better Results
Printing gridlines is a great start, but without the right scale, your printout might be too small or too large. Let's fine-tune your printout by adjusting the scale.
Excel allows you to adjust the scale for both columns and rows independently. Here's how:
Adjust Column Width
1. Place your cursor where you want the printed columns to start. Excel will display the column width for that column in the 'Print area' section of the 'Print' window.
2. Click on the small, double-headed arrow that appears next to the column width and drag it to adjust the width.
Adjust Row Height
The process for adjusting row height is similar to that for column width:
3. Place your cursor where you want the printed rows to start. Excel will display the row height for that row in the 'Print area' section of the 'Print' window.
4. Click on the small, double-headed arrow that appears next to the row height and drag it to adjust the height.
Printing in Landscape or Portrait Orientation
Sometimes, your data might be wider than it is tall, making landscape orientation more suitable. Conversely, tall data works best in portrait orientation. Let's adjust the orientation for the perfect printout.
Changing to Landscape Orientation
Follow these steps to change the orientation:
1. Click on 'Page layout' in the 'Print' window.
2. In the 'Orientation' group, click on 'Portrait' to switch to landscape orientation.
Changing to Portrait Orientation
If your data is taller than it is wide and you've chosen landscape orientation, simply follow these steps to switch back to portrait:
1. Click on 'Portrait' in the 'Orientation' group to switch to portrait orientation.
And there you have it – a perfectly printed Excel sheet with lines, the right scale, and orientation. Happy printing!