Thanks for this video! I used to be an intermediate user of Excel, but they've added so much new stuff and I've forgotten some of the basic stuff, so I feel more like a novice.
Hi Hami. Please visit my Blog post excelatwork.co.nz/2019/11/21/how-to-freeze-a-row-in-excel/ and make your way down to the topic heading 'How to freeze a row and a column at the same time'. You can follow the instruction on this page. As an extra tip though, if are wanting to put a lock against the first two columns only, you would select cell C1. Column C is the immediate column to the right of the columns you want frozen, and selecting row number 1 means you will not freeze any rows. I hope this helps. Take care. Sharyn
After I clicked "freeze top row". The top option stitches to "unfreeze". THAT'S why could find and figure this out. Thought it had one function, like the other two. Thank you so much!!
Liked and subscribed! I love that you laughed about the ice on the icon, you seem so real! Your accent is NZ I think? I am not used to it but your fun character pulls me past my challenge! I love accents just when something is technical sometimes I struggle! The more I hear them the better I understand though! Please don't lose your accent or take it as a knock! You are such a fun teacher and I will be watching more! So many Excel teachers are like robots, thank you for being a fun human!
THANK YOU so much Benjamin! I so appreciate your comment. I mostly get negative comments about my accent, so it is very uplifting to receive your kind comment 😊 Yes, I am from NZ. Well done! I'm so happy I was able to help you. Have a fantastic day! Sharyn
Thank you for this vid, I've done it before...like once, in the last 5 yrs or so. It was driving me nutz on how to do just that and I knew it was simple....Thx!!!! : )
Could you, please make a tutorial on creating an inventory management for a warehouse. Just a simple one for products coming in and going out without sales. How to add the number of products as row materials and process them, get them ready and dispatch them and keeping the record of stock. Thank you.
There's a freeze function that I'd love to see. If Excel can do this, then I've just not discovered how. That is, let's say that I freeze row 1 (had column titles on it). But as I scroll down the sheet (while row 1 stays put) when I get to another, specific row, (let's say row 50) that has other titles/headings for a new section/category, I wish there was a way for Excel to detect that THIS row has come to the top, auto UNFREEZE row 1 and auto FREEZE row 50 so that it now stays at the top. Then, as I scroll the other direction, once I get to row 51, row 50 UNFREEZES and row 1 pops back into the top position. Sort of like dynamic row freezing.
Hi there. I know right?! It would be so great if you could set dynamic options. Excel tables can give you some help when scrolling through rows. I'll pop steps for this into a #short and let you know once it has been created👍Take care!
Not within Freeze panes unfortunately. You could try the following steps to see if this works. 1. From the Data tab click 'New Window'. You will now have 2 windows displaying the same workbook. Now from the View tab click 'Arrange' > 'Vertical' > OK. You will now have the ability to scroll and view different parts of your worksheet in the separate windows. I hope this helps :-)
Hi there. If you are referring to the online version of Excel, then the answer is Yes, thankfully you an use Freeze Panes. You can find the option on the View tab 😊
my excel only shows unfreeze panes, freeze top row, freeze first column - I want to freeze the top 2 columns but I don't have the option of "freeze frames" to make this possible. I would appreciate the help. thanks
Hi Carlene. It looks like you may have Freeze Panes turned on already. Try selecting Unfreeze Panes and then your Freeze Panes options will be available so that you can reset and freeze the top rows. If it is the top 2 rows you want frozen, once you have selected 'Unfreeze panes' select cell A3 and then from the View tab select Freeze Panes, and then the top option from the list 'Freeze Panes'. I hope this works for you 😊
Hi Partho. Scroll down your sheet until only row 13 is showing (i.e. rows 1 to 12 are now out of sight). Then use Freeze first row. I hope this is what you are needing. Best regards, Sharyn
Hi there. You might like to check out Excel Tables. When you select your data and apply a Table over the data, as you scroll down the Table headings replace the letters in the columns, e.g. A, B C etc. Very handy! You might like to check this page out support.microsoft.com/en-us/office/create-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac664
I see how you froze the top rows and left columns but when you scroll up the columns you froze will go up thus losing any headers. If while the column is frozen when you scroll left the Top (frozen) cells go left thus being hidden from view! My question is how do you FREEZE both the Columns and ROWS where they wont move at all. IE if Column 1 and Row1 are both frozen I don't want either row or column to move!
My version of excel does not have the top row or bar showing the freeze pane icon. I wonder if the newer excel has a different way of locating freeze panes?? Hitting View doesn't bring me this. On anold version I was able to see the choices you show on this video. Any thoughts?
Hi there. Hmmmm, I'm not sure why I'm sorry. I have the latest build of Excel and it is definitely there. It's also available in the Excel Online version. You could try typing 'Freeze Panes' into the Search bar at the top of the screen. This will help you locate the feature.
How do you only freeze the 3rd row without freezing the ones on top? Why doesn't excel just have you highlight the rows/columns you want to freeze? This is such a weird way to design this feature - it makes no sense -_- classic microsoft....
Hi Jennifer. Yes, that would be an awesome feature and makes a lot of sense 😀. Are you familiar with Tables? You could possible apply a Table over your data and then when you scroll down the Table headings are displayed where the column letters are normally displayed at the top of each column. This could solve your problem 👍 I hope this helps 😊
Hi there. If you are trying to freeze everything above and to the left of D70, select cell E71 and then from the View tab select Freeze Panes > Freeze Panes.