How to Freeze Panes in Excel
ฝัง
- เผยแพร่เมื่อ 22 ก.ค. 2024
- 🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
Learn how to freeze and unfreeze columns and rows in Microsoft Excel. Freeze a portion of the sheet to keep it visible while you scroll through the rest of the sheet. This is useful for checking out data in other parts of your worksheet without losing your headers or labels.
Watch how to freeze just the top row or the first column. Also, learn how to freeze any row and column.
Watch more Excel tutorial videos: • ❎ How to use Excel
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
As full disclosure, I work at Microsoft as a full-time employee. - วิทยาศาสตร์และเทคโนโลยี
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
Video start at 1.30 thanks me later
syukran ,vanikam,gracias, terima kasih ,xiexie
Vanikam tu hello kak 😂 *vanekkam
1:30, mf
thanks buddy
Lifesaver
Thank you for not turning this into a lecture great vid.
I can’t tell if you’re being facetious or not😂
I agree 😂
I can learn from you! You explained it perfectly and simple enough for me to grasp the info . Tysm!!
I had to watch your video several times to get the knack of the freeze pain feature. What you didn' t explain is that you cannot have a header (or title) above the columns you want to freeze. I must have done mine about 6x before I figured this out. Then it works like a charm. Still love your videos nonetheless. Great job.
I totally agree, just read your comment and realised I had the same issue, applied it again without my headers and it worked thanks Antoinette. Still love your videos Kevin.
My split is doing something completely different
View/Freeze panes or freeze top row selection at 1:30 Thanks! your vids are the best,
Thank you...you did an awesome job explaining. the best I've seen
Thanks that's been a big help. I knew I could do it, but had forgot how
Your tutorials are really helpful man
Thank you! The need for the Splits button wasn’t obvious to me. A few clicks after your video and I am setup properly. Thank you!
Hey Kevin I wanted to know if you could let me know if there was a way to hide something in excel using the function but if the other person tries to unhide it it won't really show up is there a way that way. Cause my friend knew it but i couldn't find a solution to it ?
Man, im coming from numbers on Mac, and Numbers is so user friendly it makes Excel feel very difficult to use. Now I know there are more functions and capabilities on excel which is why im crossing over. I like the challenge, and im thinking I need a Windows system as well as a Mac. So cool.
Thank you for the video. I didnt understand how the hell this was supposed to work.
Thanks, Kevin -
I had watched a number video on how to freeze both the row and the column together and yours was the first one to provide something understandable and workable. Sadly, I still have Exell 2003 but plan to upgrade soon.
Mike
Excellent work as usual. Thank you very much. This is such a very big help.
Kevin, this tutorial was the quick solution I was looking for. But I don't see that option on share point. I've noticed certain functions are not displayed, but they work after I set them on the application.
Appreciate you sharing this info. I was lost in space and too proud to ask anyone at work. Didn't want to be labeled a DA.
Thank you. You explained it clearly.
Thanks, how do I make a program in column A & B were I start with zero in row 1B and then add or subtract values in column A to give me an TOTAL in column B of gains and losses?
Thanks Kevin ---- straight to the point
Thank you!! I need a class 🤦🏽♀️ How do you do this so that the header (top row) will show up at the top of each printed page?
I really appreciated this.
Thank you, Kevin!
Hi Kevin, I used some of Microsoft templates, and when I scroll down, the column headers are visible without freezing panes. How can you do that? For example, refer to the Grocery List template. You can see on that template and a lot of other MS templates that the headers replace with the A, B,C ...etc. while the example you showed here, you can still see the A, B,C ....etc.
Thank you Kelvin. Your videos are so impressing... Kudos to you.
Thanks for the note Samson!
Doesn't work for more than one row or Column - would have been good to have a tutorial on this. SN
(PS seems to be the split feature which works to do this)
Very useful video!! Thank you Kevin
Thank you! This is very helpful!
Thank you Kevin. You helped me a lot.
Thanks! Very well explained.
Hi Kevin, are you able to explain how to freeze columns and rows, while keeping headers in your table? I tried splitting and it duplicates my table. I need to keep the headers because the table will be used by bith sighted user and visually impaired users using JAWS. Any help yiu could provide would be appreciated. Thanks!
Perfect! Just what I needed
Is there a way guys to split an excel file and showing my Z-AL columns on the top part of the screen, and at the bottom to see A-L columns. Whenever i try it both the colums on the top and bottom will move all together. these functions wont work for me.
Great explanations. When I go to "freeze pane" it's greyed out and won't let me click on it. Any idea why?
I have Excel 365, but the Freeze Panes is sometimes grayed out. It's in the Window group in the View heading along with "New Window", "Arrange All", "split", etc.
I can't select my freeze panel, it's a dull grey which won't allow me to select it ?
great video and thanks from Korea! And congrats on 3 + million subs Kevin!
Thank you somuch for very useful information you giving out. 👍
Hey Kevin, I tried freeze options but non works in my xls MS2010, could you pls guide me? TQVM
Another way that could be used in freezing panes apart from clicking the view tab?
Hi, Great vid. :) I’m wondering if you could do a tutorial on to share document hyperlink and send it to a ‘Teams’ chat?
And then able to open from ‘Teams’.
TIA
how to freeze random square like cells. i want to freeze right side where i need to put some data
Thank you, you just made my life much easier!
Thank you!! I needed to refresh my memory.
Is there a way of freezing a pane at the bottom of the screen. Let’s say for totals to be displayed at bottom whilst scrolling through a sheet.
Hi Kevin. Freezing. Rows and columns don’t work in 365. I can do it on my old system but not it new on why?
Thank you very much. This was very helpful.
Thanks for the information about the "thick line".
It´s possible to freeze multiple panels, as there are more than one Heading in the spreadsheet?
Thanks a lot! This was very helpful
Very helpful. Thank you!
Thanks man. I was struggling to find this.
This was helpful. Thank you.
Thanks. I have been looking for this for long time
Thanks. I was really stumped prior!
What is the freeze panes button is greyed out? What would make this happen? I have a header maybe this could be the reason?
Tyvm Kevin, great help
Hello, how can I highlight freeze panes? I see it but I can’t access that feature it is all gray.
Can you recommend a channel that can help me with data analysis
That's great. However, I would like to know how to do this in Page layout view. If I select Page layout after I have frozen my cells, it gives me a message that it will disable freeze panes. This is not good from Microsoft. Is there a way around this please?
Super helpful. Thank you.
How to show freeze pane in excel if it showed hide or dimmed in view pannel?
Thank you so muchhhhhhhhhhhhhhhhhhhhh! i have been going MADDDD trying to figure this out.
?? What if you want to Freeze the 2nd, 3rd, or any other row besides the first one
Thank you. Great explanation.
Thank you. Very good job.
Thanks for the Info!
im running excell 365 V 16.5 ... I need to hide certain cells (so they maintain a value) all I can see on youtube are earlier versions of excel (old) lay outs which don't relate to my version and navigation and the format is different, I have been high lighting the cells on the speed sheet , in review i click protect, and put a pass word in but its failing in protecting both cells in different rows... Im pulling my hair out !
Thank you for this valuable information ❤❤❤
Thanks.
It helps me a lot today.
Thank you so much!
Just subscribed!
IT WAS HELPFUL. Thanks
what if i want to freeze a 3rd row and column?
At Last ! A narrator who is professional enough that he does not say UH and GONNA ! Good job, Kevin !
You are the best!! thanks a lot
Thank you dear kelvin
Thank you man!
Thanks that was fast and easy
Thank you for the brevity ❤
Holy crap this is so helpful. Thanks mate
if i put =today() or =now() formula in a cell today, if i open the spreadsheet tomorrow i want yesterday's date to be displayed in that cell
very nice, thank you
Thanks so much!
it was helpful thanks!
I'm trying to freeze panes however, the Freeze pane option will not display when I select VIEW? I am in the normal mode. I've tried every thing with no luck. I've tried to get online help thru Microsoft what a pain --- not user friendly.
How do you use 0 as a number? If you have zip codes in a spreadsheet and one starts with 0, it goes away
Thank you that was simple.................................YAY
Nice thankyou for the help
big help thanks
thank you my dude
Thank you !!
Excellent thanks!
Hi Kevin, could you please do a video on how to have someone talking in the corner of the video while at the same time in the background the computer screen is visible. I really enjoy your videos and I find them very helpful!
Hi Hilda - thanks for the note! The following should show you what you're looking for: th-cam.com/video/uL8BwstqiqE/w-d-xo.html
Your videos are really helpful....zajakallah
thanks for the note Alux!
Thank you so much
Thank you!
ty I used to know how to do it in older version, easy peasy
Thank u... No wastage of time
thank you for helping be lie on my resume, one video at a time!!
just one column ?
how about multi column ??????
can you answer me pls
Thanks buddy❤
Thanks a ton