How to Show or Hide Gridlines on Spreadsheet

How to Show or Hide Gridlines on Spreadsheet

October 22, 2018

Gridlines are the faint lines that appear between cells on the worksheet by default.

gridline-by-default

When using spreadsheet to create different forms such as budget, calendar, payment receipt, and sales report, there is a way to make the worksheet to look more professional and neat. This way is to hide the gridlines so the background of the worksheet will become white. Those lines you see on spreadsheet will disappear.

There are two methods to remove gridlines:

Method 1

1.Click the small button over 'Premium' on the top left corner, then hang over 'Tools', and click 'Options'

find options

2.Uncheck Gridlines under Window Options and click 'OK' to confirm.

uncheck_gridlines

Method 2

Navigate to the View tab in the toolbar and uncheck View Gridlines box

uncheck_gridlines_View

Gridlines is removed. Now, you can change the background style or color.

hide

However, what if we only want to add gridlines for the cells we are working on?
Fairly simple. Just choose the working cells and choose the border style you want.

border

The desirable worksheet is shown like below.

complete

For more tutorials, please check https://kingsoftoffice.desk.com/

WPS Office for Free with no-ads version is also available in the Microsoft Office store. Click here to download.

About Author

Marketing team in the WPS office located in Mountain View