✦Template Printable Ideas Insights

How to Print Excel Sheet with Lines on Mac

By

Need to print your Excel sheet with lines on your Mac? You're not alone. Gridding off your worksheet for better organization or clarity can be a lifesaver. Here's a step-by-step guide on how to achieve this in a few simple steps.

Before we dive in, ensure your Excel version is macOS compatible. Our guide is tailored for Microsoft Excel for Mac 2011 or later. If you're using an older version or another platform like Google Sheets, the process might vary slightly.

Visibility and Print Settings

First, let's make sure your gridlines are visible in Excel. Often, they're turned off by default, so we'll enable them for a clearer worksheet.

[FREE] 141 Free Excel Templates and Spreadsheets
[FREE] 141 Free Excel Templates and Spreadsheets
an excel spreadsheet showing how to use the balance sheet in microsoft's workbook
an excel spreadsheet showing how to use the balance sheet in microsoft's workbook
Calender in Excel ‼️ Amazing Excel trick using data validation and conditional formatting ✅ #Excel
Calender in Excel ‼️ Amazing Excel trick using data validation and conditional formatting ✅ #Excel

Head to the 'View' tab, then click on 'Show' in the 'Sheet' group. Here, make sure 'Gridlines' is checked. Your worksheet should now display gridlines that you can print.

Printing Gridlines in Excel for Mac

Now, let's configure your print settings to include those gridlines.

Print Sheets in Excel
Print Sheets in Excel
how to print large excel sheet in one page
how to print large excel sheet in one page
Mac Excel Shortcuts Cheat Sheet | Excel Tips, Dashboard Templates & Formulas for Beginners
Mac Excel Shortcuts Cheat Sheet | Excel Tips, Dashboard Templates & Formulas for Beginners

Go to 'File' > 'Print' > 'Page Setup'. In the 'Page Setup' dialog box, select the 'Sheet' tab. Here, under 'Scaling', choose 'Fit to' and select the number of pages wide and tall you want for your sheet. Ensure 'Gridlines' is checked under the 'Printer settings'.

Printing Selected Cells Only

If you want to print only specific cells or a range, select those cells first. Then, go to 'File' > 'Print' > 'Print Active Sheets'. In the 'Print' dialog box, make sure 'Selection' is chosen under 'Print range'.

This will print only your selected cells along with their gridlines, making it great for focusing on a particular part of your worksheet.

7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
how to print a large excel spreadsheet on one page
how to print a large excel spreadsheet on one page
3 Crazy Microsoft Excel Formulas That Are Extremely Useful
3 Crazy Microsoft Excel Formulas That Are Extremely Useful
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)
Copy Data From One Sheet to Another in Excel
Copy Data From One Sheet to Another in Excel
List on Mac
List on Mac

Printing Hidden Content

Sometimes, you might want to print hidden content, like formulas or comments, along with your gridlines.

Hidden content can be 'unhidden' for the print job by following these steps: 'Page Setup' > 'Sheet' tab > Under 'Printer settings', click 'Print', then check 'Print what' and select either 'Formulas' or 'Comments' (or both).

Printing Multiple Pages Per Sheet

Got a large worksheet? You can fit more data on a page by printing multiple pages per sheet. Here's how:

Progress Tracker in Excel‼️ #excel
Progress Tracker in Excel‼️ #excel
Excel Shortcuts for Mac Excel Mac Excel Cheat Sheet for Mac Excel Formulas Microsoft Excel Gift Excel Shortcuts Guide Checkbook Bookkeeping
Excel Shortcuts for Mac Excel Mac Excel Cheat Sheet for Mac Excel Formulas Microsoft Excel Gift Excel Shortcuts Guide Checkbook Bookkeeping
Printing Excel Spreadsheet: Everything You Need to Know
Printing Excel Spreadsheet: Everything You Need to Know

In 'Page Setup', under 'Scaling', choose ' Fit to ' and specify the number of pages wide and tall. Excel will then use the specified number of pages to print your worksheet.

In conclusion, printing an Excel sheet with gridlines on a Mac is a breeze once you know where to look. Now you can organize and share your data with confidence. Happy printing!