+ Reply to Thread
Results 1 to 4 of 4

How to print on one page

  1. #1
    Registered User
    Join Date
    12-20-2019
    Location
    Dark Side of The Moon/Poland
    MS-Off Ver
    2016
    Posts
    1

    How to print on one page

    Hi all!
    My question is : how can I print selected rows on one page? For example: I want to print row 1, 7 and 10, one under one, all on one page.

    Thanks for help and have a good time

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,972

    Re: How to print on one page

    Administrative Note:

    Welcome to the forum.

    Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

    With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

    Thank you for helping us to help you.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: How to print on one page

    off the top of my head, you could add a filter to your data.
    You could also add some VBA coding where it will hide all data except the rows you select.
    Pretty much both of my suggestions are based on hiding the data you don't want to print. Excel will only print UNHIDDEN ROWS/COLUMNS
    <----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.

  4. #4
    Valued Forum Contributor saravnepali's Avatar
    Join Date
    01-14-2019
    Location
    Sydney Australia
    MS-Off Ver
    2010
    Posts
    447

    Re: How to print on one page

    Is the number of rows you select always fixed OR varied ?
    If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.

    If your problem is solved, go to Thread Tools and select Mark This Thread Solved

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 05-28-2019, 02:13 PM
  2. Replies: 1
    Last Post: 06-20-2014, 02:42 PM
  3. Hide Column & Print page Macro printing blank page?!
    By Margate in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2013, 03:59 PM
  4. Replies: 1
    Last Post: 01-12-2012, 05:49 AM
  5. Replies: 4
    Last Post: 02-17-2006, 08:36 AM
  6. Replies: 1
    Last Post: 11-24-2005, 07:29 AM
  7. Replies: 0
    Last Post: 08-17-2005, 03:05 PM

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