However, if you don’t have this tab, you need to activate it through these steps: You need to create and manage macros through the developer tab. Option 3: Visual Basic for Applications (VBA)Įxcel has an in-built programming code that allows you to disable gridlines automatically. ”Īfter that, all the gridlines will be hidden from view. Navigate to the Home Tab and click “ Fill Color.First, highlight the rows and columns of your spreadsheet.You can remove gridlines by changing the background color to match the worksheet area. Now, uncheck the gridlines box to hide all the lines in the entire workbook.Choose “ Select All” from the drop-down menu.Right-click any sheet tab at the bottom of the workbook.To apply these changes in all the sheets in the workbook: However, to print the gridlines, Check the “Print” option under the Gridlines on the “ Page Layout.Uncheck “ View” ribbon to remove or hide the gridlines.Alternatively, Navigate to the “ Page Layout ” Tab.Unchecking the gridlines hides them automatically. Locate the “ Gridlines” checkbox and uncheck.Navigate to the “ View” ribbon on the Excel Spreadsheet.The good news is that there is a default option to hide the gridlines in Excel. Let's get started on how to remove gridlines in Excel.

Finally, they enhance the readability of your tables or charts that lack borders.They give you a visual clue when aligning objects and images within the workbook.Gridlines help you to differentiate cell borders in your spreadsheet.This guide teaches you how to remove gridlines in Excel effortlessly.

However, you can remove gridlines in Excel 2016 to clean your spreadsheet and make it more presentable. What’s more, you need not draw cell borders to highlight your table. Therefore, grid lines are a common sight in spreadsheets. The central idea of Excel is to arrange data in rows and columns. Because of these gridlines, you can tell where information begins or ends. Gridlines are the faint grey vertical and horizontal lines visible in the Excel spreadsheet that differentiate cells. Do you desire a clean and accurate spreadsheet? Learn how to remove gridlines in Excel using this tutorial.

Remove drop down menu in excel 2016