How To Remove Lines In Excel

To remove lines in Excel, you can use the “Borders” option in the “Home” tab and select “No Border” to remove all borders from a selected range of cells.

In today’s digital age, Microsoft Excel has become an essential tool for organizing and analyzing data. However, it’s not uncommon to encounter unwanted lines and gridlines that can clutter your Excel spreadsheets and make them less visually appealing. Thankfully, there are simple techniques and features available in Excel that can help you remove these lines and create a clean and professional-looking spreadsheet. In this blog post, we will guide you through the process of removing lines in Excel, whether they are horizontal, vertical, or gridlines. Say goodbye to the clutter and elevate your Excel skills to the next level.

How To Remove Lines In Excel: Step-by-Step


Step 1: Open Excel,

Begin by opening Microsoft Excel on your computer. You can easily access it by double-clicking on the Excel icon located either on your desktop or in the Start menu.

Next Step

Step 2: Select Workbook,

Navigate to the folder location, select the Excel Workbook, and open it in Excel by clicking “Open.”

Next Step

Step 3: Select the data,

Once the desired spreadsheet is open, select the cells, rows, or columns containing the lines you wish to remove by clicking and dragging the mouse over the data.

Next Step

Step 4: Open the “Borders” drop-down menu,

In the “Borders” drop-down menu, there will be various border options available. Select the desired border style by clicking on it, and the selected data will be bordered accordingly.

Next Step

Step 5: Select “No Border”,

In the “Borders” drop-down menu, you can choose from multiple options. Scroll and select “No Border” to remove lines from your selected cells, rows, or column, giving them a clean and borderless appearance.

Next Step

Step 6: Save Changes,

After removing unwanted lines, ensure to save your Excel file by pressing Ctrl+S or clicking ‘File’ followed by ‘Save’ to preserve the changes.


In conclusion, removing lines in Excel is a simple and effective way to enhance the readability and aesthetics of your spreadsheet. Whether you want to hide gridlines, remove specific lines, or adjust borders, Excel offers various options to customize the appearance of your data. By following the step-by-step instructions mentioned in this blog post, you can easily remove lines and achieve a clean and professional look for your Excel worksheets. So go ahead and experiment with different line removal techniques to make your data stand out and impress your colleagues or clients.

Table of Contents