![]() Depending on what they select, certain columns will appear and hide. There is a table below where they will enter their data. The top part of the sheet would be for the customer to select for what services they want and a few details. BUT, again, if I go ABOVE row 100 I need it "unfrozen". So that I can go below row 100 but row 100 would stay visible at the top of my screen. But I want to "freeze" it in a way that while I am above that row everything is normal, I can play around in row 1-99 as if NOTHING was frozen, until I scroll down to row 100, and until row 100 is at the top of my sheet. Let's say I want to freeze row 100, so initially it does not even show on your sheet. Is it possible to freeze just one row in the middle of a sheet? But what if we want to freeze more than just one column, or one row? In this case, we have to use option number one. Freeze First Column– Freezez only the first column in our Excel file.Freeze Top Row– Freezes only the top row of our Excel file.Visible while the rest of the worksheet scrolls (based on current selection). The Dropdown menu of Freeze Panes has three options: It is located in the ribbon, on the View tab. This option is very easy to find in Excel. Select any cell in this sheet and press Ctrl and T to create tables.Īlthough this method does not freeze the top row, you can still see the content of the top row while you browse the table. Go to View in the toolbar and click on the arrow behind Freeze Panes. But what if you want to freeze the first and last rows at the same time? Freezing the header row is actually very simple, and people who often use Excel can do it. When our Excel table is very long, we usually freeze the header row for browsing convenience. so I was wondering is it possible to do that? My spreadsheet is to complicated to move up 1 row without breaking it all, and I feel that it would be far more easy to read if I had the title row (the second one) frozen. I was just wondering, I'm a fair way through my spreadsheet, and I made the second row the row with all the titles etc. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |