+ Reply to Thread
Results 1 to 4 of 4

Lock header Row

  1. #1
    Registered User
    Join Date
    12-02-2016
    Location
    chicago
    MS-Off Ver
    2013
    Posts
    67

    Lock header Row

    How do I keep the header at the top of each column while a scroll down?

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: header

    http://www.excel-easy.com/examples/freeze-panes.html

  3. #3
    Registered User
    Join Date
    12-21-2011
    Location
    Karachi, Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Lock header Row

    Yes Freeze-Panes

    in Excel 2010 shortkey is Alt W+F+F

  4. #4
    Registered User
    Join Date
    12-19-2016
    Location
    Rawalpindi, Pakistan
    MS-Off Ver
    MS Office 2016.
    Posts
    18

    Lightbulb Re: Lock header Row

    To freeze row:
    • Select the row below the row(s) you want to freeze.
    • Click the View tab on the Ribbon.
    • Select the Freeze Panes command, then 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.

    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.
    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.
    Hope it helps.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Lock or Preserve Header and Footer
    By mbr22m in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2015, 04:15 PM
  2. macro to lock cell by column header based on value in another cell by column header
    By Closet Guru in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-03-2015, 12:36 PM
  3. can i search on headersName and lock the entire column of a particaular Header
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-06-2015, 02:42 PM
  4. can i lock selected columns header name and there data
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-09-2014, 07:24 AM
  5. How to Lock Header Footer Excel 2007
    By Heavenkissing in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-12-2011, 09:56 AM
  6. How to lock header cells in the following code
    By gamaz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-29-2009, 05:59 PM
  7. Lock Header Rows from Editing
    By HotRod in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-11-2005, 12:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1