Freeze the first line of a sheet

Hi !
In Windows Excel 2003 it was easy to freeze the first line of a sheet
so that when scrolling down it stays in line 1

How is this done in Windows Excel 2007

Some help please

Mike




0
5/31/2011 1:12:59 PM
excel 39879 articles. 2 followers. Follow

3 Replies
601 Views

Similar Articles

[PageSpeed] 18

Hi,

Am Tue, 31 May 2011 15:12:59 +0200 schrieb Mike van der Merwe:

> In Windows Excel 2003 it was easy to freeze the first line of a sheet
> so that when scrolling down it stays in line 1
> 
> How is this done in Windows Excel 2007

tab "View" => Freeze Panes


Regards
Claus Busch
-- 
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
0
claus_busch (107)
5/31/2011 1:16:54 PM
hi,

http://office.microsoft.com/en-us/excel-help/freeze-or-lock-rows-and-columns-HP001217048.aspx

-- 
isabelle

0
isabelle
5/31/2011 1:19:17 PM
Thanks

"Mike van der Merwe" <michaelvdm@telkomsa.net> wrote in message 
news:VqudnfldoIX0dHnQnZ2dnUVZ8kKdnZ2d@saix.net...
> Hi !
> In Windows Excel 2003 it was easy to freeze the first line of a sheet
> so that when scrolling down it stays in line 1
>
> How is this done in Windows Excel 2007
>
> Some help please
>
> Mike
>
>
>
> 



0
6/1/2011 3:44:00 PM
Reply:

Similar Artilces:

Slow load of first node, xmltextreader
Hi! I have a problem with reading a xmlfile from a url. I am confused by the long loading time of the first node. When the first node has been loaded, the rest of the nodes is parsed very fast. I am on a c# 2003 environment. The url returns an xml of appr 80 kB. It takes 1,5 seconds from first,start to first, stop. It takes appr. 0,5 seconds to generate the xml on the remote host. I'll be very happy for any assistance on this! /fredrik // Gets the xml from the Url using XmlTextReader Trace.Write("init reader","start"); XmlTextReader reader = new XmlTextReader(sea...

Three line charts on same chart
can I break the y axis to plot three series with total different value on the same line chart and showing their clear paths. Chris, These sites might help: http://www.peltiertech.com/Excel/Charts/BrokenYAxis.html http://andypope.info/charts/brokencolumn.htm These examples deal with columns but you can easily apply the same concepts to line charts. ---- Regards, John Mansfield http://www.pdbook.com "Chris" wrote: > can I break the y axis to plot three series with total different value on the > same line chart and showing their clear paths. Chris - Here's anoth...

Rules only work when I first start Outlook 2003
Hi all. I have a problem with my rules in Outlook 2003. I've upgraded from OL XP, and now my rules only seem to work when I first start up OL 2003 and it checks my mail. I'm using several POP accounts and I want the mails moved to specific folders depending on the mail account they come in on. The rules worked fine when I was running OL XP, but now they only run on the first mail check as soon as I open OL. Any subsequent mail checks, either automatic (every 5 mins) or manual just sends any new mail to the Inbox. I have read about an OL prob where the rules don't work on the fir...

sheets #2
Hello, I have a problem. I have sheet1,sheet2 and sheet3. In sheet1 i have 2 columns ( column1 and column2). Column1 Column2 text1 3 text2 5 1. problem In sheet2 I need to create drop down box so I can choose if I want text1 or text2. But how can I import to drop down box column1 and column2 data from sheet1? Example. If I choose on sheet2 from drop down box text1, it needs to write text1 and number 3 (text1 in one column and number 3 in other column) 2. problem In sheet 3 I have simple drop down box which reads Column1 from sheet1. But I need manually to ...

Missing Sheet tab #2
The tab where I select Sheet1, Sheet2, Sheet3 etc is missing how can I get it back??? I am using Excel 2007 Thanks Kamal Try Changing your display resoulution up a step? And then open the file. Kamal wrote: > The tab where I select Sheet1, Sheet2, Sheet3 etc is missing how can I get > it back??? > > I am using Excel 2007 > > Thanks > Kamal > > ...

2 Cells on 2 Sheets
Hello! I have a workbook with 2 sheets. Currently - Sheet 1, A1 is a dollar amount entered by the user Sheet 2, B1 references Sheet 1, A1 and is locked. Now - We would like the user to be able to change Sheet 2, B1 and have it update Sheet 1, A1 and vice versa. So that the user has the option of changing the dollar amount in 2 places, rather than on Sheet 1 only. Is this possible? Thanks in advance! Sarah You can do it by using an event macro that looks for changes. But this can easily break if the user doesn't allow macros to run--or even turns off events. I wouldn't use this....

