When it comes to presenting data from Excel, sometimes you need to print your worksheet in a way that preserves the gridlines. This can be particularly useful for sharing worksheets that have been thoroughly formatted, or when you want to emphasize the structure of your data. In this guide, we'll explore how to print Excel with gridlines, using both Microsoft Excel and Google Sheets.
Before diving into the steps, ensure that your gridlines are visible in the first place. By default, Excel and Google Sheets hide gridlines to keep worksheets clean and uncluttered. Let's start by learning how to turn these gridlines on.
Enable Gridlines in Excel and Google Sheets
Both Excel and Google Sheets allow you to enable gridlines. Here's how:
In Excel: The fastest way is to press Ctrl + Shift + * (Windows)/Cmd + Shift + * (Mac). Alternatively, you can right-click and select Format Cells, then tick Gridlines under Border.
Excel Gridlines Visibility by Cell Selection
If you want to see gridlines only around selected cells, follow these steps:
1. Select the cells where you want to see gridlines.
2. Go to the Home tab.
3. Click on Format in the Styles group.
4. Choose Format as Table, and then click OK.
5. Right-click the selected cells and choose Table Properties.
6. Check the Banding circle to show gridlines only around the selected cells.
Google Sheets Gridlines Visibility
Google Sheets also allows you to turn your gridlines on or off. To do this:
1. Open your Google Sheet.
2. Click on View in the menu.
3. Check Show > Gridlines to enable them, or uncheck it to hide them.
Now that you know how to enable gridlines, let's dive into printing your worksheet with gridlines.
Print Excel with Gridlines
Printing Excel with gridlines is a straightforward process. Here are the steps:
Printing Gridlines in Excel
1. Open your Excel worksheet.
2. Click the File tab, and then click Print.
3. In the Print view, ensure that the Print active sheets option is selected.
4. Customize your print settings, such as the print range and page orientation, if needed.
5. Click the Print button or press Ctrl + P to start printing. Your gridlines should now appear on the printed page.
Printing Gridlines in Google Sheets
Google Sheets doesn't provide a direct way to print gridlines, but you can take a screenshot of your worksheet or use a workaround with the Print Layout feature. Here's how:
1. Open your Google Sheet.
2. Click on View in the menu, then click Print Layout.
3. In the Print Preview window, click Print or use Ctrl + P. The gridlines should now appear on the printed page.
Printing gridlines in Google Sheets can sometimes result in white space issues, so consider using the techniques above to achieve the most accurate results.
Printing your Excel worksheet with gridlines allows you to present your data in a clear and well-structured manner. With these steps, you can effectively print gridlines in both Excel and Google Sheets. Keep experimenting with the printing options to find the layout that best suits your needs!