+ Reply to Thread
Results 1 to 2 of 2

Limiting pages printed and Printing totals at the bottom of the pages

  1. #1
    Registered User
    Join Date
    12-04-2012
    Location
    Orange County, California
    MS-Off Ver
    Excel 2010
    Posts
    1

    Limiting pages printed and Printing totals at the bottom of the pages

    Hi all - I am creating an spreadsheet that needs to reflect loan information, including a loan amounts that are subtotaled by office. Then the dollar amount needs to total at the bottom. This information will fluctuate. Sometimes there may be only one loan for a branch vs. 5. Also, the number of branches will fluctuate. Sometimes there may be only 3 offices. Other times 25. If I have a 5 page spreadsheet with the formatting already completed, is there a way to only print the pages with the loan/dollar information completed? Also, is there a way to reflect the total dollar amount at the bottom of every printed page? Thanks!

  2. #2
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: Limiting pages printed and Printing totals at the bottom of the pages

    Hi

    You can use print selected only for the pages you want to print. For the rest can you post a sample worksheet without confidential information.


    To Attach a File:

    1. Click on Go Advanced
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.



    Chris
    Click my star if I helped Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1