Grid lines
| # | Post |
|---|---|
| 1 | I have forgotten how to insert gridlines onto an excel sheet. Google says go to view page layout but I cannot see page page layout, Please help greenforde - 2021-09-06 19:48:00 |
| 2 | What version of excel? nice_lady - 2021-09-06 20:38:00 |
| 3 | Giving the version of Excel you are using will help narrow it down, but try this... Edited by cookee_nz at 8:42 pm, Mon 6 Sep cookee_nz - 2021-09-06 20:39:00 |
| 4 | Libra Office 6.3 greenforde - 2021-09-06 21:10:00 |
| 5 | Then it's not excel nice_lady - 2021-09-06 21:19:00 |
| 6 | https://ask.libreoffice.org/t/how-do-i-show-gridlines/32136/ nice_lady - 2021-09-06 21:21:00 |
| 7 | It is called calc spreadsheet in Libra. greenforde - 2021-09-06 21:47:00 |
| 8 | Yes I'm well aware of that but it's still not excel. And those the controls and method of doing things are different. Did the link In put up help? nice_lady - 2021-09-07 06:17:00 |
| 9 | No sorry. greenforde - 2021-09-07 07:42:00 |
| 10 | I'm not sure whether this is what you're trying to achieve but I did this in Libre Office 6.4 so it'll be pretty much the same in 6.3: You firstly highlight the area you want by dragging the mouse over an area then you clik BORDERS (shown with the vertical arrow in the pic), then you clik whichever one of the border choices you want, (I used the one at the bottom right), then you'll see it has put the chosen 'grid' into the highlighted area. https://trademe.tmcdn.co.nz/photoserver/full/1604573394.jpg nice_lady - 2021-09-07 08:08:00 |
| 11 | Phew came back to my 83 year old brain as soon as I read your post. Thank you very much for your patience. greenforde - 2021-09-07 08:21:00 |
| 12 | Select Format then Page then sheet & check the box Gridlines timberman - 2021-09-21 20:04:00 |
| 13 | Depends on what you want to achieve. nice_lady - 2021-09-21 20:30:00 |
| 14 | umm Borders? king1 - 2021-09-21 21:06:00 |
| 15 | Tools - Options - LibreOfficeCalc - Grid. Tick visible grid. lythande1 - 2021-09-22 08:30:00 |
| 16 | it's debatable whether OP actually meant gridlines, or borders... king1 - 2021-09-22 09:02:00 |
