Previous in Forum: Image   Next in Forum: BCH Coding/Decoding
Close

Comments Format:






Change Mode
Close

Subscribe to Discussion:

CR4 allows you to "subscribe" to a discussion
so that you can be notified of new comments to
the discussion via email.

Close

Rating Vote:







Add Vote
10 comments
Rate Comments: Nested
KarinB
Active Contributor

Join Date: Sep 2010
Posts: 10

Excel Spreadsheet - Retain Headings

11/13/2010 11:59 PM

How do you retain the headings on your excel spreadsheet as you move your cursor down
Register to Reply
Pathfinder Tags: excel spreadsheet
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.
Tornado
Guru
Technical Fields - Technical Writing - New Member Engineering Fields - Piping Design Engineering - New Member

Join Date: May 2009
Location: Richland, WA, USA
Posts: 21017
Good Answers: 795
#1

Re: excel spreadsheet

11/14/2010 12:45 AM

Check the pull-down menus (or Help) for "Panes". It will tell you how to select as many rows as you wish to stay permanent.

__________________
 In vino veritas; in cervisia carmen; in aqua E. coli.
Register to Reply
KarinB
Active Contributor

Join Date: Sep 2010
Posts: 10
#3
In reply to #1

Re: excel spreadsheet

11/14/2010 1:12 AM

nope I can not find 'panes'
Register to Reply
lyn
Guru

Join Date: Oct 2008
Posts: 42355
Good Answers: 1693
#2

Re: excel spreadsheet

11/14/2010 12:52 AM

I'm looking in my "Excel for Dummies" book. Back to you tomorrow. What's a cursor?
Register to Reply
bob c
Guru
Hobbies - RC Aircraft - New Member Hobbies - Automotive Performance - New Member Hobbies - DIY Welding - New Member

Join Date: Jul 2007
Location: Fort Lauderdale Florida
Posts: 5708
Good Answers: 123
#5
In reply to #2

Re: excel spreadsheet

11/14/2010 2:38 AM

What's a cursor?

One that curses???????

__________________
 Bob
Register to Reply
KarinB
Active Contributor

Join Date: Sep 2010
Posts: 10
#7
In reply to #5

Re: excel spreadsheet

11/14/2010 5:33 AM

got it under view choose panes
Register to Reply
Tornado
Guru
Technical Fields - Technical Writing - New Member Engineering Fields - Piping Design Engineering - New Member

Join Date: May 2009
Location: Richland, WA, USA
Posts: 21017
Good Answers: 795
#4

Re: excel spreadsheet

11/14/2010 1:24 AM

I just did F1 for Help, typed "panes" in the search window, and got about a dozen items. The second one was "Freeze or lock rows and columns." Maybe our Excel versions are different.

__________________
 In vino veritas; in cervisia carmen; in aqua E. coli.
Register to Reply
KarinB
Active Contributor

Join Date: Sep 2010
Posts: 10
#6
In reply to #4

Re: excel spreadsheet

11/14/2010 5:04 AM

will try again
Register to Reply
SavvyExacta
Guru
United States - Member - Lifelong New Yorker Popular Science - Biology - Animal Science Technical Fields - Technical Writing - Technical Writer

Join Date: Mar 2008
Location: NY
Posts: 2313
Good Answers: 59
#8

Re: Excel Spreadsheet - Retain Headings

11/14/2010 8:06 AM

In Excel 2007:

Click on View from the top menu.

Click on Freeze Panes. Then click Freeze Top Row.
Register to Reply
KarinB
Active Contributor

Join Date: Sep 2010
Posts: 10
#9
In reply to #8

Re: Excel Spreadsheet - Retain Headings

11/14/2010 12:32 PM

thanx
Register to Reply
dkriley
Power-User

Join Date: Aug 2008
Location: Chicago, IL USA
Posts: 120
Good Answers: 2
#10

Re: Excel Spreadsheet - Retain Headings

11/15/2010 6:05 PM

Awesome, been wanting to do that myself but didn't know the term to use.

Thanks
Register to Reply
Register to Reply
Have a Different Question?
10 comments
Copy to Clipboard

Users who posted comments:

bob c (1); dkriley (1); KarinB (4); lyn (1); SavvyExacta (1); Tornado (2)

Previous in Forum: Image   Next in Forum: BCH Coding/Decoding
You might be interested in: Durometers, Hot Plates

Advertisement

Got Something to Say?
Ask a Question
Start a Discussion

Search this Forum
Software & Programming:
Go

CR4 Sections
Aerospace
BioMech & BioMed
Chemical & Material Science
Civil Engineering
Communications & Electronics
Education and Engineering Careers
Electrical Engineering
General Discussion
Instrumentation
Manufacturing
Mechanical Engineering
New Technologies & Research
Software & Programming
Sustainable Engineering
Transportation

Site Directories
Forum Directory
Blog Directory
User Group Directory
RSS Feeds

CR4 Rules of Conduct
CR4 FAQ
Site Glossary

Who's Online (56 right now)
Show Members
Advertisement