+ Reply to Thread
Results 1 to 2 of 2

How to exclude rows from printing in the middle of the page

  1. #1
    Registered User
    Join Date
    06-17-2019
    Location
    USA
    MS-Off Ver
    Mac 16.75.2 (365)
    Posts
    65

    How to exclude rows from printing in the middle of the page

    Is there a way to skip printing rows in the middle of a page, but leave the rows visible on the screen, while keeping everything on the same page?

    For example, my print area is A1:F20, but I want to skip Rows 16 and 17. Put differently, I want to print A1:F16,A18:F20, but I want it all on one page, to appear unbroken.

    If I set my print area to A1:F16,A18:F20, it prints on 2 pages.
    I don't want to hide the rows because the sheet will be protected for all but a few unlocked cells, and don't want to have to unprotect the sheet.

    One other complication, I have 5 other pages that need to be printed as single pages.

    See attached sample
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-05-2019
    Location
    Afghanistan
    MS-Off Ver
    2010
    Posts
    5

    Re: How to exclude rows from printing in the middle of the page

    let me know if you found your answer.

    I have almost simillar queries.

+ 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. Exclude rows from printing
    By Maria_Michalonakou in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-04-2021, 10:53 AM
  2. Printing rows at the top of every page, EXCEPT...
    By robbyvegas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-03-2014, 04:14 PM
  3. Automatically Printing rows 1-5, then 6-10 etc. per page
    By shane1800 in forum Excel General
    Replies: 7
    Last Post: 11-17-2013, 06:15 PM
  4. How to copy format of previous printing-page and apply to the next printing-page?
    By Morrigan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-25-2013, 06:01 PM
  5. Replies: 0
    Last Post: 12-14-2011, 04:20 PM
  6. Printing - different rows at top for each page
    By kestrel in forum Excel General
    Replies: 1
    Last Post: 07-25-2006, 08:15 AM
  7. Printing rows on every page
    By SusieQ in forum Excel General
    Replies: 1
    Last Post: 02-01-2006, 01:10 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