Spreadsheet

[steve_b_wales]

I've formulated a spreadsheet to keep track on sales etc. I wanted to print a hard copy as well, but I cannot get the 'lines' to print. Is there a way of doing this?

[ph5172]

If you highlight it and right click you can see the option to add lines

or

On a worksheet, select the cell or range of cells that you want to add a border to, change the border style on, or remove a border from.

On the Home tab, in the Font group, do one of the following:

To apply a new or different border style, click the arrow next to Borders , and then click a border style.

Edited January 25, 2023 by ph5172

[steve_b_wales]

52 minutes ago, ph5172 said:

If you highlight it and right click you can see the option to add lines

or

On a worksheet, select the cell or range of cells that you want to add a border to, change the border style on, or remove a border from.

On the Home tab, in the Font group, do one of the following:

To apply a new or different border style, click the arrow next to Borders , and then click a border style.

Thank you. I'll try it later today. 

[Dougy]

Open Excel, 

top line under "Home" you will get this drop down. 

Best thing to do is open up a blank sheet and have a play with the options. 

 

[Piebob]

Turn on the "print gridlines" option, no need to draw the lines if you don't want to

 

 

 

Edited January 25, 2023 by Piebob