How can I print only select sheets in my workbook?
My workbook has 12 sheets, but I want to print the second through ninth sheet exclusively, each time I hit print. (I do this once a week.) How do I do it? Excel 2007 Select sheet2 then hold SHIFT key and click on sheet9 File>Print>Active Sheet(s) Gord Dibben MS Excel MVP On Thu, 27 Mar 2008 19:14:00 -0700, MVictoreen <MVictoreen@discussions.microsoft.com> wrote: >My workbook has 12 sheets, but I want to print the second through ninth sheet >exclusively, each time I hit print. (I do this once a week.) How do I do it? >Excel 2007 Hi MVictoreen! As an optional m...

Cannot open Price Sheet
Hi All, We encounter an error message that says "This record is currently in use by another user" when trying to open a Price Sheet although no one is using such record. Kindly advise how to fix this problem. Thank you. Hi All, I already found the solution. I cleared the tables in Dynamics: ACTIVITY SY00800 SY00801 And in TempDb: DEX_LOCK DEX_SESSION -- Yani "Yani" wrote: > Hi All, > > We encounter an error message that says "This record is currently in use by > another user" when trying t...

Cannot restore Exchange 5.5 on-line backup
Background info: =========== We had an Exchange 5.5 server running on a Windows 2000 Server (SP4). That server was upgraded from NT 4.0. We got problems with SMTP mail and couldn't get it to work anymore even after reapplying Exchange SP4 and reinstalling the IMS connector. So we took an extra on-line backup of Exchange using NTBackup (to a HDD on another server). Everything seemed fine with the backup. No error messages. Then we reinstalled Exchange 5.5 on the same server, reapplied SP4 and made sure we used the same server name and site name as before. Then we tried to restore the back...

header and footer on every page except the first page?
how do i put header and footer on every page except the first page? One way: http://mcgimpsey.com/excel/subs/firstfooter.html In article <EBE1E559-C27E-47F9-BA16-0AA05EE9352E@microsoft.com>, marany <marany@discussions.microsoft.com> wrote: > how do i put header and footer on every page except the first page? ...

copy a pivot table to another sheet in a macro
Hi there, I created a macro that will copy copy the information from a created pivot table to another sheet. I seemed ok when I recorded the macro. But there's no pivot table on the new sheet when I run the macro. What should I do to correct the problem? Thanks, Aline -- Aline Record another macro when you try it again? If it fails again, you may want to describe what you did to copy the data (copy the cells to a new sheet or copy the sheet???). And share the code (that fails) that does the copy. Aline wrote: > > Hi there, > > I created a...

Method to group lines
Hi, I have this kind of sheet: 1?? AA1 2?? BB1 3?? CC1 3?? CC2 3?? CC3 3?? CC4 3?? CC5 2?? BB2 3?? CC6 3?? CC7 3?? CC8 1?? AA2 2?? BB3 3?? CC9 3?? CC10 3?? CC11 every rows it's a cell. The first number is the level of depth. How can I group group the rows by the level? I need to use the function "Group" of Excel, so I can hide/show rows. In this way I would see, before all the 1 then I expand them and I see only the 2 and so on... Thanks in advance for your help! -- Ciao BlackSun I usally add 3 auxilary column to the worksheet.. these could ...

Text lines in a cell
I want to be able to have more than 1 line of text in a cell. -- kboec kboec Wrote: > I want to be able to have more than 1 line of text in a cell. > > > -- > kboec Hi kboec Try this; Enter first line of text, then hold down ALT key and press Enter, no enter second line of tex -- Paul Sheppar ----------------------------------------------------------------------- Paul Sheppard's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2478 View this thread: http://www.excelforum.com/showthread.php?threadid=40069 Hi kboec, Type something in the ...

auto position of data labels in a line chart
Hi All Does anybody know of a way of automatically having data labels either positioned above or below depending on another cell value? Basically when I update data behind a series of charts, sometimes (depending on the values) its best to have the value labels above and sometimes below. I want the chart to know which is best automatically without me clicking on each series of data labels and manually changing them. I was thinking I could link this condition to a cell (in which I would have a formula telling it what to do). I think the only way that this could be done would be withi...

Index/Contents Sheet
I use Excel for 90% of the day. I use and create lots of sheets. Nothing is worse than when your Boss asks you a question and you say "I have that info in a sheet I created last month", but because it i over a month ago you either cannot remember the name or in which of th multitude of folders it lives in. and he is standing there looking mor and more frustrated as you do a search on *.xls at a rough date. I got really sick of this scenario and decided to do something about i and this might help you! Save a sheet called 'Commonly Used Files' or anything you want i Program...

Money 2004 freezes my PC
Money 2004 Premium freezes on me all the time, forcing me to reboot my PC. At first, it seemed to consistently happen when I opened a sub-menu off the main menu. But recently it also happened while backing up and immediately after that reboot, upon launching Money, on the dialog box where it says I didn't complete the sign- up for extra special features. No other app causes this problem. Any hints? try reinstalling it and IE. -- Glyn Simpson, Microsoft MVP - Money Check http://support.microsoft.com/default.aspx?scid=fh;EN-GB;mny for UK tips and fixes for MS Money. To send M...

Storport WMI receives NULL srb->DataPath for first request
I am adding WMI support to my storport driver and used the sample code in the DDK iSCSI driver as a foundation. My driver is simply trying to support the HBA API and does not have any unique data to provide. There is no MOF for my driver and I am simply using the GUID provided in Windows header files to describe the data that can be retrieved from my driver. The first time I executed my code I got a BSOD. After tracing through the code, I determined that the srb->DataPath was NULL and that pointer was being used inside scsiwmi.lib while processing the WMI request. I replaced ...

sheet tabs as page number and in a cell page of pages?
i have looked a little but can't find what i think is the right thing. i have a workbook with 3-4 pages in it. in the upper righthand corner is a page of pages cells set up. i want to have it grab the current tab(page) for one cell and the rest of the tabs(pages) for the other cell. i am not very good at the coding VB thing so exact instructions would be grately appreciated. i have tried a few of the suggestions but cannot get them to work. i am using excel 2002. TIA ...

Auto filter on blank lines
When I auto filter there is normally blank lines at the bottom but now when it's filtered it's greyed out and I can't add any new lines. ...

Synchronizing Off-Line Folders
We use Exchange 2000. I use off-line folders for everything. It appears that I should be able to synchronize some of those - like my calendar - so that others on the Exchange system can see it. Is this possible? I think I have calendar selected for off-line synchronization, but I'm not sure where I did that. Synchronizing your offline folders makes them available to you when you are not connected to Exchange. It has nothing to do with whether other users can see your calendar. If you want to have others be able to see your calendar, you need to set permissions. --� Milly St...

Copying multiple sheets to a new book and undertake specialised ed
...

Failed to hide column with message "cannot shift object off sheet"
Hi, I've a Excel 2000 worksheet that has 173 columns (A to FQ) with comments in a number of cells. I can't hide columns (say E:BW) with error message "cannot shift object off sheet". I searched into Microsoft Knowledgebase and found article 211769. I followed the resolution but stopped at step "3." where I can't find "Comment" of Format menu. Can anyone tell me how to resolve this problem? Thanks, Frankie What is in columns FR through IV? If nothing, columns FR:IV and Right-click on a selected columns header - select "Delete. -- HTH...

One cell from several sheets to one column
I have a spreadsheet with over 200 tabs/worksheets. I want to copy the same cell from every worksheet into one sheet into a single column. The worksheets have unique names. Is a macro the easiest way to move the data? If so, how can I set the macro up to go through each tab, so I don't have to go to each tab and run the macro separately? Thanks, Kel Examples of sheet names and what cell you want? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------------------------------------...

Line spacing
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Hey all - <br> I've recently learned that in the 2008 version of word -- the &quot;single space&quot; line spacing is not 1.0 (as it was in previous versions) but rather 1.15. I've found a bunch of websites telling me how to fix it for a PC -- but nothing for a Mac. <br><br>Basically what I'm looking for is a Mac version of this website: <br> <a href="http://office.microsoft.com/en-us/word/HA102310271033.aspx">http://office.microsoft.com/en-us/word/HA102310271033.aspx</...

Summarising large amt of data across sheets
Hi, Ok .. we deal with large amounts of data across multiple sheets. W have data in this form SHEET 1 a b c d e f 1 a1 b1 c1 d1 e1 f1 2 a2 b2 c2 d2 e2 f2 3 a3 b3 c3 d3 e3 f3 4 a4 b4 c4 d4 e4 f4 5 a5 b5 c5 d5 e5 f5 6 a6 b6 c6 d6 e6 f6 7 a7 b7 c7 d7 e7 f7 and SHEET 2 a b c d e f 1 aa1 bb1 cc1 dd1 ee1 ff1 2 aa2 bb2 cc2 dd2 ee2 ff2 3 aa3 bb3 cc3 dd3 ee3 ff3 4 aa4 bb4 cc4 dd4 ee4 ff4 5 aa5 bb5 cc5 dd5 ee5 ff5 6 aa6 bb6 cc6 dd6 ee6 ff6 7 aa7 bb7 cc7 dd7 ee7 ff7 8 aa8 bb8 cc8 dd8 ee8 ff8 Now, we use this format because we have many such rows and colums (i'v used only 8 rows and 6 columns fo...