How to add lines while printing on Microsoft excel?

Question

i have the new Microsoft Excel and i cannot figure out how to print with all the lines on the page...i need it as a order form so i need all the line spaces

Answer 1

Hi!

If you're using Excel 2003, here are the steps:

1) From File on the file menu, click on Page Setup

2) Select the Sheet tab

3) Check Grid-lines

If you're using Excel 2007, here are the steps:

1) Click on the Page Layout tab, look for the Sheet Options box

2) Select the checkbox next to Print under the Gridlines

Hope that helps

Answer 2

For Excel 2003:

The gridlines can be printed by clicking File  >  Page Setup and clicking the Sheet tab, then putting a check mark by 'Print Gridlines'.  Bear in mind ALL gridlines will show regardless of whether they contain data or not.

Another way is to add borders to the cells you want printed and then only the borders will show when printed.  Highlight the area you want to have cell borders, then click the 'Borders' dropdown menu and select the one that shows borders around 4 cells.