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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 10:17 PM.

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

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