As you scroll down, you will always be able to see the heading rows.Īdditional Details: To turn off this feature, go to the View tab and select Freeze Panes, Unfreeze Panes. A solid horizontal line will be drawn between rows 3 and 4. Then, click the place where you want to insert a line break. In the word document or worksheet, place you cursor (pointer) where you want the. When in Excel, pressing ‘Enter’ (in the cell or in the formula bar) like how you would in Microsoft Word would only move the cursor to the next cell: To start a new line, double-click the cell which contains the text. With the cell pointer in cell A4, select View, Freeze Panes, Freeze Panes. In Microsoft Word or Excel, open the document that you want to sign. To manipulate the size ofa workbook window, positionthe mouse pointer onthis sizing box, and then,when themouse pointer changes shape to a double headed.Cells above and left of the active cell is frozen.If you place the cell pointer on the heading for column A, you will not freeze any columns, only the rows. You're going to use the Freeze Panes command, which will freeze all visible rows above the cell pointer and all visible columns to the left of the cell pointer. Use the arrow at the bottom of the vertical scrollbar to move row 3 to the top of the window.In the spreadsheet shown in Fig 70 it would be really handy to have row 3 always visible while you scroll. In order to make the Freeze Panes command work, you must place the cell pointer in the correct location before using the command. For a more flexible strategy, use Freeze Panes as discussed next.Īlternate Strategy: You can use the Freeze Panes command on the View tab. It also precludes the use of some features like the View Manager. It automatically adds Filter dropdowns and formats the table. This strategy uses the table concept introduced in Excel 2007. When you scroll the headings out of view, the headings will replace column letters A, B, C. You want to see row 3 headings even if you scroll to row 800.
I want to scroll through the data and always see the headings. By default, the color of the pointer is red, but green and blue are also available. Problem: I have a spreadsheet that has headings at the top.