Ask Your Question

How can I set up horizontal and vertical lines on a spreadsheet?

asked 2019-06-18 21:35:43 +0100

Davvy gravatar image

updated 2020-08-02 03:02:58 +0100

Alex Kemp gravatar image

I want all the dividing lines on a spreadsheet -- horizontal and vertical -- to show up when I print it out. How to do this?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-06-18 22:16:19 +0100

Opaque gravatar image

updated 2019-06-18 22:18:53 +0100

Format the cells to have borders.
To do so

  • Select range of cells (or all cells by clicking the grey square top-right of the sheet)
  • Right click and select Format Cells - or - press CTRL+1
  • Select Tab "Borders" and add the borders according to your preferences

image description

If the answer is correct or helped you to fix your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-06-18 21:35:43 +0100

Seen: 535 times

Last updated: Jun 18 '19