✦Template Printable Ideas Insights

How to Print Excel with Lines on Mac

By

Ever found yourself poring over Excel sheets on your Mac, only to realize you need to print them but can't figure out how to include lines? You're not alone. Excel printing can be a bit puzzling, especially when it comes to including gridlines. Let's simplify the process and ensure your printed Excel sheets are exactly as you want them.

Before we dive into printing with lines, let's ensure your Excel gridlines are visible on your Mac. By default, they should be, but if they're not, you can enable them by clicking 'View' in the menu bar, then 'Show' and check 'Gridlines'.

Preparing Your Excel Sheet for Printing

Before you print, it's crucial to ensure your Excel sheet is ready. This involves setting up your page size, margins, and scale. Here's how:

7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
Mac Excel Shortcuts Cheat Sheet | Excel Tips, Dashboard Templates & Formulas for Beginners
Mac Excel Shortcuts Cheat Sheet | Excel Tips, Dashboard Templates & Formulas for Beginners
a notebook with microsoft excel written on it
a notebook with microsoft excel written on it

1. Click 'File', then 'Page Setup'.

2. Choose your preferred printer settings like paper size, orientation (portrait or landscape), and scale.

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)
Microsoft Excel Shortcuts| Data Analysis Tools| Tips and Tricks Spreadsheets|Excel Tutorial Formulas
Microsoft Excel Shortcuts| Data Analysis Tools| Tips and Tricks Spreadsheets|Excel Tutorial Formulas
the microsoft excel overview is shown in this hand - written document, with instructions to use it
the microsoft excel overview is shown in this hand - written document, with instructions to use it

Including Gridlines in Your Printout

Now that your sheet is set, let's ensure gridlines are included in your printout. Here's how:

1. In the 'Page Setup' window, under 'heet ', select 'Fit to options. Then, check 'Sheet Scale ' and choose a scale (like '100%').

2. Click 'Options' (found just above the 'Print' button). Under 'Sheet options', check 'Gridlines'.

Copy Data From One Sheet to Another in Excel
Copy Data From One Sheet to Another in Excel
3 Crazy Microsoft Excel Formulas That Are Extremely Useful
3 Crazy Microsoft Excel Formulas That Are Extremely Useful
the excel formulas sheet is shown with numbers and dates on it, as well as other
the excel formulas sheet is shown with numbers and dates on it, as well as other
List on Mac
List on Mac
a poster with instructions to use excel formulas
a poster with instructions to use excel formulas
how to print large excel sheet in one page
how to print large excel sheet in one page

3. Click 'OK' to close the 'Page Setup' window, then 'Print'.

Printing Selected Rows or Columns

Sometimes, you might want to print only a specific range, like a particular table or a filtered list. Here's how:

1. Select the cells you want to print (you can do this by clicking and dragging).

CheatSheets (@thecheatsheets) on Threads
CheatSheets (@thecheatsheets) on Threads
How to separate information on Excel
How to separate information on Excel
Split the difference ✂️ Now rollled out in #Excel for Office 365
Split the difference ✂️ Now rollled out in #Excel for Office 365
a notepad with the text ms excel formulas page 3 written in black ink
a notepad with the text ms excel formulas page 3 written in black ink

2. Right-click in the selection, then select 'Print' from the context menu. Your selected range will be printed, including gridlines if you've enabled them.

Printing Excel Sheets with Lines Using AirPrint

If you're using an iOS device or an iPadOS app on your Mac, you can take advantage of AirPrint to print your Excel sheets with lines. Here's how:

1. Open your Excel sheet, then select the cells you want to print (or leave blank for the entire sheet).

2. Click the 'Share' button on the toolbar, then 'Print' from the dropdown menu.

Adjusting Print Settings in the iOS Print Menu

Once in the iOS print menu, you can adjust settings like scaling, orientation, and paper size. Here's how:

1. Tap 'Options', then 'Scale' to choose how you want to fit the content to the page.

2. Tap 'Portrait' or 'Landscape' to change the orientation of your printout.

3. Tap 'Paper Handling' to select your preferred paper size.

Once you're satisfied with your print settings, tap 'Print' in the top right corner to print the Excel sheet.

That's it! You're now equipped to print your Excel sheets with lines on your Mac, whether you're using the built-in printer dialog, AirPrint, or a third-party app. Happy printing!