Column headings in Excel (enable/disable)
Have you ever opened a foreign worksheet or, for example, a template from Excel itself? Then you might have come to the point where there were no column or row labels. We faced the same problem the other day and first had to look up how to enable column headings in Excel. Actually a very simple feature, but one that is so rarely used that you quickly run out of ideas. Luckily we were able to find a suitable solution, so it won’t take as long for you as it did for us!
Only two clicks needed to enable column headings in Excel again:
Rarely has a solution involved so few clicks as this one. No matter where you are in your spreadsheet, it only takes two clicks to get it right. Therefore, all the more annoying if you spent a lot of time beforehand trying to find the right solution. Therefore, here comes the rescue!
- Click on the “View” tab
- In the “Show” group check the “Headings” box
That was fast, wasn’t it? We had to laugh a bit when we finally found the solution and how banal it actually is. Still, good to know so you don’t have to deal with such “problems” in the future. We hope that the tutorial helped you. If you need more help with the settings, check out our Microsoft Excel tutorials on Youtube!
Links with * are affiliate links. By purchasing via this link we receive a part of the purchase price as commission without any additional costs for you. This helps us to expand the offers available here for you! Thank you!