Results 1 to 4 of 4

Lock section of sheet without split?

Threaded View

  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

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