1. E

    Custom Views are Re-Setting my Freeze Panes settings

    I'm setting a custom view that has certain filters set on my data. I'm filtering by 2 columns. Once I've applied the custom view, I go to Data-> Sort & Filter-> Clear so that I can see all of my data again. When I do that, the data that was filtered out of my custom view (ie not showing)...
  2. S

    Line-breaks in Userforms freezes Excel

    Am using userforms on a spreadsheet to populate content to cells within a worksheet. The links are working perfectly and the data is being copied across precisely, from the userform to the cell and visa versa. However, when a line-break is added (ALT+ENTER on the worksheet / ENTER on the...
  3. B

    Can I Freeze a Slicer

    I have a date slicer connected to a pivot table with over 3000 rows so I was wondering if it was possible to freeze it like I can with an excel row? I have the top row of my sheet frozen so I can see the column headers while I scroll but my slicer moves out of view when I scroll. I thought it...
  4. K

    Excel lags when switching between automatic & Manual calculations

    wonder if anyone has a fix for this problem. it is not related to actual calculation time as the effect occurs even with a new blank sheet. I will do my best to explain and hope someone has come across the problem as well. With a new and blank sheet changing from Automatic to manual causes...
  5. Dan Wilson

    Freeze Panes help

    Good day. I am running Excel 2013 on Windows 10 Home. I have a workbook with 7 worksheets with several Macros. There is also a Macro in the "This Workbook" that runs every time the workbook is opened to set all the workbooks to a generic condition. Recently I discovered the need to use the...
  6. Dan Wilson

    Freeze Panes help

    Good day. I am running Excel 2013 on Windows 10 Home. I have a workbook with several worksheets. A couple of the worksheets have Columns with data that extend out to Column EA (125 entries). I am already using the Freeze Panes function to keep the Column Headers in View. Is there a function...
  7. G

    Freeze a shape

    Is there a way to freeze a shape so that it behaves like freezing cells? I want to freeze a shape so that it always stays on the screen even when a user scrolls.
  8. A

    Freeze Panes from Access

    I'm building a Excel Workbook from Access after setting a new Excel.Application. Set ws= objExcelApp.Workbooks.Open(Myfile).Sheets(1) With this I am able to use methods ws.cells, ws.columns etc. I would like to freeze the top row of sheets(1) but haven't been able to figure it out. In Excel...
  9. M

    Table of Contents - Keep TOC tab frozen

    I set up a table of contents because I have over 100 tabs in my spread sheet? The scrolling / tabbing over just takes too much time. Is there a way to freeze the TOC, so I can get to it from any tab without having to arrow back?
  10. W

    How to freeze panes on mouse scroll

    Hi, I am trying to hide some rows and then freeze panes on mouse scroll. 1. User scrolls down 2. Hide rows 1-5 3. Freeze new rows 1-5 Is this possible? Sub FreezeRow() ActiveWindow.FreezePanes = False Rows("1:5").Select ActiveWindow.FreezePanes = True End Sub
  11. C

    Freeze pains shortcut crashes files with data model

    I have been experiencing this same crash on multiple files... it seems like an excel glitch. It happens when I have data loaded into the data model via power query and pivot tables feeding from the data model. When I execute the freeze pains shortcut (Alt, W, F, F) the file immediately crashes...
  12. P

    Freezing/splitting panes in multiple places in one sheet?

    I am new to this forum (and fairly novice to Excel), so I hope I am doing this properly! I am wondering if there is a way to split or freeze panes in more than one place in the same sheet? Thank you!
  13. N

    Help required in VBA

    In my excel sheet were I want to lock cell range L1: L1000.Only after double click on L1: L1000 , user form for password should popup. After entering password L1: L1000 should be editable. If I enter “OK” In any were between L1:L1000 then the whole Rows should be freeze (Eg: If I enter “ok” in...
  14. N

    vba Help

    Please help me out with my issue. In my excel sheet were I want to lock cell range L1: L1000.Only after double click on L1: L1000 row user form for password should popup. After entering password L1: L1000 should be editable. If Ienter “OK” I any were between L1:L1000 then the whole Colum...
  15. L

    freeze 2 ranges of cells on one sheet

    hello guys, I need to freeze two ranges of cells on the same sheet. For example I want to freeze range A1:H4 and range J3:Q32. How do I make this happen. ty
  16. W

    how to freeze both the left side and the top panes in Microsoft Excel 2010

    I'm using Microsoft Excel 2010. It allows me to freeze the panes but it only permits either the left pane or the top pane. How do I freeze both the left-sided pane as well as the top pane? Thank you for any inputs
  17. N

    Freeze panes acting strangely

    When I freeze panes it doubles up some descriptions and missing others, scrambling the headings. Does anyone know how to fix this?
  18. W

    Freeze some cells

    Hello I have a logo and some header text that I need to keep fixed on top of the excel sheet (lets say from columns A to J and rows 1 to 4). I want to keep this part of the sheet fixed for vertical / horizontal scrolls. Just as a note - I know the functionality of 'Freeze panes' and that will...
  19. K

    Freezing Columns

    I was working with excel. In doing so I made 13 headings A to M. I was trying to freeze the cells A to M. See picture below. Now I selected. Columns A to M were selected. Than I went Freeze Panes and Freeze First Column. Than when I move the...
  20. H

    Freeze top 2 rows when sorting and exclude row 2 from the sort

    Hi, Office 10, Excel version 14 I'm using Data/Filters, with headings in rows 1 and 2. When I sort, row 2 naturally sorts as well, as only row 1 has been recognised as a heading by filtering. I can easily freeze the top row from scrolling, but I'd also like to freeze the 2nd row, and exclude...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...