How can I remove this small "right angle" in the bottom right corner of a cell?

Issue

I noticed on the bottom right corner of a cell there is a small right angle.

My understanding is this small "right angle" means the end of a range for the column.

Enter image description here

I am pretty sure I am not using the correct Excel verbiage.

How can I remove the right angle indicator or enter more data after that last cell so the spreadsheet knows the data is continuing after the last cell in the column with the right angle icon?

Currently when I enter more data or continuing after the last cell with the right angle icon bottom right corner, doing a filter only affects the data on top of the last column or rows above the right angle icon.

Solution

The blue mark indicates the range is an Excel table. To get rid of the blue mark, right click on that range and then select Table and then Convert to Range

Enter image description here

Alternatively, click anywhere inside the table and then click Convert to Range in the Table Design tab.

Enter image description here

For Excel 2010, the ribbon looks like this:

Enter image description here

Answered By – Siddharth Rout

Answer Checked By – Pedro (AngularFixing Volunteer)

Leave a Reply

Your email address will not be published.