+ Reply to Thread
Results 1 to 5 of 5

Make 1 worksheet look like 2

  1. #1
    Registered User
    Join Date
    08-22-2020
    Location
    Houston, TX
    MS-Off Ver
    Office 2016
    Posts
    3

    Make 1 worksheet look like 2

    I am wanting to add a split vertically at Column I, basically splitting the worksheet into 2 halves. I want to be able to scroll up and down on the left half while the right half doesn't move and then move over to the right half and scroll up and down while the left half doesn't move.

    I have tried "Split" but it doesn't work how I would like.
    Attached Images Attached Images

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,469

    Re: Make 1 worksheet look like 2

    https://support.microsoft.com/en-us/...6-7ef1663599f3

    Scroll down the page a little.

    Looks like you'll need to paste your data on different sheets ... then follow the directions given at the above link.

  3. #3
    Registered User
    Join Date
    08-22-2020
    Location
    Houston, TX
    MS-Off Ver
    Office 2016
    Posts
    3

    Re: Make 1 worksheet look like 2

    Thanks so much for the link. Sorry, this is not what I am wanting. I am wanting something very similar to "Split" in vertical mode but when I use split vertically, I can only scroll horizontally and not vertically.

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,469

    Re: Make 1 worksheet look like 2

    .
    Ok.

    I did some searching and was not able to locate anything relating to your description. I doubt Excel is able to do that ??

    If you find something that works please post the link for others.

  5. #5
    Registered User
    Join Date
    08-22-2020
    Location
    Houston, TX
    MS-Off Ver
    Office 2016
    Posts
    3

    Re: Make 1 worksheet look like 2

    Thanks so much for you time. I am starting to think the same. I appreciate you looking into it. If I find something, I will post.

+ 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. Replies: 1
    Last Post: 04-02-2015, 11:46 AM
  2. Replies: 1
    Last Post: 08-28-2014, 09:09 AM
  3. [SOLVED] How to make the Worksheet search function look at the next worksheet if user click no
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-12-2014, 09:10 PM
  4. [SOLVED] How do I make values in a cell in one worksheet move to another worksheet
    By icevinson in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-11-2013, 06:46 PM
  5. How to make macro enabled worksheet functional in protected worksheet?
    By promo786 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2011, 03:24 PM
  6. How can I make copy worksheet from template worksheet?
    By blckwolf in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-02-2011, 02:23 AM
  7. Worksheet name ranges and how to make them reference cells in a worksheet
    By mammamia in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-10-2011, 06:36 AM

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