freeze

good morning excel freeze when clearing all filters ( freeze for a minute or 2 minutes then resume working ) , during the freezing time the calculating percentage don't show, it shows after the freeze is resumed. if i clear each column filter individually it don't freeze, that happens in most of...

Hi all, I am currently using this formula: With its neighbor formula in column C going like this: My question is whether it would be possible to somehow freeze my data in cell B3, C3 etc. going forward? So once the formula detects that a data entry has been in the cell 2 rows below it, it...

I have a big excel file (20 modules, 40 sheets, 5 forms) with a custom menu bar. The main issue I have: after I've run certain macros (got dozens doing various stuff), whenever I switch worksheets, my Excel will freeze, crash and re-open my file. The custom menu bar has several bits that are...

Hello, there is a problem I have with my labeling tool I wrote for Excel. I'm afraid I have to go a while back on that. I'm working in an office where we have to print labels for our articles that we sell. It used to be a tedious process with lots of folders of examples on how to write the...

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)...

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...

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...

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...

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...

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...

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.

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...

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?

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

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...

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!

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...

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...

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

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