printing s/sheet with grid for reference

[nicky18]

Hi All,

I need to prit a speadsheet showing all grids and the rows and colums, because i will be printing a spreadsheet with formulas and need to able to see for exmple when thre is refrence to cell C8, I can see what is cell row 8 and column C from the grid.

Thanks.

[sweep]

Hi,

Go To File > Page Setup > Sheet

Under the "Print" heading select "gridlines" and "row and column headings"

OK

[Richard Buttrey]

Hi,

I don't know of any inbuilt functionality that will achieve this. The only thing you can do is label row 1 with the lables A, B, C ...etc, and label column 1 with 1,2,3,4..etc, then include Row1 & Column 1 in your print range.

I assume you're referring to the grid lines. Again I think the only thing you can do is mimic the grid lines by formatting all cells with a border line.

HTH