✦Template Printable Ideas Insights

"Print Gridlines in Excel Worksheets: Simple Modification Steps"

By

Have you ever found yourself in a situation where you needed to print a worksheet, but the gridlines were left out, leaving your document looking unprofessional or incomplete? Don't let this happen again. By modifying your worksheet's print settings, you can ensure that your gridlines print with the rest of your document.

To guide you through this process, we'll be focusing on two widely-used spreadsheet software - Microsoft Excel and Google Sheets. Let's dive into each method and explore how to modify your worksheets to print those all-important gridlines.

Microsoft Excel

Microsoft Excel is a staple in the world of spreadsheets, and its print settings are easy to adjust for gridlines.

Free Grid Overlay Tool for Drawing and Sketching
Free Grid Overlay Tool for Drawing and Sketching
The Grid Tool - Smarter Ruler for Spacing, Dividing, and Layouts
The Grid Tool - Smarter Ruler for Spacing, Dividing, and Layouts
Grid References worksheet
Grid References worksheet

To begin, open your worksheet and navigate to the 'Page Layout' tab. Here, you'll find the 'Print Area' and 'Scale to Fit' sections which are crucial for setting up your print settings.

Step 1: Set Up Print Area

Start by selecting the range of cells you want to print. This can be all the data in your worksheet or a specific range depending on your needs. After selecting the cells, click the drop-down arrow in the 'Print Area' section and choose 'Set Print Area'.

the draw the animal activity sheet for kids to learn how to draw an elephant's head
the draw the animal activity sheet for kids to learn how to draw an elephant's head
grid drawing worksheet for kids to learn how to draw
grid drawing worksheet for kids to learn how to draw
How to Calculate Grid For Drawing Outline in A4 Size Paper
How to Calculate Grid For Drawing Outline in A4 Size Paper

Remember, anything outside of your set print area won't be printed. So, ensure that the selected area includes all the data you need, but doesn't extend beyond what you want to print.

Step 2: Adjust Page Fit

Next, look at the 'Scale to Fit' section. Click the drop-down arrow and select either 'Wide' or 'Tall' based on how you want your printed worksheet to fit on the paper. If you choose 'Wide', Excel will shrink your worksheet to fit the horizontal page width. Conversely, 'Tall' will shrink it to fit the vertical page height.

To ensure your gridlines print, make sure you see the boxes next to 'Print selected cells' and 'Columns to repeat at left' ticked. This ensures that your column headers are printed and your layout retains its consistency across multiple pages.

Google Image Result for https://dryuc24b85zbr.cloudfront.net/tes/resources/12155189/image?width=500&height=500&version=1580213285159
Google Image Result for https://dryuc24b85zbr.cloudfront.net/tes/resources/12155189/image?width=500&height=500&version=1580213285159
the printable worksheet for fruit drawing puzzles
the printable worksheet for fruit drawing puzzles
5 Ingenious Ways You Can Do With Free Art Drawing Lessons
5 Ingenious Ways You Can Do With Free Art Drawing Lessons
a grid drawing worksheet with a tiger on it
a grid drawing worksheet with a tiger on it
the grid drawing practice sheet for students to learn how to draw faces and eyes with squares
the grid drawing practice sheet for students to learn how to draw faces and eyes with squares
an image of a drawing with the words how do you draw? and a picture of a
an image of a drawing with the words how do you draw? and a picture of a

Google Sheets

Google Sheets is a web-based alternative to Excel, offering a user-friendly interface with similar functionality. Here's how you can set up your print settings to include gridlines:

Begin by opening your spreadsheet in Google Drive. Click on 'File' in the menu at the top, then navigate down to 'Print' to open the print dialog box.

Step 1: Set Up Print Area

Choose 'Selection' from the print dialog box. This will print only the cells you've selected, similar to Excel. To select the range you want to print, click and drag across the cells in your worksheet. Once you've made your selection, your print settings will be adjusted to include only these cells.

Coordinate Grid: Basic Practice with Sports! | Worksheet | Education.com
Coordinate Grid: Basic Practice with Sports! | Worksheet | Education.com
Animal Grid Picture
Animal Grid Picture
How To Make Grid lines For Drawing On A4 and A3 Size Sheets???
How To Make Grid lines For Drawing On A4 and A3 Size Sheets???

Be sure to include all the data you need in your selection. Like Excel, anything outside of your selection won't be printed.

Step 2: Adjust Page Set-Up

Next, click 'Options' at the bottom of the print dialog box to open the 'Page Setup' window. Here, you can adjust settings for your print job. Make sure you check the box next to 'Scale with outside margins' to ensure your selected range prints without being stretched or squeezed to fit the page.

You don't need to worry about selecting 'Gridlines' separately, as Google Sheets includes them by default. However, if you've made any manual adjustments to your gridlines' width or color, make sure those changes are preserved in the print settings.

In both Excel and Google Sheets, always preview your print job to ensure that the gridlines are printing as expected. It's a small detail that can make a big difference in presenting your data clearly and professionally.

Now that you know how to modify your worksheets to print gridlines, you'll never have to worry about incomplete or unorganized printouts again. Happy printing!