in a normal excel formula (not in a table), I can lock a cell reference with a $, e.g. $A$1 locks in the cell to copy the formula. How do I accomplish this within a table formula to lock in a colum... Riny_van_Eekelen Thanks for that link, exactly what I ...
It's great! I have been asked to build a template which can be used to enter data regarding restraints and seclusion orders. The person entering the data is not at all Excel savvy so I don't want to set him free in a spreadsheet with formulas embedded in the cells without the formulas...
Forum:Excel Questions T Number Locking Not Working Hi all, I am creating a Covariance Matrix and trying to do so by locking certain ranges so I can drag the formulas across and downward. But for some reason, the letter section of my range will not lock. For example, D$5:D$159 Should...
Activex Command Button Doesn't Click - Excel I'm having a problem in a workbook with several ActiveX command buttons. I had been using the form control buttons to run macros, but the boss wanted each button to have it's own, different color. So I removed the form control buttons and ...
Perhaps sometimes you need to add a new row, or remove it expecting that to simply work, even if there were some formulas, like SUM(A1:A100) involving these rows, right? And have you ever had to collaborate on a single spreadsheet with another person? How did you go about not ...
Hi there. I'm pretty old school and I'm not very technical with Excel and am somewhat unfamiliar with it. I've also never used this facility. I've got...
Can I lock an excel sheet, but leave 3 cells editable? excel Formulas and Functions office 365 Like 0 Reply JKPieterseNov 13, 2018 Of course! By default all cells are marked as locked. Unlock the cells you want to grant access to (right-click, Format Cells, Protection tab, uncheck ...
Hello, I am not very familiar with conditional formatting but the situation is as follows: In column A I have gotten dates in...
Locky81 That probably requires VBA code, but we'd need to have more detailed information. Thank you! Will the user enter TRUE or FALSE in K4, L4 etc., or do those cells contain formulas too? I'm trying to find out which cells, when editeddirectlyby the user, will determine the resu...
=COUNTIF($A$2:$A$100, A2)<=1 Note: Range A2:A100 where you want to enter Serial number. Start with 1/20-21 in A2 and continue.