freeze panes

  1. S

    VBA Code to Ctrl+Home in Freeze Panes ignoring Hidden Cells

    In most of my Excel sheets, I use Freeze Panes. And to keep my work visibly tidy, I hide rows. Now, I have VBA to reach First Cell after Frozen Pane. And also, VBA for ignoring Hidden Rows. But when I combine both to reach First Visible Cell - It takes a lot of time. I strongly believe that...
  2. L

    VBA code to Freeze/Unfreeze Panes based on a Cell Value

    Hi, I have a sheet where it would be handy to have/not have frozen panes depending on how you're filling it out. Other people without excel experience will also be using this sheet, though. I have a cell (x) with data validation that has two options: Freeze Panes/Unfreeze Panes. I'd like to...
  3. Z

    Freeze Multiple Row

    Hi I am trying to freeze multiple rows in excel. I select the rows and columns I want to freeze then go to Freeze Panes-> Freeze Panes but it just freezes the first row. How can I freeze multiple rows.
  4. T

    How can I protect my control buttons

    <!--[if gte mso 9]><xml> <o:DocumentProperties> <o:Version>14.00</o:Version> </o:DocumentProperties> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hello I have three general-purpose questions for you Excel/VBA experts. On all my sheets...
  5. R

    Can't freeze panes in excel 2013 win 10

    Hello, I have problem with freezing/unfreezing panes in a specific workbook in excel 2013, windows 10. The workbook and worksheets are protected and contain VBA code. I can freeze and unfreeze panes in excel 2010 windows 7, after unprotecting the workbook. In 2013 button to freeze panes in...
  6. J

    "Freeze Panes" is grayed out.

    A co-worker is working with an old spreadsheet - SaveAs indicates it was created, or at least last saved, in Excel 97-2003. Freeze Panes is grayed out and nothing I've tried so far has un-grayed it. I did a SaveAs in 2010 (which is what we all have on our computers at work) to the format for...
  7. T

    Excel Multiple Row Freeezin at Different Area

    Hi, I have a question about the Freeze feature; Is it possible to use it to make multiple frozen rows but not using them adjacent to each other. I mean I don't want to select two row and make them one frozen row. I made some researches about it, but I'm not sure whether I used the right...
  8. J

    Freezing columns

    Hi, I have pivot charts from column A through AA up to row 150. Then I have pivot slicers from the right of columns AB and after up to row 40. How do I freeze the panes so I can scroll down 11 pivot charts to have the slicers to the right w/out moving?
  9. C

    Macro for Freeze Panes with a filter

    I often work with multiple windows of the same workbook. what's really annoying is each time you open the workbook the freeze panes disappear. I have set a macro to put the freeze panes on at the click of a button, but it doesn't work properly if the there is a filter on as it freezes the hidden...
  10. G

    Freeze Panes

    Is there a way to freeze column A, but not for scrolling left and right, but up and down? Like I want columns C and on to scroll up and down, and column A just stay put and not scroll up and down with the rest of the page.
  11. E

    How to overlay ActiveX / OLEObject so Freeze Panes doesn't split it

    Hi guys. I hope there's an answer to this one. I have a worksheet which demands panes to be frozen across both axes (select cell H11 then freeze panes). I also have a whole panel of ActiveX controls in the top-left corner (created at runtime with VBA, every time the document is generated). I...
  12. B

    ActiveWindow.FreezePanes behavior

    Hey all I was hoping someone could elaborate on the behavior of the FreezePanes property -- specifically, what might cause it to fail or produce undesired results. I have a worksheet, I use the Application.Goto method to select a range at which to freeze (rFreezePoint), then set FreezePanes...
  13. 2

    Freezing different panes based on location in worksheet?

    So basically what I want to do is have the header show for the table I am looking at with multiple tables stacked on a worksheet (A1:C50, A52:H200, A202:E500 for example). Each table has a different header rows. I only want the headers rows for the given table to freeze while I am at that table...
  14. A

    Freeze Panes Glitch / Issue

    Using Excel Office 365, I'm trying to freeze the top 4 rows on one tab. I select cell A5, go to View Tab, Window Grouping, Freeze Panes Pull Down, Freeze Panes. The result is that the top 4 rows indeed freeze, however, they are duplicated on the scrolling window below, and if I click in a...
  15. D

    Freeze Panes - Greyed Out

    I have a strange excel behavior I have only seen after switching to Excel 2013 - AKA worst excel "upgrade" ever, but I digress. I download and work with several data extraction tools such as cognos and others and I notice when opening some files "Freeze Panes" is grayed out. No amount of...
  16. U

    Is there a way to hide rows above the header automaticly?

    Rows 9 and 10 must be viable all the time so I set the freeze pain there but I need more rows to be visible when scrolling down. I would like to find a way to hide row 1 first when the user starts scrolling down. Then hide rows 2 through 8. When rows 1 through 8 are hidden we can hide the rows...
  17. F

    Freezing a row with a catch...

    Hi All- I am looking to freeze row 18 in an excel sheet, however in doing so this really limits the amount of rows below row 18 that can be viewed and scrolled through. I would like to know if there is any way that you could freeze row 18 and when you scroll down on the worksheet, you can...
  18. H

    Excel Print Frozen Panes - Grayed out

    Hi guys, I have an issue where I froze panes, but when trying to print, the frozen panes do not stay on each page. I can go to: print preview -> page setup -> sheet There's an option there to "repeat rows at top" - but this option is unfortunately grayed out. This only happens for some of my...
  19. U

    Can you Freeze Panes on one row and have it scroll to the top and stop?

    I expect someone to come back and just say no, it cannot be done. At least I can stop looking for it. I have to keep row 16 on the screen at all times but I need more real estate on the screen when I scroll down. What I want is to have row 16 scroll up until it gets to the top of the screen as...
  20. S

    ActiveX List Box and Freeze Panes

    I've been working on a Survey template for a project at work. The workbook has multiple worksheets (1 for each question) and a series of repeating List Boxes for responses corresponding to multiple locations. Each list box is populated from a static named range on another worksheet...

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top