WebPops 8,303 28 75 94 Add a comment 3 Answers Sorted by: 16 If this is Excel 2007, you are looking for "Freeze Pane" under the View tab. If you want to know how to use it, open Excel help and look for freeze. The first result should be a detailed explanation on how to use the feature. Share Improve this answer Follow edited Mar 31, 2011 at 15:53 Pops WebTo keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific row...

How can header cells in Excel be "pinned" or "frozen"?

WebPrint row or column titles on every page Click the sheet. On the Page Layout tab, in the Page Setup group, click Page Setup. Under Print Titles, click in Rows to repeat at top or Columns to repeat at left and select the column or row that contains the titles you want to repeat. Click OK. On the File menu, click Print. WebTo freeze cells in Excel, we must select those cells we want to freeze. Then, in the “View” tab in the windows section, click on “Freeze Panes” and again click on “Freeze Panes” from … electric bird feeder and squirrel zapper

How to Repeat Excel Spreadsheet Column Headings at Top of Page

WebFor Excel 97-2003, select Window, Freeze Panes. For Excel 2007/2010, click the View tab. From the Window group click the Freeze Panes button and select the Freeze Panes command. To unfreeze, retrace your steps and select the Unfreeze Panes command. If you want to have rows or columns to repeat on sequential pages while printing you can: WebFreeze multiple rows or columns. Select the row below the last row you want to freeze. On your iPad, tap View > Freeze Panes > Freeze Panes. WebFind the best business intelligence tool for your work HERE: http://technologyadvice.com/business-intelligence/smart … electric birch trees