Excel print gridlines
In one of our last articles we have already shown how to remove gridlines in Excel. But the functionality of gridlines goes one step further, as they can also be an advantage for printouts in order to create more clarity. Therefore, in this tutorial we will show you how to print gridlines in Excel or how to turn the feature off. By default, however, this should not be turned on. Once again, it is important to know the location of the function. This is not the same as for enable oder remnve the gridlines from the last post (even though you will see the function a second time here).
Excel table print with lines for more overview:
Generally, it depends on your project. For some printouts gridlines make sense, for others not. Therefore, in Microsoft Excel it is simply even more important to know many functions so that decisions can be made that are tailored to the individual requirements of the user.
- Open Microsoft Excel
- Switch to the “Page Layout” tab
- In the group “Sheet options” you will find the area for gridlines
- Check the “Print” box
Only a few clicks are necessary to print the gridlines in Excel. We hope that this article has helped you with your current project. If you have further questions or are looking for tips and tricks, we have several playlists for Excel tutorials and functions on Youtube. Just have a look!
Links with * are affiliate links. By purchasing via this link we receive a part of the purchase price as commission without any additional costs for you. This helps us to expand the offers available here for you! Thank you!