I have always seen this little triangle in the corner of every Excel sheet.What is it?

What is it for? Does it have to do with alignment? I have searched Google and have no luck.

  • 2
    It simply indicates that square belongs to both column and row I suspect. Clicking on it on it may or may not select all the boxes.
    – Journeyman Geek
    Nov 10 '15 at 0:31
  • 1
    As far as I can tell, its just a "Select All Cells" button.
    – heavyd
    Nov 10 '15 at 0:50
  • 1
    Yes, it selects the entire sheet.
    – CharlieRB
    Nov 10 '15 at 0:51

I'm just going to throw the kb - select all cells on a worksheet official reference here as an answer.

It's also on this kb- Select cells ranges rows or columns on a worksheet -

enter image description here

  • Wow! That is a very descriptive answer. Thanks for teaching me. Nov 10 '15 at 22:46

That button selects all the cells of the spreadsheet. :)


It highlights all cells of your sheet. It can be used if you want to set every cell to a certain font style or something like that.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.