freeze

I try to freeze date and time on the Excel cell and I know NOW() would change by the date and hour. CTRL+; --> to freeze the date CTRL+SHIFT+; --> to freeze the time Please tell me how and where I could put the ASCII code on the cells. (Recording macro does not reveal the code)...

hi, in using index array and have multiple rows in my formula I.e) row (1:1) row (2:2) when i I fill them down I need them to freeze, is this possible please? It will take me hours to manually change them, thank you.

Hello, i have been working with VBA in Solidworks but i believe my question still applies I started using a spinbutton in my form to add a value in the textBox, so far so good, had no problems Everything runs smothly in my form until i press the spin button, because when i do i cant press...

Hi, I have Excel 2016 (365 ProPlus). As soon as I start to change a cell's content it freezes. I then close it from the task manager, open it in Safe Mode and it works fine. I turned off all the Addins, but it didn't help. Also tried the Graphic accelerator on/off. I run Windows 10 and have no...

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

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

I would like to divide my sheet in half. I want to be able to scroll up and down on the left side and I want the right side to remain static. I tried freezing but that only works in the top row or columns to the left of my information that I want static. Also splitting doesn't allow me to...

I can freeze either Rows OR Columns, but I would like to freeze both Rows 1,2,3 AND Columns A & B. Can that be done?

Is there any way to freeze more than once? I have this "Monthly Expenses" workbook where I froze the third row, then all rows above are froze, but I can't freeze anything more. When I try to freeze this table and this chart on the right, the "Freeze panes" option isn't available. Do you guys...

I'd like a spin button that is accessible no matter what spreadsheet (tab) I'm in. The button will be used to match columns of data with another column of data. The reason I'm trying to do this is because I cannot seem to find out how to match two columns of data... I need to match data with...

I am copying from one workbook to another. This code works fine in Excel 2007. However, it freezes each time in 2013 on the .Close portion. Any idea as to why this would happen? There is no issue with the path, and this code has been run hundreds of times in the previous version of Excel so it...

Hi, I have a weird issue with a vba macro I am running. the macro opens up another large workbook which performs calculations using an addin called proj_result. This is actually a Prophet add-in (if anyone on here uses Prophet this may be something you can solve). Basically the workbook...

Hello, I am trying to insert image using macro. It gets inserted, but gets freeze. I am not able to change its size. Excel version se in Excel 2010

Hi All, I have an excel document where i want to freeze both the right and left side columns. Example: Excel allows to freeze specific row or column or left and top of particular cell, however I want to freeze the Column A and as well as Column J and also 3rd Row. Can any one please help me...

Hello,</SPAN> I know how to freeze top rows/columns and panes. Is there a way to freeze intermediate rows? I have title information on rows 1-11 and column header information on rows 12-15. These are the rows I would like to freeze without having to also see rows 1-11. Is that possible...

folks, I do a lot of data crunching and make some big spreadsheets for a large company. with the amount of policy stuff running in the background plus my (most probably) personal code/formula style, I seem to always get issues with time. I either get to take a lunch break while files save or I...

Excel 2007 - UserForm From my main menu which is simply shapes with macros attached I launch the userform. Upon the first try, and not always, just sometimes, when I get to txt_vc1, it freezes and I am not allowed to move to the next textbox. I can still use my Exit button on the UserForm to...

Hi Mr. Excel, I use: Excel 2007, Windows XP, Internet Explorer. I would like to freeze both row 1 and row 2 and nothing below. When I select the top two rows(via the numbers to the left) and select "Freeze Panes" it freezes rows 1-11 instead of rows 1-2. Is there any way to fix this...

Hi. I have created a workbook with multiple sheets for each of my colleagues. There are vlookup formulas and sum formulas that pool data onto a singleaster spreadsheet that gives me an overview of how much work we have gotten through. My issue is that when the book is unshared and on my...

Hi folks, I am running: Microsoft Excel 2010 Microsoft Windows 7 Professional 32-Bit --- I have just migrated to a new machine, with a fresh copy of windows and office, and the identical problem from the previous machine remains, so please help! --- At random points several different...