Freezing Panes and View Options in Excel 2013
Learn basic ways for Freezing Panes and View options in Excel 2013
Freezing panes:- At whatever point you’re working with a considerable measure of information, it can be troublesome to compare information in your exercise manual. Luckily, Excel incorporates a few apparatuses that make it simpler to see content from various parts of your exercise manual in the meantime, for example, the capacity to freeze panes and split your worksheet.
To freeze rows:
You might need to see certain lines or sections all the time in your worksheet, especially header cells. By freezing lines or segments set up, you’ll have the capacity to look through your substance while proceeding to see the solidified cells.
- Select the row below the row(s) you need to freeze. In our illustration, we need to solidify rows 1 and 2, so we’ll choose row 3.Snap the View tab on the Ribbon.
Select the Freeze Panes command, at that point choose Freeze Panes from the drop-down menu.
- The rows will be frozen in place, as indicated by the gray line. You can scroll down the worksheet while continuing to view the frozen rows at the top. In our example, we’ve scrolled down to row 18.
To freeze columns:
- Select the column to the right of the column(s) you want to freeze. In our example, we want to freeze column A, so we’ll select column B.
- Click the View tab on the Ribbon.
- Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.
- The column will be frozen in place, as indicated by the gray line. You can scroll across the worksheet while continuing to view the frozen column on the left. In our example, we’ve scrolled across to column E.
To unfreeze rows or columns, click the Freeze Panes command, then select Unfreeze Panes from the drop-down menu.
If you only need to freeze the top row (row 1) or first column (column A) in the worksheet, you can simply select Freeze Top Row or Freeze First Column from the drop-down menu.
Other view options
On the off chance that your exercise manual contains a great deal of substance, it can once in a while be hard to think about various segments. Exceed expectations incorporates extra choices to make your exercise manuals less demanding to view and think about. For instance, you can pick to open a new window for your exercise manual or split a worksheet into isolate sheets.
To open another window for the present exercise manual:
Exceed expectations enables you to open multiple windows for a solitary exercise manual in the meantime. In our illustration, we’ll utilize this component to look at two different worksheets from a similar exercise manual.
Snap the View tab on the Ribbon, at that point select the New Window command.
- A new window for the workbook will appear.
- You can now compare different worksheets from the same workbook across windows. In our example, we’ll select the 2013 Sales Detailed View worksheet to compare the 2012 and 2013 sales.
If you have several windows open at the same time, you can use the Arrange All command to rearrange them quickly.
To read more about Office Products visit WWW.Office.com/setup