You are not logged in to Prodigits. Please register or login. You are not logged in to Prodigits. Please register or login.
Subject: Excel Question !
Replies: 12 Views: 2214
jupiter2 25.09.11 - 07:48am
Have been working with it for quite a long time.... Now I want a solution from u guys.... I have made a large proforma with excel which contains a big number of complex formulas in many cells.... Now I want the cells to be locked so that no one can change/destroy my pre-entered formulas.... Coz it took a week to make this sheet.... Is there any way to lock some selected cells containing formulas?.... * +
jupiter2 25.09.11 - 07:56am
I'm asking this because most often I become too busy to fill up this proforma at office... But I'm bound to prepare this proforma every week... Now I want one of my junior colleagues to just enter the values in the blank cells, the rest calculation will be done by excel itself... And I'm concerned he can delete some of the formula cells in this process and end up with a wrong grand total value.... * +
jupiter2 25.09.11 - 12:43pm
Got it.... Just found the way myself what I wanted.... ;-) * +
archer38 26.09.11 - 01:14am
Save it in your flash drive so you can accessing it anytime you want withot worry to delete. * +
jupiter2 26.09.11 - 03:26am
@archar.... I've backup, so I'm not worried about deleting or losing the file... Actually, I wanted some1 to do the fill up job for me correctly without tampering my formulas.... Btw, I've spent some time with excel on it and found out the way to password lock the formula cells (or other selected cells)... Thats what I was looking for.... Thanks anyways.... * +
w.h.y 26.09.11 - 08:09pm
Hi i envy u expertise! Proforma? Greek 2me..! * +
w.h.y 26.09.11 - 08:17pm
Im about to learn excel. I have an old excel book but it teaches technical stuffff. Where can i get acual sample data, databases, etc to use in my excel? Preferably sumthing i could just Copy+Paste? thanx * +
phemzask 26.09.11 - 09:15pm
jst google, u neva gona learn with copy n paste! * +
+ go to page 1-2
+ my page
+ functions
3 search
4 submit a reply
7 last page
+ bookmark
8 Tech&Computers Forum
9 Forum Index
