Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Freeze Vertical and Horizontal

How would I freeze panes (or something similar) so that when I scroll down, I
still see my header row, AND when I scroll right, I can see my other header
row. i.e. I have Dates across the top and Descriptions down the left. I
need to see those two things at all times. Any suggestions? Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Freeze Vertical and Horizontal

Select B2 and WindowFreeze Panes.

The freezing rule is.................everything left of and above the
selected cell will be frozen.


Gord Dibben MS Excel MVP

On Fri, 1 Aug 2008 15:36:07 -0700, rayybay
wrote:

How would I freeze panes (or something similar) so that when I scroll down, I
still see my header row, AND when I scroll right, I can see my other header
row. i.e. I have Dates across the top and Descriptions down the left. I
need to see those two things at all times. Any suggestions? Thanks!


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Freeze Vertical and Horizontal

Thank you SO much...sometimes the simplest things can drive me crazy!!! :-)

"Gord Dibben" wrote:

Select B2 and WindowFreeze Panes.

The freezing rule is.................everything left of and above the
selected cell will be frozen.


Gord Dibben MS Excel MVP

On Fri, 1 Aug 2008 15:36:07 -0700, rayybay
wrote:

How would I freeze panes (or something similar) so that when I scroll down, I
still see my header row, AND when I scroll right, I can see my other header
row. i.e. I have Dates across the top and Descriptions down the left. I
need to see those two things at all times. Any suggestions? Thanks!



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 913
Default Freeze Vertical and Horizontal

On Fri, 1 Aug 2008 15:36:07 -0700, rayybay
wrote:

How would I freeze panes (or something similar) so that when I scroll down, I
still see my header row, AND when I scroll right, I can see my other header
row. i.e. I have Dates across the top and Descriptions down the left. I
need to see those two things at all times. Any suggestions? Thanks!


Select the first cell that you want to scroll and the click on Freeze
panes in the View menu (or in the Window section of the View bar if
you use Excel 2007)

Hope this helps / Lars-Åke
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Freeze Vertical and Horizontal

select and click the cell in between the the header row you want to see when
you scroll down and the headers you want to see on your on your left.Select
window on the menu bar and split cells,then now you can freeze panes.

"rayybay" wrote:

How would I freeze panes (or something similar) so that when I scroll down, I
still see my header row, AND when I scroll right, I can see my other header
row. i.e. I have Dates across the top and Descriptions down the left. I
need to see those two things at all times. Any suggestions? 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
Vertical to Horizontal Terry Excel Discussion (Misc queries) 3 November 25th 07 04:11 AM
Arrays - Horizontal or Vertical fullers80 Excel Worksheet Functions 2 December 5th 05 04:25 PM
freeze horizontal and vertical panes at the same time in Excel Bridgette Excel Worksheet Functions 1 October 9th 05 02:16 AM
Vertical to horizontal swchee Excel Discussion (Misc queries) 5 June 20th 05 04:25 AM
how do i freeze a vertical column & horizontal row in excel? Lainey Excel Discussion (Misc queries) 1 February 3rd 05 04:06 PM


All times are GMT +1. The time now is 02:29 PM.

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

About Us

"It's about Microsoft Excel"