How To Freeze Panes in Excel

Dear Computer Lady,

At the beginning of the year, I created a spreadsheet for weight lifting.

I have a column for each exercise, and fill out a row for each day that I work out. The name of each exercise is at the top of each column.

As I have added more rows, I have to scroll back up to the top to see the headings for each column. I seem to remember that there was a way to make the top row in my spreadsheet “stick”, can you tell me how?

Thanks, Jane

Dear Jane,

I’m so glad you are working on getting stronger!

What you want to do in Excel is use the “Freeze Panes” feature. Here is how to do that.

1. Open your Excel worksheet.

2. Click the row number (on the very left edge) just below the row you want to freeze.

3. Click on the “View” tab in the ribbon, then click on the “Freeze Panes” icon.

4. Click on “Freeze Panes” in the menu.

Now, when you scroll down in your worksheet, the name of your exercises will stay visible.

Elizabeth

 

It’s Your Turn: What do you think?
…. Share your experience in the comments box below.

Join The Family
become a patron today
www.patreon.com/computerlady

Elizabeth Boston is a Web designer, Social Media Consultant and managing editor of, “Ask The Computer Lady”.
Connect with

 

Previous Post

Free Excel Replacements

Next Post

The Secret To Converting Docx To PDF