How to Remove Gridlines in Excel


Home >> Excel Tutorials from Compute Expert >> Excel Tips and Trick >> How to Remove Gridlines in Excel



In this tutorial, we will learn completely about how to remove gridlines in excel.

Excel gridlines are the boundaries between cells that excel provides by default. With these gridlines, we can differentiate clearly between one cell and another and also know their row/column position. However, there maybe times when we might want to remove them so we can have a better worksheet interface.

Here, we will discuss 5 methods that you can implement to remove these excel gridlines. We will explain the detailed steps for each method so you can easily practice them. We will also give the implementation screenshot in excel for each step to make you understand them easier.

These five methods will give the same result, which is the removal of excel gridlines in your worksheet. Thus, it is up to you to choose which one you prefer to implement later.







How to Remove Gridlines in Excel 1: View/Page Layout Tab


  1. Click on the View or Page Layout tab in your excel file

    How to Remove Gridlines in Excel - Screenshot of the View/Page Layout Tab Method, Step 1

  2. Remove the checkmark in the Gridlines (View) or View Gridlines (Page Layout) checkbox by clicking it once. Later, if you want to show the gridlines again, just check the checkbox by clicking it again.

    How to Remove Gridlines in Excel - Screenshot of the View/Page Layout Tab Method, Step 2-1

    How to Remove Gridlines in Excel - Screenshot of the View/Page Layout Tab Method, Step 2-2

  3. Done!

    How to Remove Gridlines in Excel - Screenshot of the View/Page Layout Tab Method, Step 3




How to Remove Gridlines in Excel 2: Excel Options


  1. Click File in the top left of your excel file (For Mac, click the Excel text in the top left of your Mac screen)

    How to Remove Gridlines in Excel - Screenshot of the Excel Options Method, Step 1

  2. Click Options on the choices shown (For Mac, click Preferences…)

    How to Remove Gridlines in Excel - Screenshot of the Excel Options Method, Step 2

  3. Click Advanced on the dialog box shown (For Mac, click View)

    How to Remove Gridlines in Excel - Screenshot of the Excel Options Method, Step 3

  4. Find the Show Gridlines checkbox on the menu shown. Then, remove the checkmark by clicking it once

    How to Remove Gridlines in Excel - Screenshot of the Excel Options Method, Step 4

  5. Click OK

    How to Remove Gridlines in Excel - Screenshot of the Excel Options Method, Step 5

  6. Done!

    How to Remove Gridlines in Excel - Screenshot of the Excel Options Method, Step 6






How to Remove Gridlines in Excel 3: Changing the Background Color


  1. Highlight the cell range where you want to remove the cells’ gridlines from. If you want to remove all the gridlines in your worksheet, press Ctrl + A (Command + A for Mac) to highlight your whole worksheet

    How to Remove Gridlines in Excel - Screenshot of the Changing the Background Color Method, Step 1

  2. Click the Fill button dropdown in the Home tab

    How to Remove Gridlines in Excel - Screenshot of the Changing the Background Color Method, Step 2

  3. Pick the color you want for the background of the cell range you highlight (pick white if you want the color to be like the default color)

    How to Remove Gridlines in Excel - Screenshot of the Changing the Background Color Method, Step 3

  4. Done!

    How to Remove Gridlines in Excel - Screenshot of the Changing the Background Color Method, Step 4




How to Remove Gridlines in Excel 4: Merge Cells

Note: The use of this method will make the cells from where you remove your gridlines merge. Use this method if cell merging is something you are okay with for your cell range.

  1. Highlight the cell range from where you want to remove the gridlines

    How to Remove Gridlines in Excel - Screenshot of the Merge Cells Method, Step 1

  2. Click the Merge & Center button in the Home tab

    How to Remove Gridlines in Excel - Screenshot of the Merge Cells Method, Step 2

  3. Done!

    How to Remove Gridlines in Excel - Screenshot of the Merge Cells Method, Step 3




How to Remove Gridlines in Excel 5: The Shortcut Buttons

This shortcut only works if you use a Windows OS.

Press Alt then W then V then G or Alt then P then V then G. This shortcut is actually a shortcut to access the gridlines checkbox in your excel View/Page Layout tab.




Exercise

After you understand how to use the methods above, now is the time for you try them in your own excel. Open your excel file and try to remove its gridlines by using each method that you learn from above. Can you do it? Which method do you prefer to use?



Additional Note

If you want to print the gridlines instead, go to the Page Layout tab and check the Print Gridlines checkbox.

How to Remove Gridlines in Excel - Screenshot of the Print Gridlines Checkbox Location



Other tutorials you should learn:



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on




Hand-Picked CE Tutorials

Excel Calculation

How to Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division Excel Calculation

Average Excel Calculation



Excel Formula

VLOOKUP Excel Formula

Excel IF Function

SUM Formula in Excel

COUNTIF Formula in Excel

COUNT Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text Excel

Excel Worksheet Definition

Excel Range Definition

How to Add Columns in Excel



Excel Consultation

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2021 Compute Expert