+ Reply to Thread
Results 1 to 2 of 2

Want to print only two print areas in one sheet(combined)

  1. #1
    Registered User
    Join Date
    06-29-2015
    Location
    Dubai
    MS-Off Ver
    2013
    Posts
    24

    Want to print only two print areas in one sheet(combined)

    Dear All
    From the attached excel sheet, i want to print only the selected (green marked) fields only, but can i print together to get near to near on a single sheet without hiding the columns?
    Please assist,

    rgds
    Jayaraj

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Want to print only two print areas in one sheet(combined)

    YOU could do it with a macro that temporarily hid the columns before printing and then unhid them.

    However are you sure that your data is set up correctly and is meaningful. You have circular references of course. Given that you presumably want to show a different monthly column every time I'd put my data in a normalised 2 dimensional table and use a Pivot Table to report it.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. Macro to print multiple print areas on one page.
    By morangeman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-23-2015, 12:13 PM
  2. Create buttons to print defined print areas
    By nwpassage in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2015, 11:17 PM
  3. VBA code to print several print areas in one worksheet
    By ABSTRAKTUS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-25-2010, 03:24 PM
  4. How to print multiple print areas on the same page.
    By Dalilah in forum Excel General
    Replies: 5
    Last Post: 08-27-2008, 09:05 AM
  5. [SOLVED] Multiple Print areas in same sheet?
    By Enzo in forum Excel General
    Replies: 4
    Last Post: 08-29-2005, 03:05 PM
  6. printing multiple print areas with a print dialog box
    By LHaro in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-17-2005, 05:05 PM
  7. [SOLVED] How can I set different print areas in the same Excel sheet?
    By Island Girl in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-02-2005, 04:06 PM

Tags for this Thread

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