How to Print Gridlines in Excel?
Excel is a powerful tool that you think you know about, but might not actually be using to its maximum potential. One such feature is gridlines.
Learning how to print gridlines in excel can go a long way as it will let you work more efficiently and also look professional.
Gridlines are tiny lines that run across your excel spreadsheets. These lines help you easily align your cells and ensure they are properly aligned.
This means that they can help you beautify your spreadsheet. This blog is focused on showing you the printing gridlines in excel.
Using Sheet option to print gridlines
The quickest way to obtain gridlines is by modifying the page settings accessible through the “Sheet Options group”. The following are the steps to obtain gridlines for your page.
- Select Page Layout. This will be found in the top portion of your Excel window under the tabs. Once you’ve done this, look for Sheet Options (the group of tools).
- This feature contains two options, one for Gridlines and the second for Headings. Under the Gridlines option, there are checkboxes for View and Print. Make sure the box beside ‘Print’ is checked.
- By going to File -> Print you will have the ability at the last point of navigation before actual printing, to decide how your outputted sheet will look by choosing from a list of many different options such as “Print with Grids”. When in this mode navigate over to the print preview which is usually the option named “Print Preview.” Once there you can then click on print when you’re ready and proceed accordingly.
Using Page Setup Launcher Tool to Print Gridlines
Using the launcher, located in the upper-right corner of each Excel worksheet, you can open the Task Pane contextual tab launcher switch to access all group context-sensitive task panes.
Once again, if you prefer for your gridlines to appear onscreen while printing your spreadsheets, simply click on the Gridlines Launcher that you’ll see right next to the File button.
If you want to make sure that the gridlines will be printed whenever your data is, then you need to use the Page Setup launcher. Here are the steps you need to follow:
- To print your cell, select the particular cell that you want to print. Look at one of the upper corners of this selected cell. You’ll find a button there labeled Print Area. Select the Page Layout tab (in the top portion of your Excel window) which will give you further options related to formatting and printing your spreadsheet.
- Now find the ‘Page Setup’ group of tools under this tab.
- At the bottom right corner of this group, you will see a small, white dialog box launcher. Click this tool to launch the Page Setup dialog box.
- It will open the Page Setup dialog box.
- On the top of this box, there is an option of the sheet, you have to click on it.
- Move to the print section, under this section, the Option of Gridlines will appear on the screen and you have to mark this option. Now it will assure you that gridlines will appear when you take the print.
- To see a preview of how your web page will look when printed, you can click on the Print Preview button from the bottom of the window on your computer screen. This takes you to the Print menu where you can check on your print preview. You’ll know that it looks just right once you get what you want.
Now, you may ask yourself why you should use this dialog box as opposed to the other method where you simply check the option in the ribbon itself and then print with gridlines.
Furthermore, let us now discuss how this method is faster than printing with gridlines because it only focuses on the current page and not your entire document.
If you want to print gridlines on your pages, there are two ways to do this: you can use the Page Setup dialog box (it’s faster) or you can manually open and edit your page setup (using either Microsoft Word 2000 or 2013 for Windows).
When using the Page Setup Dialog Box, we recommend checking out all of the Print Options – which include repeating headers and footers across all printed pages as well as changing layout and printing row numbers.
FAQs: How to Print Gridlines in Excel
Why won’t my gridlines print in Excel?
If gridlines are missing from your print preview or resulting printout, you probably have the “Draft quality” active for your printer.
This option is designed to save ink, so it omits extra information like the gridlines. To enable this option, go to File > Print > Page Setup in Excel. Click the “Sheet” tab.
Why can’t I see print preview in Excel?
You have to click on the QAT and then select Customize Quick Access Toolbar. By default, the Ribbon has many commands available to us.
Instead of using them, we can add our own custom commands to the QAT, such as Print Preview Full Screen instead of Print Preview and Print.
Conclusion
You can print gridlines on the excel sheet. These gridlines on the excel sheet will be used to assist you in drawing the proper size of boxes, which are present in the grid.
Gridlines are drawn on the excel sheet for the purpose of drawing the proper size of squares or rectangles, which are present in the grid.
This article explains “How to print gridlines in Excel” and shows you step by step how to print the lines and cells borders in Excel to make it easy to align and line up information in your Excel spreadsheet.
I hope that after reading this guide, you can easily print gridlines in excel. If you have any further queries regarding this, then tell us in the comment section.
For more information about Excel visit our website.
Leave a Reply