Protection of all but a few cells on a sheet

Mac

Question:I cannot operate. When I try to lock a single cell via the format cells - > protection, I am informed that a lock on a cell has no effect unless the worksheet is not protected. When protect the entire sheet, I no longer have the possibility of changing the status of protection of a cell. What I am missing? I have, in passing, has studied and followed the entry "Protect sheet" help, without...Read More

Posted: 21 Apr 2012

Tags: Protection of all but a few cells on a sheet Protection all but few cells sheet

disable the calculations of formulas in cells

Mac

Question:Is there a way to disable these calculations to cell in cells?For example: I would like to just have the text in a cell: = priorityIt provides a replacement with a sort of code, it thinks I want.Help!Answer:Yes. Type a single quote as the first character to indicate to Excel to process the input as text instead of a formula' = priorityRead More

Posted: 17 Apr 2012

Tags: disable the calculations of formulas in cells disable the calculations formulas cells

How to value all cells in a named range

Office

Question:I have a list of spare parts in a column in MS excel 2007. some of these parts are assembled together to another assembly.I would like a link / highlight all of these elements in the column.Answer:Thank you again, even if your suggestion solved my problem in a large measure, I was looking for to select a replacement part that highlights all the parts Assembly and F5 is the otherwise autour...Read More

Posted: 17 Apr 2012

Tags: How to value all cells in a named range How value all cells named range

Choose the value of the cell of the range of cells

Office

Question:Hi allI have a column of values for each month, I would like to have a single cell (off the coast of the side) choice of the largest value in the column and show here.I need to report the largest tonnage for a date within a month.Column 1 = Date of the monthColumn 2 = crewColumn 3 = Tonnage produced for the crewColumn 4, end of month (say the cell "D31") indicates the value of tonnage in...Read More

Posted: 15 Apr 2012

Tags: Choose the value of the cell of the range of cells Choose the value cell range cells

How to fill in the empty cells in a pass with the value above

Office

Question:A1 181200234 1812025 1812037891011 6 12 18120513141516171819 181206Answer:Select the column has and F5 > special > blanks > OKType a selected top White = sign and then click the cell above.Now hit CTRL + ENTER to fill all empty (at the bottom of the range of a)Copy > Paste Special > values > ok > esc.GordRead More

Posted: 15 Apr 2012

Tags: How to fill in the empty cells in a pass with the value above How fill the empty cells pass with value above