How to make Grid lines reappear in Mircosoft Excel?

Question

So I coloured the boxes green but now I want the lines to come back so each box has a grid around it, as aposed to just a long green rectangle

Answer 1

There are a couple of ways to do as you wish. Both methods require that you select the cell, or cells, that you wish to 'border'.



You can then use the default Border tool, which will apply the border using the default color (usually black).

The Border tool is in the Font group in the Home tab. The icon is a small grid with a dark border across the bottom, right under the word Font. Click the drop down and select the border you wish to apply to the selected cells.



The more flexible method is to right click any of the selected cells and select 'Format cells'. Click the Border menu item when the Format window opens.



Select the Style of border you wish and the color to be used for the border. As the default color (black) can be overpowering at times, you can often use a softer color to add the grid lines but be more in the background.



Click the Outline and Inside options at the top and borders will be applied to all cells selected. Of course, there are a number of other bordering options you can select, also.

Answer 2

If you don't want to add borders & just see the original grid lines, click on Page Layout Tab. Then look across the ribbon options. Close to the end of those options is one with the header Gridlines with 2 check boxes under it. One says View & the other Print. Click the View box if you only want it to show on your screen. IF you want it to print with the grids, then also click the box for Print.

Answer 3

Go to File in the upper left corner and click that. You should get a drop down menu and it will have page set up on it click that and you will get an option box to have headers and grid lines and such put in you file. Just check the ones that you want.



Ron

Answer 4

Use your boarder control and choose all boarder. Home tab, font area, lower left corner.

Answer 5

Print: There is a setting you can use.

View on screen and print: Click the borders icon.