Skip to Content

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

Question

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?

Solution

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

Tags

Tags

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. We need money to operate the site, and almost all of it comes from online advertising. Please support us by disabling these ads blocker.

Please disable ad blocker