Excel: Why does it not freeze/lock the rows/columns I select?

Hi

I am trying to freeze/fix the top four rows of my Excel sheet with the "freeze window" function. However, Excel does not only freeze the four rows I have selected but additionally freezes 12 more rows, no matter what I select. The same happens if I try to fix columns: It fixes a random number of columns, not the columns I have selected.

Does anyone have an idea what the Problem could be?

Thanks!
thuna72Asked:
Who is Participating?
 
Wilder1626Connect With a Mentor Commented:
If you want to freeze A to E, click in F column.

To lock columns, select the column to the right of the column or columns that you want to keep visible when you scroll.

To lock rows, select the row below the row or rows that you want to keep visible when you scroll.

And for a combination or column and row, select the right cell from the column and row that you want to keep visible.
0
 
Wilder1626Commented:
Hi

Do you have any merged cells?

Can you post a sample of your file?
0
 
Tej Pratap Shukla ~DexterServer AdministratorCommented:
Hi..

Just go through the steps and videos provided by Microsoft to freeze/lock the selected rows/columns.

https://support.office.com/en-us/article/Freeze-or-lock-rows-and-columns-08005001-fd23-4e2a-b370-77ab54d78e3f

Thanks
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
thuna72Author Commented:
good question with the merged cells. in the columns, yes, in the rows, no. i attach a sample (deleted the written Contents only)
example.xlsx
0
 
Wilder1626Commented:
click in F5 and freeze pane again. see if this work.
Copie-de-example.xlsx
0
 
thuna72Author Commented:
hi dexter

i did this already; still encountering the same Problem as described above.

thanks
0
 
thuna72Author Commented:
wilder: clicking in F5 worked! but why? and where do i click if i additionally want to freeze column A to E?
0
 
thuna72Author Commented:
ok, i see. but how can i lock BOTH columns A to E and rows 1 to 4?
0
 
thuna72Author Commented:
oh ok i got it...
0
 
thuna72Author Commented:
thanks all is well now!
0
 
Wilder1626Commented:
And for a combination or column and row, select the right cell from the column and row that you want to keep visible.
0
 
Wilder1626Commented:
i'm glad i was able to help
0
 
thuna72Author Commented:
thanks! perfect!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.