+ Reply to Thread
Results 1 to 5 of 5

Excluding columns from printing

  1. #1
    Registered User
    Join Date
    07-16-2018
    Location
    USA
    MS-Off Ver
    windows 10
    Posts
    5

    Excluding columns from printing

    I would like to exclude certain columns in between ranges to print.
    Example print columns A to N, exclude printing columns G,H,K,L.

    I need to always view all columns at the screen, only change my print setting.
    Is there a macro code to exclude columns or a way to alway print a custom view without being on that view.

  2. #2
    Registered User
    Join Date
    03-12-2015
    Location
    Netherlands
    MS-Off Ver
    2013
    Posts
    36

    Re: Excluding columns from printing

    Softegdes,

    Sounds like the easiest thing to do is write a simple macro that on button press will hide your columns, make the print, and then unhide them.

    Try using the macro recorder to get what you want.

    Please Login or Register  to view this content.
    This is what my recorder came up with.

    With kind regard,

    Rekragisao

  3. #3
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: Excluding columns from printing

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    07-16-2018
    Location
    USA
    MS-Off Ver
    windows 10
    Posts
    5

    Re: Excluding columns from printing

    I was not familiar with record, now I am. Thanks!

  5. #5
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Excluding columns from printing

    or

    Please Login or Register  to view this content.

+ 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. [SOLVED] Find max/min in an array excluding columns
    By rpcoates1956 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 11-04-2016, 02:01 PM
  2. Sum formula excluding HIdden columns
    By vjharry in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-29-2015, 08:03 AM
  3. Sum calculation for a row excluding some columns
    By yeahyeah93 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-20-2014, 12:49 AM
  4. Replies: 3
    Last Post: 07-16-2012, 03:24 AM
  5. Replies: 1
    Last Post: 04-09-2012, 02:58 PM
  6. Excel 2007 : Excluding a row from printing
    By rywal in forum Excel General
    Replies: 1
    Last Post: 04-02-2009, 10:14 AM
  7. [SOLVED] Excluding worksheets from printing
    By [email protected] in forum Excel General
    Replies: 2
    Last Post: 07-28-2005, 07:05 AM

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