Results 1 to 3 of 3

Thread: Help: Selective Printing in Excel

  1. #1
    Registered+
    Join Date
    May 2004
    Location
    Hull, England
    Posts
    63
    Thanks
    5
    Thanked
    0 times in 0 posts
    • GarethG's system
      • Motherboard:
      • Gigabyte GA-EX58-UD5
      • CPU:
      • Intel Core i7 950 (3.07GHz)
      • Memory:
      • Corsair Dominator GT 6GB CM3X2G20008GT
      • Storage:
      • Seagate Barracuda 7200.8 NCQ 300GB SATA150 7200rpm 8MB
      • Graphics card(s):
      • Geforce 280GT
      • PSU:
      • BFG ES-Series 800Watt
      • Case:
      • Silverstone Temjin TJ05 J05ST Atx Full Tower
      • Operating System:
      • Windows Vista 64-Bit Home Premium
      • Monitor(s):
      • Samsung Pebble SM2232BW 22" TFT 3000:1 300cd/m2 2ms
      • Internet:
      • Karoo Up to 8mb (barely get 2mb if im lucky)

    Help: Selective Printing in Excel

    I have an excel file with multiple spreadsheets on different tabs. But my problem is I only want all but one of the spreadsheets (Tabs) printing.

    I have to make it so it automaticaly doesn't print the information on this tab without having to manualy select the pages I want to print.

    Also if possible I don't want any use of macros'.

    If you could help solve this problem it would be great help

  2. #2
    Butter king GheeTsar's Avatar
    Join Date
    Jan 2009
    Location
    The shire of berks
    Posts
    2,106
    Thanks
    153
    Thanked
    260 times in 163 posts
    • GheeTsar's system
      • Motherboard:
      • Gigabyte GA-Z68XP-UD3P
      • CPU:
      • Intel i5 2500k
      • Memory:
      • Corsair 8GB
      • Storage:
      • Samsung EVO 850 1 TB + 2 x 1TB Storage
      • Graphics card(s):
      • ASUS Radeon R9 280X
      • PSU:
      • Tagan TG600-U33 600W
      • Case:
      • Fractal Design Define R3
      • Operating System:
      • Windows 10
      • Monitor(s):
      • Acer 24" 120Hz GD245HQ
      • Internet:
      • Virgin 100mb

    Re: Help: Selective Printing in Excel

    I'm sure there are some far smarter ways of doing it, but could you set the print area in the tab you don't want to only be a single blank cell?

  3. #3
    unapologetic apologist
    Join Date
    Nov 2005
    Location
    UK
    Posts
    1,954
    Thanks
    363
    Thanked
    275 times in 146 posts

    Re: Help: Selective Printing in Excel

    easy enough. Make sure the Report Manager is installed (not a default during install) - can create reports comprising certain tabs /sheets / views

    info here: http://support.microsoft.com/kb/873209

    is not available in excel 2003/2007 but can still install if from link given - uses 2002 add-in
    One can never stop saying Thank You

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel Vlookup not working (sort of)
    By piggeh in forum Help! Quick Relief From Tech Headaches
    Replies: 9
    Last Post: 03-09-2010, 04:35 PM
  2. Excel help (Conditional Formatting)
    By Workaholic in forum Software
    Replies: 3
    Last Post: 04-02-2008, 01:31 AM
  3. .NET Reading Multiple Excel Files
    By Shadow_101 in forum Software
    Replies: 5
    Last Post: 23-11-2007, 03:22 PM
  4. Excel + Database + Automated
    By Kezzer in forum Software
    Replies: 4
    Last Post: 29-03-2007, 04:54 PM
  5. Replies: 6
    Last Post: 12-08-2005, 08:50 AM

Posting Permissions

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