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

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top