1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Sticky Excel Row

Discussion in 'General Business' started by jaguar34, Jul 17, 2016.

0
  1. #1
    How to make Excel Row on the top of sheet sticky, such that when I scroll down the rows, top row remains visible. Using Microsoft Excel 2010
     
    jaguar34, Jul 17, 2016 IP
  2. jrbiz

    jrbiz Acclaimed Member

    Messages:
    6,035
    Likes Received:
    2,612
    Best Answers:
    2
    Trophy Points:
    570
    #2
    This question should probably be a different section; however, I am using Excel 2013 and I am pretty sure that the 2010 version will be the same. Highlight the rows or columns that you would like to freeze (that is what it is called.) Then, on the top menu bar, go to:

    View-->Freeze Panes----> and select the option that you want.
     
    jrbiz, Jul 17, 2016 IP