When you open Excel that grid shows up.How can I get it to print THAT grid?

Question

When I print all the info i put in shows up but without the grid.

Answer 1

Go to File / Page Setup / Sheet ... in the middle of the window is the Print category ... click on Gridlines.

BTW, I love how people answer these questions without the slightest clue!

Answer 2

The light grey lines the you see by default around all Excel cells are only there as an onscreen reference to making reading the screen easier. If you want to print gird lines, you have to use the Format menu and go under Border and Shading and actually add borders around the cells. When you, you will black, rather than grey lines onscreen between the cells. And they will print.

Answer 3

Click the worksheet.

On the File menu, click Page Setup, and then click the Sheet tab.

Select or clear the Gridlines check box.

Click Print.

Answer 4

Go to Format, then to Cells.. go to Border and click Inside and Outline - make sure you highlight the area you want as a grid.

Answer 5

Go to page setup and then hit the sheet tab. There is a spot there to click the gridlines on. Click that button and when you print it will print those otherwise you will get just blank sheets.

Answer 6

The lines you see are only for directional purpose and cannot print by default. To print them, set the border properties of the bounding lines you want from the format menu. You can set the diagonals, horizontal and vertical lines to print if you want.
Enjoy

Answer 7

You need to put borders around the grid so that it will print.

Answer 8

Go to file, Page Setup, Sheet and check the box next to gridlines.

Answer 9

highlight, right click, format cells, borders...