+ Reply to Thread
Results 1 to 2 of 2

Freeze Pane Help

  1. #1
    Registered User
    Join Date
    07-26-2011
    Location
    california
    MS-Off Ver
    Excel 2007
    Posts
    43

    Freeze Pane Help

    How do I freeze several top rows (say top 3) and the first column of my spreadsheet at once? Is there a way to customize the freeze panes so I can keep my headers and first column data visible while I scroll thru my spreadsheet?

    Nevermind I just figured it out...duh!
    Last edited by mhitomi_7; 01-14-2016 at 12:49 PM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Freeze Pane Help

    Freeze panes freezes all rows above and left of the selected cell.

    So if your first column is col A, select B4 and Freeze panes

+ 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. [SOLVED] freeze pane in VBA
    By cmccabe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2014, 10:04 AM
  2. Freeze pane
    By BadgerMK in forum Excel General
    Replies: 0
    Last Post: 09-14-2006, 09:11 AM
  3. [SOLVED] Freeze pane
    By Nick London in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-04-2006, 07:10 AM
  4. Freeze pane
    By Marisa in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-11-2006, 07:55 AM
  5. [SOLVED] Freeze pane
    By CraigMc in forum Excel General
    Replies: 2
    Last Post: 09-05-2005, 10:05 AM
  6. [SOLVED] Freeze pane
    By kevin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-28-2005, 11:06 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