Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-13-2011, 08:38 AM
MSmand MSmand is offline Keeping the top row constant in Excel Windows 7 64bit Keeping the top row constant in Excel Office 2010 32bit
Novice
Keeping the top row constant in Excel
 
Join Date: Jul 2011
Posts: 2
MSmand is on a distinguished road
Default Keeping the top row constant in Excel

Hey all,


I need your help for my presentation of some datas I have been working with.
I have a large amount of data in my Excel, and at the top row there are names for each column. I want these names in the first row to be always at the top while I scrowl down the data, so people can at any time see what that specific data is referring to. There are 7 columns and 325 rows.
How I can I perform this in Excel 2010?

Thanks in advance.
Reply With Quote
  #2  
Old 07-13-2011, 11:15 AM
MSmand MSmand is offline Keeping the top row constant in Excel Windows 7 64bit Keeping the top row constant in Excel Office 2010 32bit
Novice
Keeping the top row constant in Excel
 
Join Date: Jul 2011
Posts: 2
MSmand is on a distinguished road
Default

I have found it
Reply With Quote
  #3  
Old 07-13-2011, 01:14 PM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Keeping the top row constant in Excel Windows 7 32bit Keeping the top row constant in Excel Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

For reference (for others), this can be done using the Freeze Panes feature.
__________________
Colin

RAD Excel Blog
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Keeping track of sent items Eugen_Denoes Outlook 8 10-22-2012 04:24 PM
I need help with keeping an inventory organized w/ WORD or Excel? CeltFan09 Excel 2 05-04-2011 05:46 PM
Keeping a group open syntr PowerPoint 0 02-14-2011 03:55 PM
Create A Constant Color Palatte auccello PowerPoint 2 07-31-2010 05:27 AM
Keeping scores in ppt, please please help piper7971 PowerPoint 0 07-24-2010 07:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:48 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft