Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default How to create frozen header row?

I'm trying to make my first row in my spreadsheet always be visible,
but only once. I tried to follow some of the tips I found on the
internet to do this, but this seems to make that row appear twice,
once in the frozen section, and one in the first row of the section
below it.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,440
Default How to create frozen header row?

Select cell A3, from the menu choose WindowFreeze panes

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"david.karr" wrote in message ups.com...
| I'm trying to make my first row in my spreadsheet always be visible,
| but only once. I tried to follow some of the tips I found on the
| internet to do this, but this seems to make that row appear twice,
| once in the frozen section, and one in the first row of the section
| below it.
|


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default How to create frozen header row?

On May 8, 10:51 am, "Niek Otten" wrote:
Select cell A3, from the menu choose WindowFreeze panes

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"david.karr" wrote in oglegroups.com...

| I'm trying to make my first row in my spreadsheet always be visible,
| but only once. I tried to follow some of the tips I found on the
| internet to do this, but this seems to make that row appear twice,
| once in the frozen section, and one in the first row of the section
| below it.
|


Perfect. Thanks.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you create a header in an Excel Chart itself? Kev Excel Discussion (Misc queries) 1 March 12th 06 09:42 PM
How do I print frozen panes on each page as a header? cmaurer Excel Discussion (Misc queries) 1 March 9th 06 12:23 AM
How do I create and name header rows and columns? R9166 New Users to Excel 3 August 30th 05 02:48 AM
how do i create a header and a footer for the number of pages jff New Users to Excel 2 July 19th 05 03:14 AM
How do I create a new header in Excel once to be used on all sheet thechuckster51 Setting up and Configuration of Excel 0 June 1st 05 12:21 AM


All times are GMT +1. The time now is 06:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"