🏫 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: ru-vid.com/group/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
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.
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)
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
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.
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!
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
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?
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?
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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uL8BwstqiqE.html
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.
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.
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.