Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

how to get the header row on all scrolling screens


  • Please log in to reply

#1
khara

khara

    New Member

  • Member
  • Pip
  • 1 posts
:tazz: How do I get my row 1 (which contains the title of each column) to show up on my spread sheet as I enter data? By the time I get to row number 25, I can't see my column #1 titles. I've resorted to writing down the column titles on paper and referring to it when I can't see row 1 anymore. There must be a better way! Haaalp! Blessings!
  • 0

Advertisements


#2
headhunter600

headhunter600

    Member

  • Member
  • PipPip
  • 15 posts
Position your cursor on the line below what you want to keep. If you want the entire row, put the cursor in column A. If you want some columns to also be frozen, position the cursor one column to the right. Click Windows (Alt+W). Then click Freeze Panes (F). To undo the freeze, do Alt+W, F again. The position of the cursor doesn't matter when unfreezing.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP