+ Reply to Thread
Results 1 to 4 of 4

Lock section of sheet without split?

Hybrid View

Margate Lock section of sheet without... 07-27-2015, 06:09 AM
protonLeah Re: Lock section of sheet... 07-27-2015, 06:19 PM
newdoverman Re: Lock section of sheet... 07-27-2015, 08:13 PM
Margate Re: Lock section of sheet... 07-28-2015, 09:20 AM
  1. #1
    Forum Contributor
    Join Date
    01-18-2013
    Location
    England
    MS-Off Ver
    2016 (Mac)
    Posts
    149

    Wink Lock section of sheet without split?

    Hello everyone,
    I want to put a section to the right side of my spreadsheet that is independent of the data on the left side of the sheet when scrolled. This would leave the data on the right side and also the header (first three rows) frozen when the page is scrolled vertically.

    Is there a way that I can scroll a section on the left side of the sheet and leave the header and data on the right side of the sheet frozen? It seems that freeze does not work on multiple selections. It works fine for freezing a header and a column by placing the cursor in one position but I want to be able to change this position to different locations on the sheet. So in one part I want to freeze horizontally and then move the cursor to another part where I want to add another freeze vertically. I cannot seem to be able to do this.

    If I split the spreadsheet it just puts the same data both sides and I also cannot seem to freeze and split at the same time. Perhaps there is a way of adding scroll bars to the middle of sheet so that I can just scroll different areas of the page whilst leaving other areas in the same place?

    I have added an attachment example of what I am trying to achieve in case my explanation is not very clear.

    Thank you for any help,

    Margate
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,936

    Re: Lock section of sheet without split?

    You must add a new window and arrange Vertical
    Ben Van Johnson

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Lock section of sheet without split?

    Maybe this "visual" might help. I added the left column to be frozen so the top rows and left column are frozen while the right panel is free floating. The left and right panels can be swapped by dragging. You can even have a separate file in a window if you need that.
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  4. #4
    Forum Contributor
    Join Date
    01-18-2013
    Location
    England
    MS-Off Ver
    2016 (Mac)
    Posts
    149

    Re: Lock section of sheet without split?

    Thank you very much for taking the time to help me here. I think that this is the only way that I can do what I want to do regarding freezing panes etc.

    Regards,

    Margate

+ 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] Split/Divide/Section a set of rows
    By Aldrnari in forum Excel General
    Replies: 2
    Last Post: 03-25-2015, 08:54 AM
  2. Hide a section based on the click of a box in the beginning of the section
    By schmidt1962 in forum Word Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2014, 04:51 PM
  3. Replies: 1
    Last Post: 06-16-2013, 07:36 AM
  4. split of string with multiple section of various size spaces
    By katto01 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-29-2013, 04:50 PM
  5. Deleting Row Section without Disrupting Formula Range Outside of Deleted Section
    By JeffNYG23 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2013, 09:10 AM
  6. Moving section headings from below section to above section..
    By Fayebaline in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-24-2011, 06:58 AM
  7. How do I lock a section of cells?
    By paultucker79 in forum Excel General
    Replies: 2
    Last Post: 02-12-2007, 02:37 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