In this article we will show you the solution of how to print excel spreadsheet with lines, MS Excel is a software application created by Microsoft that enables user to organize and analyze data, calculate values using spreadsheets.

It also have some in built features which make excel an excellent tool.

It is used by every type of businesses, organizations worldwide. It features computing capabilities, graphing tools etc. Excel record data in tables.

A spreadsheet consist of several rows and columns. Now a days Excel analysis is ubiquitous around the world.

It is used across all business related functions at companies of every size.

Multiple can user can work on a single spreadsheet at a time, also spreadsheet can be shared to other user to work on.

Excel sheet can be converted to hard copy as well.

In some cases, for example in case of large dataset, printing without gridlines will be hard to use.

The hard copy would typically be an eyesore. For this reason user can print the data in spreadsheet with lines.

Step By Step Guide On How To Print Excel Spreadsheet With Lines :-

1. Open a excel file.
2. Now for example we are entering SERIAL NO, NAME, AGE, GENDER.
3. After that we are putinge the value in the columns for respective headings.
4. Then select the part which is needed to print by clicking.
5. Then click on the top toolbar section for Centre Alignment of all the value in their respective cells.
6. You can see the excel sheet will look like that after Centre alingmnet.
7. After that again select the written portion by clicking and select page layout option from the top toolbar.
8. Then click on Print area and then set print area option.
9. Now those selected area is ready for print, now click on the left topmost corner of the screen.
10. Then click on Print option and after that click on print preview option.
11. Now this page will appear in the screen.
12. Then select page set up option from the top toolbar.
13. A new pop up window will appear in the screen. Select Sheet Option from the pop up window.
14. Then select gridline option and press ok button in the pop up window.
15. This page will appear in the screen with the lines.
16. Then click on print option at the top toolbar.
17. Then a pop up window for printing the file will open and click on the OK option to print the excel file with lines.

Conclusion :-

This is how a spreadsheet can be print with the lines. This feature is really a savior for offices who work with large database.

I hope this article on how to print excel spreadsheet with lines helps you and the steps and method mentioned above are easy to follow and implement.