LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Freeze /Split frames

Doing nothing wrong Rick.

You cannot use both together.

OP could conceivably use two windows.

One skinny window with totals row showing at bottom of first window.

But I would move my totals row up to the top and freeze that along with the
Title rows per your first post.


Gord

On Mon, 9 Jun 2008 17:58:19 -0400, "Rick Rothstein \(MVP - VB\)"
wrote:

Am I doing something wrong? My XL2003 will only freeze or split, but not
both at the same time (the small gray box disappears when I elect to freeze
the rows).

Rick


"Reitanos" wrote in message
...
The title of your post has the answer to your question:
1) Use Window/Freeze Panes command after selecting cell A3 to get the
3 rows at the top to remain when scrolling
2) Use the Split feature (accessed by the small gray box above the
vertical scroll bar or Windows/Split) to split your total row into a
separate pane that will scroll independently


On Jun 9, 5:08 pm, Thor wrote:
I'm working on a Excel 2003 sheet. I want the three row column titles to
stay
at the top as you scroll down the page AND I want the total row, a couple
of
hundred rows below to always show when scrolling, This means that the
title
rows and total row is always seen when scrolling.
--
Thanks





 
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 I subtract time where hh:mm:ss:ff (frames = 30 frames/sec) KJ7 Excel Discussion (Misc queries) 14 December 3rd 16 10:03 AM
freeze frames button inactive woody Excel Worksheet Functions 3 May 2nd 08 10:17 PM
Split / Freeze Pane's Gaffnr Excel Worksheet Functions 3 April 24th 08 08:55 PM
Split vs. Freeze MsData New Users to Excel 2 February 17th 06 12:11 AM
split and freeze mvi Excel Discussion (Misc queries) 2 September 25th 05 08:14 AM


All times are GMT +1. The time now is 12:48 AM.

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"