Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Reply
 
Thread Tools Search this Thread Display Modes
Old Jun 30, 2012, 07:45 PM   #1
sun surfer
macrumors regular
 
Join Date: Jun 2010
In Numbers Spreadsheet, how to make titles/first row stick?

I'm doing a large spreadsheet with many columns and hundreds of rows that I need to input info for. Each column is titled in the first row but the problem is that I necessarily am jumping around to input the info to various rows and unless it's one of the first few rows, I can't tell which column is which because the first row of column titles is not showing. As a lot of rows are similar numbers, this is a problem, so every time I have to scroll to the top and be positive which column I'm putting the info in.

Is there any way to make the first row stick so that even when you scroll, it stays in view though the others don't? Or is there something similar I can do to make titles for each row always viewable? Thanks.
sun surfer is offline   0 Reply With Quote
Old Jun 30, 2012, 09:49 PM   #2
yukio
macrumors regular
 
Join Date: Feb 2008
i believe what you want is the icon directly under the Media icon at the top.

if you mouse over it - is called "Choose the number of header rows and when they display"

select the Repeat Header Rows on Each Page option from the pulldown.
yukio is offline   2 Reply With Quote
Old Jun 30, 2012, 10:05 PM   #3
sun surfer
Thread Starter
macrumors regular
 
Join Date: Jun 2010
That's perfect! THANK YOU so much yukio!

It was under that option, it's the "freeze rows" option under that icon. You're a lifesaver!
sun surfer is offline   0 Reply With Quote
Old Feb 13, 2013, 10:47 PM   #4
casimir83
macrumors newbie
 
Join Date: Feb 2013
Thanks as well!!
casimir83 is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Very strange - Some numbers not shown in album titles [SOLVED] Richard412 iPod touch 2 Sep 18, 2012 02:54 PM
Making an extras casting spreadsheet in Numbers ToddJ Mac Applications and Mac App Store 0 Sep 3, 2012 10:52 AM
Help - Apple Numbers Spreadsheet - Can you add a word document or something similar? sun surfer Mac Applications and Mac App Store 3 Jul 18, 2012 05:26 PM
NUMBERS - moving within spreadsheet malfromcessnock Mac Applications and Mac App Store 0 Jul 8, 2012 11:53 PM
How to access Numbers spreadsheet in iCloud from iPhone? richard13 iCloud and Apple Services 3 Jun 24, 2012 12:21 AM

Forum Jump

All times are GMT -5. The time now is 02:16 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC