Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need formula to apply to entire column not just one line
I need a formula to apply to an entire column not just a line. I also need to
protect a column in which no one can see the price except for someone with a password. Can numbers be hidden by "XXXXX"? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need formula to apply to entire column not just one line
Do you mean something like Sum(G:G) that sums up the entire G column, or do
you mean a formula in each row down one column? As for protecting the column, you could just lock (right click, Format Cells-- Protection, check Locked) and hide the column (select column, right click, Hide) then protect the sheet (Tools -- Protection --Protect Sheet). Just be sure to have the cells you want to be able to change as unlocked (unselect "Locked" in the Format Cells form). Hope this helps, Jim "Maggie" wrote: I need a formula to apply to an entire column not just a line. I also need to protect a column in which no one can see the price except for someone with a password. Can numbers be hidden by "XXXXX"? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need formula to apply to entire column not just one line
=SUM(A:A) for a column
Excel internal security is very weak. If you don't want someone to see the price, don't include it in the workbook. Gord Dibben MS Excel MVP On Wed, 16 Jul 2008 10:48:00 -0700, Maggie wrote: I need a formula to apply to an entire column not just a line. I also need to protect a column in which no one can see the price except for someone with a password. Can numbers be hidden by "XXXXX"? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to apply the same formula to an entire column | New Users to Excel | |||
How do I apply formula to entire column | Excel Discussion (Misc queries) | |||
How do I apply my function to the entire column? | Excel Discussion (Misc queries) | |||
I want to apply a formula to an entire column. | Excel Discussion (Misc queries) | |||
How do I apply a function to an entire column? | New Users to Excel |