Gridlines and colors: More ways to make your data readable.
The last thing your coworkers ask for is to make the data easier to scan. They suggest hiding the vertical gridlines in your datasheet and changing the color of alternate rows.
To hide the gridlines, go to the Home
tab, and in the Font
group click the arrow next to the Gridlines
button, and then click the style that you want to use. In this case, clicking Gridlines: Horizontal
shows only the horizontal lines and hides the vertical lines.
It's just as easy to set the background color for alternate rows. On the Home
tab, in the Font
group, click the arrow next to the Alternate Fill/Back Color
button and select a color.
You can see your results right away. Feel free to experiment with these settings. You can always undo them, and changing them won't hurt your data.
You'll get to try all this in the practice that's coming up.