It seems that all freezing is defined in the WorksheetOptions XML node. Notice there are two horizontal scroll bars on the bottom of the screen.
To see how this fits into the rest of the XML, please see my entry on creating Excel documents using ColdFusion and XML. Whereas Split Panes is typically used when you have a lot of columns on the left or rows on the top that you want to remain visible and you can’t freeze them all in place and still have room to scroll through the columns to the right or rows below. Here is how I have been doing this - this demonstrates only a given XML node of the overall XML document. This can be most useful for header rows (frozen row) or ID columns (frozen column). One of the things that is highly useful is freezing a pane (number of rows / columns) in an Excel document such that the rest of the document scrolls and the frozen cells stay in place.
So, this is just trial and error until I can get that documentation up and running.
There is an XML Schema that you can download and install, but it doesn't seem to be working on my computer. You cannot, for instance, freeze the third column and nothing else around it.ĭownload the spreadsheet that accompanies this tutorial to see this feature in action in Excel.I have been tinkering around with creating Excel files using ColdFusion and XML and have been figuring out how different Excel features are defined. You can only freeze the rows starting from the top and the columns starting from the left. Go to the View tab and click Freeze Panes and, if there are any frozen panes in the worksheet, you will see the first choice in the list titled Unfreeze Panes, click that. Unfreeze/Unlock Columns and Rows in Excel Using this method, you can freeze the first two rows, the first two columns, the first two rows and the first 2 columns at the same time, basically whatever you want.
Now, I can scroll down and to the right and the first column and row will remain in place.
Select the cell that is just to the right and to the bottom of the rows and columns that you want to freeze.Use this method to lock multiple rows or columns at the same time or to lock rows and columns at the same time. Steps to Lock Multiple Rows/Columns in Excel at the Same Time However, the first column and the first row cannot both stay frozen together unless you use another method, explained below. The first column now stays the same when I scroll to the right or left. If I chose to freeze the first column, then it would look like this: Now, when I scroll, you can see that the first row never changes: I will select Freeze Top Row to lock the first row in place. From the drop down menu select if you want the header row, the first row of data, or the header column, the first column of data to be frozen. Bi vit hng dn cch s dng Freeze Panes trong Excel i vi bng nhiu dng v ct, bn cn c nh dng/ct tiu chng lun xut hin.Go to the View tab and click the Freeze Panes button.Notes Steps to Lock Rows/Columns in Excel This allows you to keep header rows and columns in place so you can tell what each column or row is for no matter where you are in the worksheet. Prevent specific rows or columns from moving when you scroll through a spreadsheet in Excel.