Gridlines are fuzzy lines that work like cell dividers in MS Excel. They distinguish cells from each other and make the data in them easier to read.
By default, gridlines are active in Excel. But depending on the type of data a sheet contains, it may not have gridlines. As a result, it may be difficult for you to read through the rows. Here’s how the gridlines appear if you haven’t seen them yet.
Let us go over a few things we should consider if the gridlines are missing and we want to bring them back.
1. Grid line display
MS Excel provides an option to hide gridlines for users who don’t like them. In your case the hidden feature might have been activated by mistake.
If you want them to appear again, navigate to See tab and make sure the option gridlines checked under section Shows.
2. White Grid Line
By default, Excel assigns a gray shade to the gridlines. Make sure that the color is not changed to white. On a white background, certain white grid lines will hide themselves.
Follow these steps to change color back to default:-
Step 1: Enter File -> Preferences.
Step 2: Now click on High level and scroll to the reading section Display options for this worksheet.
Step 3: From the drop down list for Grid line color select Automatic select. This is where you can choose different colors if you want.
3. White border
Your gridlines can be properly attribute set, and they can also be highlighted for display. But, what if they are hidden by white cell borders. The best thing here is to remove the cell borders.
Step 1: Press Ctrl + A to select all cells. Right click and select cell format.
Step 2: Enter Boundary tab and make sure no borders are active.
4. Color Coating
Sometimes you can mark data blocks with different colors to distinguish them from the rest. When the colors are overlaid, the gridlines are hidden beneath them. If you don’t see any color, it’s likely that the selected overlay color is white.
Step 1: Press Ctrl + A to select all cells.
Step 2: Enter Home page tab and change the coloring option to No fill.
5. Conditional Formatting
It’s likely that some kind of conditional formatting was applied on the sheet to hide the gridlines.
So navigate to Home -> Styles -> Conditional Formatting -> Remove Rules.
Note: Deleting a rule will delete all other rules along with the one you’re trying to delete. Better to go to Manage rules and find out from the details if there is such a setting. If so, remove the specific format.
Reward: Screen Properties
None of the above sounds right to you? Try and play around with your monitor’s brightness and contrast. I know it sounds ridiculous but sometimes, this can be the reason behind those missing gridlines.
Conclusion
Next time you don’t see gridlines on your worksheet, you’ll know what to do. Also, keep in mind that these settings apply to one sheet (selected sheet) at a time.
Tip: You can apply settings to multiple sheets at once. To do that, hold down the Ctrl key and select multiple tabs. Then try any of the above.
Categories: How to
Source: thpttranhungdao.edu.vn/en/