Blue mark in Excel cell

Hi everyone - I am new to this forum. I am not a strong Excel user but I have figured out some formulas today using "sumproduct".

In some of the cells, there's this little blue mark. I feel like a twit but I cannot figure out how to get rid of it or even what it is. I've attached a picture. Notice how there's a blue mark in the bottom right cell in the first table, but not in the bottom right cell in the table to the right.

Can anyone tell me what this little blue mark is and how to get rid of it?

TulaPicture 1.png

The blue mark indicates the table is an "EXCEL TABLE" and not just a 'table' of data. The difference is that an Excel Table has special properties. They are used when you need to add additional rows of data to the table. The Excel table will copy any formatting and formulae automatically to any new rows to the table. If you don't add new rows to your Excel table, you can just turn it back to a normal table by right clicking, select Table and then "convert to range".

Excel Tables are very powerful, and in my experience not many people know about them. You should definiately use them when you need to add rows of data to a table.

Mallycat, you are a genius! Thank you so much.

Tula

and 8 years later - your tip helps another!