+ Reply to Thread
Results 1 to 2 of 2

keeping columns fixed as i scroll down

  1. 10-02-2017, 10:14 PM #1
    Noah101
    Noah101 is offline
    Forum Contributor
    Join Date
    08-29-2017
    Location
    Canada
    MS-Off Ver
    Window 2013
    Posts
    127

    keeping columns fixed as i scroll down

    HI,

    quick question I have 6 columns with titles in excel, when I scroll down the excel I just want those columns titles to follow me down and to display.

    Thank you,

    Noah
    Reply With QuoteRegister To Reply
  2. 10-02-2017, 10:38 PM #2
    leelnich
    leelnich is offline
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: keeping columns fixed as i scroll down

    Hi Noah- select the row just BELOW your "titles" (AKA "headers"), then click Freeze Panes on the View tab and select Freeze Panes. Your headers will now remain visible when you scroll up and down.
    Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
    Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Worksheet for Fixed Deposit record keeping
    By harish bajaj in forum Excel General
    Replies: 2
    Last Post: 10-17-2023, 08:36 AM
  2. [SOLVED] Select Cells Individually, Fixed Columns, Fixed Rows, Every Other Row
    By ZooTV92 in forum Excel General
    Replies: 13
    Last Post: 10-13-2015, 04:17 AM
  3. Sorting 5 Columns keeping the earlier column data fixed
    By gaurav225 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-04-2014, 07:06 AM
  4. keeping the cell width fixed while concatinating
    By abhimaan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2012, 03:35 PM
  5. Keeping formulas fixed while adding columns
    By yavan in forum Excel General
    Replies: 7
    Last Post: 08-11-2010, 11:45 AM
  6. Keeping fixed cell reference in table
    By peterz in forum Excel General
    Replies: 1
    Last Post: 10-20-2007, 09:24 AM
  7. keeping scroll (freeze) while converting to web
    By Tim in forum Excel General
    Replies: 0
    Last Post: 02-18-2005, 10: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1