Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Freeze a column or row Question

I want to freeze the titles of my columns so when I scroll down four pages I
still see the titles. I have read several posts on the subject. I can't
find the "Windows" button to get the freeze pane. Can someone explain this
to me. Thanks in advance.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 58
Default Freeze a column or row Question

On Apr 26, 8:14*am, tonyoptions
wrote:
I want to freeze the titles of my columns so when I scroll down four pages I
still see the titles. *I have read several posts on the subject. *I can't
find the "Windows" button to get the freeze pane. *Can someone explain this
to me. *Thanks in advance.


The "Windows" button is on your top toolbar:

File Edit View Insert Format Tools data Window Help

Click on the cell you want to freeze the column to the left and the
row above of.

Click Window from the toolbar and then click Freeze Panes from the
drop down

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Freeze a column or row Question

If you are running 2007 version see Ron de Bruin's site for where to find the
Commands.

http://www.rondebruin.nl/0307commands.htm


Gord Dibben MS Excel MVP

On Sat, 26 Apr 2008 06:14:01 -0700, tonyoptions
wrote:

I want to freeze the titles of my columns so when I scroll down four pages I
still see the titles. I have read several posts on the subject. I can't
find the "Windows" button to get the freeze pane. Can someone explain this
to me. Thanks in advance.


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
Freeze more than one column Kim Excel Discussion (Misc queries) 8 April 29th 23 11:42 AM
Freeze Panes Question NealMed Excel Discussion (Misc queries) 1 February 22nd 07 04:05 AM
Freeze column AG [email protected] Excel Discussion (Misc queries) 4 January 2nd 07 10:06 PM
freeze row and column 00KobeBrian Excel Discussion (Misc queries) 3 May 8th 06 06:58 AM
Advanced Window Split & Freeze Question Andrew Excel Worksheet Functions 1 November 8th 04 01:50 AM


All times are GMT +1. The time now is 09:51 PM.

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"