+ Reply to Thread
Results 1 to 2 of 2

Repeating Column A when Row 1 is Merged...?

  1. #1
    Registered User
    Join Date
    03-28-2016
    Location
    Gold Coast, Australia
    MS-Off Ver
    Office 2013
    Posts
    4

    Repeating Column A when Row 1 is Merged...?

    I really hope this is a simple one. I have a wide but short sheet, where there are 31 columns following A, which has the person's name. All 31 rows cannot it on one page in landscape view so I have returned to my preferred portrait orientation. I have merged Row 1 from A - O to centre the title of the page.

    Because this sheet will be prodominently used on screen, but needs to be print friendly, I am reluctant to simply copy A to P, as this means I will have everyone's names repeated half way across the page. If it was a length issue, I would usually just repeat the title and header rows and then freeze panes for on screen use.

    I am encountering an issue, however, whereby I cannot repeat Column A due to the merged row 1. Is there a work around for this? Essentially it's trying to just repeat the whole first page over and over, because there is never an opportunity for the last 15 columns to appear.

    In summary, I would like a 2 page print out, where column A (participant names) is hard left on both pages, and 16 activity columns appear to the right on page 1 and 15 on page two. I would prefer to do this without the need to have column A repeated and visible in the middle of the rows when using workbook on screen.

    Thanks in advance

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,379

    Re: Repeating Column A when Row 1 is Merged...?

    With use of a second sheet

    Please Login or Register  to view this content.
    Kind regards
    Leo

+ 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] repeating macro column by column until it hits a blank
    By bardobhb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-26-2014, 07:05 PM
  2. Repeating the calculations every x column
    By plumberef in forum Excel General
    Replies: 4
    Last Post: 10-27-2012, 10:22 AM
  3. Repeating formulaes in each column
    By dadvikas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2011, 04:22 AM
  4. creating a repeating formula that doesn't show repeating values
    By cybershot in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-09-2010, 06:12 PM
  5. Replies: 8
    Last Post: 08-06-2009, 09:02 AM
  6. [SOLVED] Repeating Column Headings
    By TJ in forum Excel General
    Replies: 1
    Last Post: 08-01-2006, 01:30 PM
  7. Repeating Column headings
    By TJ in forum Excel General
    Replies: 0
    Last Post: 07-31-2006, 11:28 AM
  8. [SOLVED] Repeating columns cuts off merged cells
    By mjones in forum Excel General
    Replies: 3
    Last Post: 04-02-2006, 08:00 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