+ Reply to Thread
Results 1 to 3 of 3

Making 2 sheets on 1 sheet

  1. #1
    Registered User
    Join Date
    11-04-2011
    Location
    Alabama
    MS-Off Ver
    Excel Mac 2011
    Posts
    3

    Making 2 sheets on 1 sheet

    I need to make a spreadsheet where the top half of the sheet and the bottom half of the sheet are not in direct alignment with one another, almost like I'm putting 2 sheets on the same page. Is this possible?

  2. #2
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    Sunderland, England
    MS-Off Ver
    Excel 2007 (Home) / 2003 (Work)
    Posts
    740

    Re: Making 2 sheets on 1 sheet

    Depends what you mean, but it's probably only possible by merging cells. I'd try and avoid that route if at all possible.

    If you really need to do it, it might be worth attaching an example workbook trying to illustrate what you're attempting.

  3. #3
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Re: Making 2 sheets on 1 sheet

    I don't think you can have the bottom 1/2 directly below the top 1/2. Excel cannot show column "N" it the top 1/2 and Column "Z" right below it.

    You can play around with Split screen and maybe that might give you what you're looking for.
    Foxguy

    Remember to mark your questions [Solved] and rate the answer(s)
    Forum Rules are Here

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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