✦Template Printable Ideas Insights

Print Excel Spreadsheet with Bold Horizontal Lines

By

Ever found yourself staring at an Excel spreadsheet and wondering, "Can I print an Excel spreadsheet with lines?" You're not alone. Understanding how to print an Excel spreadsheet with lines can help organize your documents, make data clearer, and enhance visual appeal.

In this guide, we'll delve into when and how to print Excel spreadsheets with lines. We'll explore ways to display data with rows, columns, and Gridlines. Let's dive right in!

Adding Vertical Lines (Columns)

Vertical lines in Excel, known as gridlines, are perpendicular lines that separate columns. By default, gridlines are not printed. To print them, you need to adjust the print settings. Here's how:

Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
[FREE] 141 Free Excel Templates and Spreadsheets
[FREE] 141 Free Excel Templates and Spreadsheets
How do I print the gridlines in my spreadsheet in Excel 2007, 2010 and 2013?
How do I print the gridlines in my spreadsheet in Excel 2007, 2010 and 2013?

1. Click on File, then select Print.

2. Under Settings, choose Sheet.

Your Custom Budget Spreadsheet Solution
Your Custom Budget Spreadsheet Solution
a printable spreadsheet is shown in the form of a sheet with numbers
a printable spreadsheet is shown in the form of a sheet with numbers
an info sheet with different types of graphs and numbers on the bottom right hand corner
an info sheet with different types of graphs and numbers on the bottom right hand corner

3. Check the box for 'Print gridlines'.

Adding Horizontal Lines (Rows)

Similarly, horizontal lines, or row borders, can be printed for better data organization. Here's how to print rows with lines:

1. Select the range you want to print. If you want to print all rows, click in the top-left corner of your worksheet (where the row and column labels intersect).

Change the Gridline Color in Excel Spreadsheets - 2 Ways!
Change the Gridline Color in Excel Spreadsheets - 2 Ways!
how to print a large excel spreadsheet on one page
how to print a large excel spreadsheet on one page
Free Employee Attendance Sheet Template
Free Employee Attendance Sheet Template
Eisenhower Matrix Spreadsheet Template. Excel Google Sheets. Task Priority Matrix. Urgent-Important Priority Tracker. Decision Matrix.
Eisenhower Matrix Spreadsheet Template. Excel Google Sheets. Task Priority Matrix. Urgent-Important Priority Tracker. Decision Matrix.
an image of a spreadsheet with graphs and pie chart on the top right side
an image of a spreadsheet with graphs and pie chart on the top right side
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step

2. Right-click and select 'Format Cells'.

3. In the 'Number' tab, under 'Format', choose 'Custom'.

4. In the Type field, add a series of underscores "__" equals the number of columns you have.

a spreadsheet with the number of items in it
a spreadsheet with the number of items in it

5. Click OK. The selected rows will now be separated by horizontal lines.

Print Blank Rows and Columns

1. Click on File, then select Print.

2. Under Settings, choose 'Selection' instead of 'Sheet'.

3. Choose the range you want to print (including any blank rows or columns).

4. Click Print.

Printing Gridlines with No Data

Sometimes, you might want to print just the gridlines with no data. This can come in handy for creating templates or guidelines. Here's how:

1. Type a space or any character in a cell where you want the gridlines to start.

2. Select the range you want to print, including the spaces.

3. Follow the steps above to print gridlines.

That's it! Now you know how to print Excel spreadsheets with lines, from vertical and horizontal lines to printing gridlines only. Happy printing!