how to print a blank excel sheet with gridlines

How to Print Blank Excel Sheet with Gridlines

By David Harris
AD

Ever found yourself in need of a blank Excel sheet with gridlines for data entry, organization, or analysis? While Excel provides numerous templates and predefined formats, sometimes all you need is a simple, clean grid. Here's how to print a blank Excel sheet with gridlines in just a few steps.

Before we dive into the process, ensure you're using a compatible version of Microsoft Excel, such as Excel 2010, 2013, 2016, 2019, or the latest version, Excel 365. The following guide should work for both Windows and Mac users.

Creating a Blank Excel Sheet

Your blank sheet with gridlines starts with creating a new, untitled workbook.

AD
How to print blank worksheet with gridlines in Excel?
How to print blank worksheet with gridlines in Excel?
Guide: Print Blank Grid lines On Excel Sheet
Guide: Print Blank Grid lines On Excel Sheet
Courses and Tutorials in Templates | Envato Tuts+
Courses and Tutorials in Templates | Envato Tuts+

Here's how to do it:

New Workbook

Excel opens to a startup screen by default. If you don't see it, open the 'File' menu and select 'New'.

how to print large excel sheet in one page
how to print large excel sheet in one page
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
Printing Excel Spreadsheet: Everything You Need to Know
Printing Excel Spreadsheet: Everything You Need to Know

In the 'New' screen, select 'Blank workbook' and click 'Create'. You'll see a new, clean sheet ready for your input.

Hiding the Default Row and Column Headers

By default, Excel displays headers for rows (1, 2, 3...) and columns (A, B, C...). Although these are useful in most cases, they might be unnecessary or distracting for a blank sheet.

AD

To hide them, right-click inside the sheet (make sure you're not clicking on a header) and select 'View Side Panel' -> 'Sheet Options' -> 'Hide Headers'. The row and column labels will disappear, leaving you with a clean, blank grid.

Change the Gridline Color in Excel Spreadsheets - 2 Ways!
Change the Gridline Color in Excel Spreadsheets - 2 Ways!
How To Print Large Excel Sheet | One Page Print Setup (Excel Tips & Tricks)
How To Print Large Excel Sheet | One Page Print Setup (Excel Tips & Tricks)
How to Print Gridlines in Excel
How to Print Gridlines in Excel
Free Spreadsheet Templates for Excel & Google Sheets
Free Spreadsheet Templates for Excel & Google Sheets
How to Print Excel Sheet with Lines (3 Methods) - ExcelDemy
How to Print Excel Sheet with Lines (3 Methods) - ExcelDemy
141 Free Excel Templates - Download and Boost Your Efficiency
141 Free Excel Templates - Download and Boost Your Efficiency

Printing the Blank Excel Sheet

Once you're satisfied with your blank sheet, it's time to print it. Ensure your printer is connected and ready before proceeding.

Here's how to print your blank sheet:

AD

Printing the Active Sheet

Press 'Ctrl + P' (Windows) or 'Command + P' (Mac) to open the 'Print' dialog box. Ensure 'Active Sheet' is selected under the 'Print' range.

Excel How-To: Starting a Basic Spreadsheet
Excel How-To: Starting a Basic Spreadsheet
Survey Spreadsheet Template
Survey Spreadsheet Template
How to Print Gridlines in Excel (2 Ways) - ExcelDemy
How to Print Gridlines in Excel (2 Ways) - ExcelDemy

Make any necessary adjustments, such as selecting a different printer, changing the paper size, or setting the page layout. Once satisfied, click 'Print'. Your blank sheet with gridlines will start printing, and the printer will display a confirmation once completed.

Printing Entire Workbook

If your blank sheet isn't the only one you need to print, you might want to print the entire workbook instead. This is useful if you have multiple sheets with data.

AD

In the 'Print' dialog box, select 'Entire Workbook' under the 'Print' range. This will print all the sheets in your current workbook.

Again, adjust any necessary printing settings before clicking 'Print'. Your printer will print out each sheet one by one.

And there you have it! You've successfully printed a blank Excel sheet with gridlines. This technique is useful for various purposes, such as data entry, templates, or analysis. Keep refining your Excel skills to streamline your work and make daily tasks more efficient.

AD