View the upper left corner of the screen.Ĭlick freeze panes button to display the freeze panesĬlick unfreeze panes in the freeze panes gallary to unfreeze the frozen columns and rows. How to freeze and unfreeze rows Go to view tab then press freeze panes button.Ī list of freeze pane commands will appear. using Smart Lookup Select cellĭisplay the Review tab and then click Smart Lookup (Review tab | Insights group) to display the Insights task pane containing information about the text in the selected cell To Split a Window into Panes If necessary, display the View tabĬlick the Split button (View tab | Window group) to divide the window into four panes.

answering what-if questions Using Excel to scrutinize the impact of changing values in cells that are referenced by formulas in other cells goal seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for a value in another cell. On the Home tab, click Format, and then click Format Cells. Why freezing and unfreezing rows and columns _ columns and rows is a useful technique for viewing large worksheets that extend beyond the window. Rotate text and borders in column headings Select the cells that you want to format. You also can view different parts of the worksheet at the same time by using panes.

Changing the worksheet view magnify or shrink the worksheet on the screen.

Angle text in excel