Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Trying to keep totals at bottom of each page

Hi,

Is there a way to keep a row or two always visible at the bottom of a page.
I want to show running totals and percentages for columns and have new data
always insert above the last lines which show this information.

Thank you.

Curtis
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 79
Default Trying to keep totals at bottom of each page

Try selecting the row with the total. Then go to Window | Split to have two
sections in your sheet. You can adjust the split sections freely with the
split bar. Scrolling is independent for the two sections. So you can keep
the bottom section in place while you scroll the top section.

-Simon


"ffzeus" wrote:

Hi,

Is there a way to keep a row or two always visible at the bottom of a page.
I want to show running totals and percentages for columns and have new data
always insert above the last lines which show this information.

Thank you.

Curtis

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
Adding Totals on Seperate Page misselainei Excel Discussion (Misc queries) 3 April 26th 06 12:07 AM
page break problem Lisa Excel Discussion (Misc queries) 2 March 5th 06 02:22 PM
Problem with Page Numbering Aurora Excel Discussion (Misc queries) 0 November 21st 05 02:10 PM
only last cell on page to have bottom border (cell area outline) Wiggum Excel Worksheet Functions 1 April 29th 05 03:53 PM
how to print a row on the bottom of every page Punx Excel Discussion (Misc queries) 1 November 29th 04 04:20 PM


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