How can you show or hide the grid lines in Excel worksheet?
2019
How can you show or hide the grid lines in Excel worksheet?
- A.
Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
- B.
Click Gridline tool on Forms toolbar
- C.
Both (A) & (B)
- D.
None of these
- E.
Only by restarting Excel
Attempted by 595 students.
Show answer & explanation
Correct answer: C
To show or hide grid lines in an Excel worksheet, follow these steps: 1. Go to the 'Tools' menu, select 'Options', and then go to the 'View' tab. In the 'View' tab, check or uncheck the 'Gridlines' option to show or hide them. This method is available in older versions of Excel. 2. Alternatively, if the 'Forms' toolbar is visible, click the 'Gridline' tool to toggle gridlines on or off. Note that this toolbar may not be available in newer versions of Excel. 3. Restarting Excel does not change the gridline setting. It only resets the application state. 4. The availability of these options depends on the Excel version and user interface settings.