How do I print gridlines on an entire excel page with no content in the cells?

Question

It will only print the gridlines with cell content. I want all gridlines regardless if they have content or not.

Answer 1

you should be able to set that in Format-Borders

Answer 2

On file menu choose page setup. Mark gridlines from the sheet tab and then select the print area. That's it!

Answer 3

You could try applying borders. That would give you a solid grid, and if you fill them white, you'll get an empty cell which "technically" has content.

To apply borders:

1. Highlight your cells
2. Click Format (in the main menu)
3. Click Cells
4. Click the Borders tab
5. Choose your border style, then hit OK

For the white background, before hitting OK, click the Patterns tab, and choose the white colour. Then hit OK.

Hope that's what you were after

Answer 4

to print the gridlines you have to put a period or something in the very last rectangle in the right side of the page. make sure that it is the last one.

Answer 5

1. Highlight the entire excell page,
2. Right click
3. Explore to the end

Answer 6

just highlight the whole page -- then right click - format cells - border, then pick the border and inside lines (and thickness needed) then print :) Ta-Da! An empty grid!

Answer 7

Go to Page Setup then the Sheet tab. You will see a checkbox to print grid lines there.

Answer 8

use the border tool to outline each block you want to show in the grid, then it will print all the lines