New type of comment found

[Dan Wilson]

Good day all. I'm using Excel 2007 on Vista Business 32 bit. I received a workbook from a business aquantance that has a button that I have never seen. There are three columns containing Name, CD and DVD. The Name column is obvious and the other two columns contain a number showing how many of each CD and DVD are required. At the top Row of the workbook containing the headers for the columns, there is an embedded button that looks very much like a comment button. When I place the cursor over the button, it expands to tell me the name of the header and in parenthesis, it states (Showing All). I have never seen this before. Is it a comment? How can I create one for new columns being added and/or remove the existing ones? When I try to reduce the column width, the button blocks the column header.
Thanks as always, Dan...

 

[Dan Wilson]

Hi all. Some additional data about the problem described above. I found that if I click on the button, it opens a sort menu giving me the option to sort and/or select the rows to sort.
Dan...

 

[tweedle]

Your aquantance has sent you a Table.

to replicate:
Select All
Copy
Create new sheet
Paste Special Values
menus:Insert / Table [Next to Pivot Table]
----------[CTRL+T also does it]

 

[Dan Wilson]

Good day tweedle. Thank you for responding. I have never used a table, guess it's time to learn.
Dan...