+ Reply to Thread
Results 1 to 3 of 3

Is it possible to freeze more than one row in an excel ark?

  1. #1
    Registered User
    Join Date
    09-02-2016
    Location
    Malaga, Spain
    MS-Off Ver
    2016
    Posts
    4

    Is it possible to freeze more than one row in an excel ark?

    I want to freeze two rows in the top of the document, but i can only find the formula on freezing the one on top.

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2503 Build 16.0.18604.20000) 64-bit
    Posts
    3,992

    Re: Is it possible to freeze more than one row in an excel ark?

    For your kind information that Freeze can work only one row and column.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Registered User
    Join Date
    09-02-2013
    Location
    Oslo, Norway
    MS-Off Ver
    Excel 2013
    Posts
    44

    Re: Is it possible to freeze more than one row in an excel ark?

    Go to your "view tab" in excel. Mark cell A3 in your document and click on "Frezze panes", then click option one "freeze panes". This will freeze all the rows above your marked cell.
    If I helped you out please add to my reputation.

+ 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. Freeze Panes - Can I freeze a specific set of cells?
    By Rosco88 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-15-2013, 09:17 AM
  2. Excel Freeze Up
    By BonSid in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-05-2008, 03:58 PM
  3. Freeze Panes - Freeze Tabs
    By samprince in forum Excel General
    Replies: 1
    Last Post: 01-23-2007, 05:16 PM
  4. Replies: 3
    Last Post: 11-27-2006, 05:24 PM
  5. [SOLVED] Excel 2003 freeze panes won't freeze top row only
    By macbone2002 in forum Excel General
    Replies: 1
    Last Post: 05-31-2006, 11:10 AM
  6. Freeze Panes-When freeze panes is employed it leave a black line
    By peter.thompson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2006, 01:40 AM
  7. [SOLVED] Freeze Panes-can you freeze more than one column
    By rexmann in forum Excel General
    Replies: 4
    Last Post: 06-09-2005, 11:05 AM

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