+ Reply to Thread
Results 1 to 2 of 2

Can rows be locked with out freezing them

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    01-29-2008
    Location
    Scotland
    MS-Off Ver
    2003
    Posts
    237

    Can rows be locked with out freezing them

    I know that you can freeze a row or column in excel, but what i want to know can a row be locked in a work sheet so that it cannot be move if say you incert another row.

    ihave pages with headers at the top and half way down the page, but i dont want them to move as data is insert.

    Is there a way...????

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582
    Please explain. If you have headers in row 1 and row 100. If you insert a row at row 25, why would you not want your second header to drop to 101? Are there a significant number of blank rows inbetween and you would want one of those blank rows to be deleted to keep header 2 in the same row? Do you have a reason for doing this other than estetics? Maybe there's a different way to go about this.

    ChemistB

+ 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