To unfreeze these rows and columns simply click on freeze panes and then the unfreeze option.įreezing panes is only one of the features that Excel 2007 users can benefit from to make working with their projects easier. If you scroll down and to the right far enough the selected rows and columns will stay onscreen whilst the others disappear from view. This time two black lines will appear 'cordoning off' the rows and columns to be frozen from the rest. All you need to do is click on the cell immediately beneath the row and to the right of the column you want to freeze, then click the freeze panes option. The equivalent is true for the first column when you scroll to the right.īut what if you want only to freeze specific columns and rows? Well this is possible also. In the freeze top row option if you scroll down the data will only scroll underneath the top row, thus keeping it in view at all times. Simply clicking on either of these creates a black line immediately below the top row and to the right of the first column respectively. Within the view tab in the accessible and stylish new ribbon you will find a freeze panes option under which there are further freeze top row and freeze first column options.
In Microsoft Excel 2007 there is a handy way to freeze or lock the rows and columns in a spreadsheet thus eliminating the infuriating need to keep scrolling back and forth.
Likewise you will have scrolled down from the initial data that you entered meaning that you have to constantly scroll up and down to remind yourself of previous information. Once you have made use of the vast amount of cells and columns Excel 2007 has to offer the column and row headings that you created at the outset will be so long past that they will have disappeared from the screen. However there are a number of concerns that go hand in hand with such immense capability and chief among them is the loss of crucial information in vision. The incredible increased capacity of Microsoft Excel 2007's workbooks is a massive benefit for users as it enables them to create exhaustive worksheets without fear of inadequate memory.
0 kommentar(er)
