Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 12-16-2013, 12:32 PM
The Accountant The Accountant is offline New to Excel - Filling out data Windows 7 64bit New to Excel - Filling out data Office 2010 64bit
Novice
New to Excel - Filling out data
 
Join Date: Dec 2013
Location: Norway
Posts: 2
The Accountant is on a distinguished road
Default

Quote:
Originally Posted by BobBridges View Post
Sure, it's called "freezing" the top (header) rows; and you can do it with the leftmost columns, too, if need be. Try this:

Move the selection to the topmost cell that you want to be part of the data, ie below the header rows. In your screen shot that would be A5.

If you're using Excel 2010, go to the ribbon and select View, Freeze Panes. You can select the desired option from there.
Thank you very much, worked like a charm Didn't know it was that easy!

-The Accountant
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
New to Excel - Filling out data [Excel 2007] Building Power Point Slides from data in an Excel Table bremen22 Excel Programming 1 08-07-2013 11:01 AM
filling in forms mepossem Word 3 05-25-2013 02:35 AM
New to Excel - Filling out data filling a text box mrmagoo Excel 1 07-05-2012 03:44 PM
New to Excel - Filling out data saving data in excel 2010 from excel 2003 johnkcalg Excel 1 02-06-2012 07:33 PM
Filling the consecutive cell by day. aligahk06 Excel 1 09-15-2010 08:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:09 AM.


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