How to Remove Blue Lines in Excel (with Easy Steps)

Blue lines are the tracer arrows that show a relationship between cells.

There are two types of blue lines:

  1. Trace Precedents Arrow
  2. Trace Dependents Arrow

Here are 2 quick and simple steps to remove these blue lines in Excel.


Step 1 – Create a Dataset

  • To demonstrate the process, we will create a dataset containing Employee Name, Total Working Hour, and Rate Per Hour. Then we will calculate the Total Income for all the employees.

  • In cell D7 enter the following formula:
=C7*$C$4

How to Remove Blue Lines in Excel

  • Press ENTER
  • Drag the Fill Handle down to auto-fill the other cells in the column.
  • Our dataset is complete.

Remove Blue Lines in Excel

Read More: How to Remove Print Lines in Excel


Step 2 – Use the Formulas Tab

  • Sometimes trace precedents arrows or blue lines will appear over cells, displaying the connections between them.

How to Remove Blue Lines in Excel

  • Select Remove Arrows from the Formulas tab.

How to Remove Blue Lines in Excel

  • The blue lines connecting the cells are removed.

  • In some cases, trace-dependent arrows or blue lines may appear as in the image below.

How to Remove Blue Lines in Excel

  • Click Remove Arrows from the Formulas tab to remove them too.

How to Remove Blue Lines in Excel

  • The blue lines are removed.

Read More: How to Remove the Page Break Lines in Excel


How to Remove Page Break Blue Lines in Excel

We often see a blue dotted line, known as the page break line, which indicates the edge of a page for printing purposes.

How to Remove Blue Lines in Excel

This line can be removed easily as follows:

Steps:

  • Click File on the top menu.

How to Remove Blue Lines in Excel

  • Click More and select Options to open the Excel Options window.

  • Click Advanced in the left menu.
  • Remove the checkmark from Show Page Breaks.
  • Click OK.

How to Remove Blue Lines in Excel

  • The page break lines are removed.

Read More: [Solved]: Page Break in Excel Not Working Error


Download Practice Workbook


Related Article


<< Go Back to Page Setup | Print in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Wasim Akram
Wasim Akram

Wasim Akram holds a BSc degree in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Over the past 2 years, he has been actively contributing to the ExcelDemy project, where he has authored more than 150 articles. Now, he is working as an Excel VBA and Content Developer. He likes learning new things about Microsoft Office, especially Excel VBA, Power Query, Data Analysis, and Excel Statistics. He is also very interested in machine learning and... Read Full Bio

2 Comments
  1. I am interested in keeping random blue lines from appearing in the first place. They are vertical and horizontal randomly and partially surrounding some cells on my labels. They are not dotted lines. They are not a border, yet they do come around cells. Maybe two out of four sides are in this darker blue line. It is not the gridline or page break which everyone has addressed. I have many sheets with data about books in a library. I take the first column (A) and copy and paste onto the blank label sheet. As I enter the data making many labels these blue lines start popping up. I do notice the gridlines on my spreadsheets have darker blue lines also. But they don’t bother the information on the workbook. I do use Format painter a lot to make sure every cell is even with same format. This blue line issue has not been doing this in the beginning (August), Maybe mid September, 2023. Any help? Thank you, oh I do know how to get rid of them but I want to stop them from coming back. (highlight, no border)

    • Dear Betty Domowski,
      Thank you for sharing your problem. As you already know how to get rid of these lines but to stop them from coming back there is no other alternative except using the Remove Arrows option from the Formulas tab. Please check the image below.

      Remove blue lines

      Hope you found your solution you are looking for.

      Regards
      Wasim Akram
      Exceldemy

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo