Solved

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

Posted on 2015-01-20
13
95 Views
Last Modified: 2015-01-20
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!
0
Comment
Question by:thuna72
  • 7
  • 5
13 Comments
 
LVL 11

Expert Comment

by:Wilder1626
Comment Utility
Hi

Do you have any merged cells?

Can you post a sample of your file?
0
 
LVL 11

Expert Comment

by:Tej Pratap Shukla ~Dexter
Comment Utility
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
 

Author Comment

by:thuna72
Comment Utility
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
 
LVL 11

Expert Comment

by:Wilder1626
Comment Utility
click in F5 and freeze pane again. see if this work.
Copie-de-example.xlsx
0
 

Author Comment

by:thuna72
Comment Utility
hi dexter

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

thanks
0
 

Author Comment

by:thuna72
Comment Utility
wilder: clicking in F5 worked! but why? and where do i click if i additionally want to freeze column A to E?
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 11

Accepted Solution

by:
Wilder1626 earned 500 total points
Comment Utility
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
 

Author Comment

by:thuna72
Comment Utility
ok, i see. but how can i lock BOTH columns A to E and rows 1 to 4?
0
 

Author Comment

by:thuna72
Comment Utility
oh ok i got it...
0
 

Author Comment

by:thuna72
Comment Utility
thanks all is well now!
0
 
LVL 11

Expert Comment

by:Wilder1626
Comment Utility
And for a combination or column and row, select the right cell from the column and row that you want to keep visible.
0
 
LVL 11

Expert Comment

by:Wilder1626
Comment Utility
i'm glad i was able to help
0
 

Author Comment

by:thuna72
Comment Utility
thanks! perfect!
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Filter and delete 6 14
Excel filter by strike though 8 21
Copy the formula in excel 8 26
Gantt chart 2 8
A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

763 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

11 Experts available now in Live!

Get 1:1 Help Now