Skip to Content

Solved: How do I print all columns and rows together with grid lines in Microsoft Excel?


I was able to print an Excel sheet with all the columns and rows that I have selected using Set Print Area. For some reason now it only prints the last column. How do I print all of the columns and rows together with grid lines in Microsoft Excel?


Check the Page Setup settings.

Check File > Page Layout > Print Area > Clear Print Area and then try again.

Clear Print Area option in Microsoft Excel

If you want to print the gridlines, choose File > Page Layout > Gridlines checkbox in the Print section.

Print gridlines in Microsoft Excel

    Ads Blocker Image Powered by Code Help Pro

    Your Support Matters...

    We run an independent site that\'s committed to delivering valuable content, but it comes with its challenges. Many of our readers use ad blockers, causing our advertising revenue to decline. Unlike some websites, we haven\'t implemented paywalls to restrict access. Your support can make a significant difference. If you find this website useful and choose to support us, it would greatly secure our future. We appreciate your help. If you\'re currently using an ad blocker, please consider disabling it for our site. Thank you for your understanding and support.