How to Remove Gridlines in Excel - Compute Expert

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.

Disclaimer: This post may contain affiliate links from which we earn commission from qualifying purchases/actions at no additional cost for you. Learn more







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



Learn Excel Dashboard Course



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


Excel Calculation

Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division in Excel

Average in Excel



Excel Formula

VLOOKUP Function in Excel

IF Function in Excel

SUM Function in Excel

COUNTIFS Function in Excel

SUMIFS Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text in Excel

Excel Worksheet Definition

Excel Range Definition

Excel Shortcuts



Excel Products & Services Recommendation

Best Laptops for Excel

Best Tablets for Excel

Best Keyboards for Excel

Best Mouse for Excel

Best Monitors for Excel



Excel Consultation

About Us

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2022 Compute Expert