+ Reply to Thread
Results 1 to 2 of 2

Freeze panes title row & merged cells

  1. #1
    Registered User
    Join Date
    04-02-2011
    Location
    Espoo
    MS-Off Ver
    Excel 2007
    Posts
    16

    Freeze panes title row & merged cells

    Hi all,

    if I have pane frozen and the title row consists of merged cells and I have scrolled e.g. to the middle of the data and try to select few cells of the title row, Excel selects everything between the title row and data underneath the frozen area and starts scrolling up.

    Is this some feature related to merged cells or can something be done for this...? Has anyone seen this before?

    I have an excel sheet attached to demonstrate this, not huge but very annoying, issue.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    07-21-2008
    Location
    London, UK
    Posts
    326

    Re: Freeze panes title row & merged cells

    merged cells are awful and generally cause problems, try to rid them and use centre across cells instead, might be a heap easier etc

+ 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