+ Reply to Thread
Results 1 to 3 of 3

Print three columns on paper from one column of data

  1. #1
    Forum Contributor
    Join Date
    03-08-2011
    Location
    Lubbock, TX, USA
    MS-Off Ver
    MS OFFICE 365 EXCEL, OUTLOOK, WORD, POWERPOINT
    Posts
    194

    Print three columns on paper from one column of data

    Hi everyone, I am thinking this is one of those puzzles that will be obvious to everyone ... except me.

    I download a flat file to excel and all the data is in Column A. One looooooooong column. The data is usually 15 or less characters. I convert the data into a barcode. But I don’t want to print 35 pages that only has one small column on the left side of the page. I’d like to make 3 to 5 columns on each printed page. I can do it in Word, but for some reason the barcodes don’t always scan like they do when printed in excel.

    Using Excel 2013 on a Win 7 Pro laptop. Old reliable I call it.

    Any ideas appreciated.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: Print three columns on paper from one column of data

    The easy way would be to use 3 columns with such formulas
    Please Login or Register  to view this content.
    Play with deducted values if your data starts from from different row. or if you use more columns (of course if you plan 5 columns change multiplication *3 to *5 etc.)

    Then select area with barcodes and during printing use "Print selected area only" option
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    Forum Contributor
    Join Date
    03-08-2011
    Location
    Lubbock, TX, USA
    MS-Off Ver
    MS OFFICE 365 EXCEL, OUTLOOK, WORD, POWERPOINT
    Posts
    194

    Re: Print three columns on paper from one column of data

    Quote Originally Posted by Kaper View Post
    The easy way would be to use 3 columns with such formulas
    Heh. I knew it. Easy fix and I never thought of it.
    When I looked at your sample (thanks) I was like, "Why is he skipping rows?" then realized yours went L-R and my brain focused up and down.
    This'll work. \
    Many thanks.

+ 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. Convert Single Column, Multi-Page List to Two Columns to Save Paper When Printing
    By thegnord in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-13-2015, 08:21 AM
  2. Not all data series print on pdf / paper
    By mcwra in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-11-2013, 03:38 PM
  3. Replies: 0
    Last Post: 06-14-2012, 11:59 AM
  4. Replies: 1
    Last Post: 01-08-2006, 07:35 PM
  5. [SOLVED] How can I print current row in same place on paper but not print surrounding
    By Andy Ford in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 09-02-2005, 01:05 AM
  6. Replies: 1
    Last Post: 08-25-2005, 07:05 PM
  7. [SOLVED] how do i print a column containing 150 names on 1 sheet of paper .
    By stormey in forum Excel General
    Replies: 3
    Last Post: 02-10-2005, 09:06 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