Solved

Freezing rows in Excel doesn't extend to entire selection

Posted on 2016-09-22
3
19 Views
Last Modified: 2016-09-22
Hi,

I have a sample spreadsheet where I tried to freeze rows 1-20.  Only rows 1-18 froze.  ?

--Ben
freeze_sample.xlsx
0
Comment
Question by:Ben Conner
3 Comments
 
LVL 31

Assisted Solution

by:Rob Henson
Rob Henson earned 250 total points
Comment Utility
When applying the Freeze Panes, the cursor has to be in the row below where the freeze needs to occur and in the column to the right if also freezing columns.

For your sample, the cursor needs to be in F21 to freeze rows 1 - 20 and columns A - E.

I suspect you had selected F19 when applying the Freeze.
0
 

Accepted Solution

by:
parts8 earned 250 total points
Comment Utility
Unfreeze the panes.
Select cell A21.
Now select freeze panes.
This will freeze everything above and to the left of that cell.
0
 

Author Comment

by:Ben Conner
Comment Utility
Ah.  Which also explains why the VBA code didn't work.  Thanks!

--Ben
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now