EXCEL WORKSHEET

%3CLINGO-SUB%20id%3D%22lingo-sub-1591364%22%20slang%3D%22en-US%22%3EEXCEL%20WORKSHEET%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1591364%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20need%20assistance%20with%20an%20excel%20spreadsheet.%20I%20would%20like%20to%20make%20each%20cell%20within%20a%20column%20have%20a%20value%20of%200.5%20that%20is%20hidden%20from%20anyone%20using%20the%20spreadsheet.%20Once%20they%20select%2Fcheck%2Fenter%20cells%20in%20the%20column%20it%20will%20automatically%20give%20a%20sum%20at%20the%20bottom%20of%20cells.%20That's%20the%20best%20I%20can%20do%20the%3C%2FP%3E%3CP%3Eexplaining.%20Thanks%20for%20any%20assistance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1591364%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1591394%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20WORKSHEET%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1591394%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F760946%22%20target%3D%22_blank%22%3E%40KDTaylor%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20explain%20why%20you%20need%20it%20like%20that%3F%20there%20is%20something%20not%20clear.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1591606%22%20slang%3D%22de-DE%22%3ESubject%3A%20EXCEL%20WORKSHEET%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1591606%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F760946%22%20target%3D%22_blank%22%3E%40KDTaylor%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EAs%20Mr.%20ramizassaf%20has%20already%20told%20you%20...%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20%3CSPAN%20class%3D%22%22%3EIt%20can%20help%20us%20all%20if%20you%20upload%20an%20Excel%20file%20(without%20sensitive%20data)%2C%20no%20picture.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3ESo%20you%20could%20get%20a%20precise%20solution%20much%20faster.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EThis%20would%20also%20be%20a%20blessing%20for%20us%2C%20as%20we%20can%20understand%20the%20problem%20much%20better%2C%20a%20win-win%20situation%20for%20everyone.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3E%20%3CSPAN%20class%3D%22%22%3EI%20can%20only%20guess%20that%20there%20is%20no%20Excel%20file%20(and%20I'm%20not%20good%20at%20that).%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3ESuspect%20because%20the%20translation%20of%20your%20request%20sometimes%20also%20plays%20a%20role.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20%3CSPAN%20class%3D%22%22%3EIn%20your%20case%20there%20could%20be%20a%20lot%20that%20might%20need%20a%20macro%20or%20a%20formula%2C%20just%20indicated%20as%20an%20example.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20%3CSPAN%20class%3D%22%22%3EI%20would%20therefore%20be%20happy%20to%20be%20able%20to%20help%20you%20if%20you%20would%20provide%20us%20with%20the%20worksheet%20(without%20sensitive%20data).%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello, I need assistance with an excel spreadsheet. I would like to make each cell within a column have a value of 0.5 that is hidden from anyone using the spreadsheet. Once they select/check/enter cells in the column it will automatically give a sum at the bottom of cells. That's the best I can do the

explaining. Thanks for any assistance.

2 Replies

@KDTaylor 

 

Could you explain why you need it like that? there is something not clear.

@KDTaylor 

As Mr. ramizassaf has already told you ...


It can help us all if you upload an Excel file (without sensitive data), no picture. So you could get a precise solution much faster. This would also be a blessing for us, as we can understand the problem much better, a win-win situation for everyone.

I can only guess that there is no Excel file (and I'm not good at that). Suspect because the translation of your request sometimes also plays a role.

In your case there could be a lot that might need a macro or a formula, just indicated as an example.

I would therefore be happy to be able to help you if you would provide us with the worksheet (without sensitive data).

 

Nikolino

I know I don't know anything (Socrates)