Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 20th 08, 08:21 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,101
Default Make the heading follow when scrolling?

Is it possible to have a heading that always is at the top of the screen even
while scrolling down? If I have a long price list and several columns, and I
want to see far down the list but don't remember which column was what. Like
a row that always follow at the top of the screen?
--
thanks

  #2   Report Post  
Old October 20th 08, 08:32 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 4
Default Make the heading follow when scrolling?

Yes it is possible by using Freeze Panes option, for e.g if you have heading
in first row then by going cell A2 slecet freeze panes in window menu at the
top of excel sheet.

(Windows Freeze Pnes)

--
Sajjad


"Mike" wrote:

Is it possible to have a heading that always is at the top of the screen even
while scrolling down? If I have a long price list and several columns, and I
want to see far down the list but don't remember which column was what. Like
a row that always follow at the top of the screen?
--
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
Heading from first row to follow all pages Smilen2day Setting up and Configuration of Excel 1 June 3rd 08 08:57 PM
how do i make a chart follow the active cell mepetey Charts and Charting in Excel 2 October 20th 07 07:29 PM
How do I make a row or information, follow as you scroll down..? Dave_86 Excel Worksheet Functions 2 May 11th 05 03:33 PM
how do I make a heading row "float" to follow the data as I scrol. ROOD Excel Worksheet Functions 1 March 30th 05 11:11 PM
How do I make the fill color of a cell on one sheet follow the co. SteelerfanDan Excel Worksheet Functions 2 March 8th 05 10:29 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017