Results 1 to 1 of 1

Freezing cells during filter operations

Threaded View

  1. #1
    Registered User
    Join Date
    04-08-2013
    Location
    Marlow
    MS-Off Ver
    Excel 2013
    Posts
    5

    Freezing cells during filter operations

    I posted a problem yesterday, which I have worked around, now I am looking to tidy it up a little bit.

    Is there anyway to freeze a cell/s (merged) so that it stays visible and the same size when you apply a filter?

    Basically I have some title blocks, and when I filter the data some of them shrink due to cells being hidden. I have attached the workbook with the personal data removed. The cells I would like to freeze are the first column (equipment, personnel etc) and the 3 title rows (project 1, 2, 3).

    In order to keep them visible when running the filters I have kept 'blank' shown, but it makes the sheet look messy. Ideally, for example, when filtering to only show high priority tasks, I would like the blank cells to also be hidden, but still have the 3 groups visible and the titles left the same size.
    Attached Files Attached Files

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