Keeping the Column Headers Visible at All Times

June 01, 2017


column   column header   Excel Shortcuts for Mac   Excel Tips   excelskin   freeze pane   keep column headers   Mac Excel Shortcuts   Mastering Excel   Microsoft Excel   Microsoft Excel for Mac  

We’re a team of problem solvers, world travelers, idea guys, and doers, working to make using Excel on a Mac a better experience.

That’s enough about us -- whether you are new to Excel for Mac or an experienced user, you probably want to spend less time manipulating data and more time thinking. The Excel Skin will help you do that. If you are a PC user hesitant about switching to Mac because you don’t want to give up your customized menus and shortcuts, well, the Excel Skin just might be the myth-buster you need. Excel for Mac is just as capable as it is for the PC. And with the Excel Skin, you’ll relearn your old shortcuts in no time.

The Excel Skin makes it easy to be as proficient and efficient in Excel for Mac as on any other platform. Powerful shortcuts are presented intuitively on an elegant silicone keyboard skin. Shortcut and modifier keys are printed by color and heat fused onto our high quality silicone to ensure durability.

The Excel Skin a small product that will make a big difference in your life.


Anytime you have column headers on your spreadsheet it is a good idea to make them visible at all times.  This helps you clearly see what the column is representing without having to memorize the headers.   There are no reasons to not use this trick, so here we go!  

Select the row immediately under the row you want to freeze at the top.  For example if you have row 1 filled in with the headers, select row 2. 

Now click on the Window menu bar at the top of your screen:

And select the Freeze Panes option 

Excel will place a bold line under the frozen column headers.  These headers now go everywhere with you until you go back to the Window menu and click on Unfreeze Panes.  


Notice Row 1 and Row 2 in the screenshot.

Now I will scroll down to Row 777 and we will find Row 1 right above it.

And there you have it! Now your column headers can follow you wherever you may travel on your spreadsheet.  


For any questions or comments feel free to email me directly at

Leave a comment

Comments will be approved before showing up.