Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default keep the title fixed while scrolling

I hope I can explain, when I use to work with Excel, I was able to format the
title so that when I scrolled I was able to see the title.... If I had 1000
lines and scrolled, my title "CALC1 CALC2 CALC3" would remain
visible at the top

example:

CALC1 CALC2 CALC3

data cell 1 data cell 2 data cell 3
data cell 1 data cell 2 data cell 3
data cell 1 data cell 2 data cell 3
data cell 1 data cell 2 data cell 3

TIA
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default keep the title fixed while scrolling

Got it thanks anyway.................

"SteveL" wrote:

I hope I can explain, when I use to work with Excel, I was able to format the
title so that when I scrolled I was able to see the title.... If I had 1000
lines and scrolled, my title "CALC1 CALC2 CALC3" would remain
visible at the top

example:

CALC1 CALC2 CALC3

data cell 1 data cell 2 data cell 3
data cell 1 data cell 2 data cell 3
data cell 1 data cell 2 data cell 3
data cell 1 data cell 2 data cell 3

TIA

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 to keep title of columns in view when scrolling RobG2007 Excel Discussion (Misc queries) 2 July 26th 07 01:50 PM
How to set the row for title to be fixed during scrolling? Eric Excel Worksheet Functions 5 April 19th 06 10:34 PM
How to set the row for title to be fixed during scrolling? Eric Excel Discussion (Misc queries) 4 April 19th 06 09:32 AM
How to leave the title row in MS Excel fixed? morisn Excel Worksheet Functions 3 February 19th 05 10:42 PM
keeping worksheet title visible during scrolling New at excel Excel Worksheet Functions 2 February 16th 05 02:30 AM


All times are GMT +1. The time now is 12:41 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"