Excel problem urgently help me

**shahleopak** · 29th July 2009, 02:11 PM

all member of IT DUNYA
me n excel me ek ledger bnaya ha us me 3, 4 columns me formulas lgaye hen pls koi btaye k kis trha me us ko hide kr do ta k koi formula na dekh ske wese me ne protect sheet limit bnaye ha lekin problem krti ha me sirf formulay hide krna chata hon meray elawa koi b unhide na kr ske pls help e

**Superboy** · 29th July 2009, 02:13 PM

bhai aap koi screen shot dain us ka then i help you

**Superboy** · 29th July 2009, 02:19 PM

ok wait for a moment ...!!!!

**Superboy** · 29th July 2009, 02:25 PM

1 - Select all cells (either press Ctrl+A or click on the small upper left square on the edge of the worksheet)

2 - In the menu bar, go to Format - Cells

3 - In the popup menu that opens, click on the Protection tab (it should be the last one on the menu)

4 - Deselect the small box tagged Locked

5 - Click on OK. Now all your cells can be overwritten, regardless the protection status of the worksheet.

6 - Select only the cells containing formulas that you want to hide (If you need to perform multiple selection, you can press and hold down the Ctrl key, while clicking on each cell you want to select)

7 - In the menu bar, go to Format - Cells

8 - In the popup menu that opens, click on the Protection tab

9 - Tick the small box tagged Hidden and the Locked box as well. If you don’t tick the Locked box, other users of your worksheet would be able to overwrite the formula cells, without even knowing that they contain formulas (as they become invisible following this operation).

10 - Click on OK

11 - In the menu bar, go to Tools - Protection - Protect Sheet

12 - If you want, you can input a password for unlocking the worksheet. This will prevent others from unlocking it. If you don’t want to do that, leave the password field blank and press OK.

13 - Now click on one of your cells containing formulas and look at the formula bar. It should be empty, although the formula is still there. The cell would remain locked, but it would be automatically updated when changing the content of its precedents relating to the contained formula.

14 - Never forget to thanks killlarboy

**shahleopak** · 29th July 2009, 02:32 PM

Bhai Sahb Me Ap Ko Image Deta Hon Us Ko Check Kro Jahan Dira Ha Waha Formula Ha Us Ko Hide Krna Ha Koi Dosra Na Dekh Se Jis Trha Hm Protect Krte Hen Wid Pasword Usi Trha Ho Method Pls Help Me

**shahleopak** · 29th July 2009, 02:35 PM

Pls Koi Btaye Method Ho Ske To Image K Sath Pls Help Me Only Formula Hide Wid Pasword If Possible

**Superboy** · 29th July 2009, 02:42 PM

sab kuch ho skta hai try karo meri tip pe...!!!!

**shahleopak** · 29th July 2009, 03:27 PM

pls help me

**shahleopak** · 29th July 2009, 03:38 PM

pls any member help me i in trouble urgently help me i m waiting...

**kamranshahr** · 29th July 2009, 03:52 PM

[QUOTE=shahleopak;985908]pls any member help me i in trouble urgently help me i m waiting...[/QUOTE

CHEK THIS MAY BE USE FULL
http://www.techonthenet.com/excel/ce...e_formulas.php