Password on excel spreadsheet

scotty1971

can you put a password on an excel spreadsheet, so nobody can open it without the password.

also the spreadsheet i have downloaded for weight loss is in pounds,is there anyway i can change it to stones and pounds?

scott

LucianH

When you first do a save, or subsequently do a Save As you should be provided with an Option or Tools or other dropdown (depending on the version of Excel). You should be able to find a set password option. You normally given the option to set two passwords - one to open it and one (once opened) to edit it (you can also set a read only option so once opened, it's be read only).

If you google Set Password Excel xxxx (xx being you version) you should easily be able to find more detailed instructions

LucianH

In relation to your second question, if you have the number of pounds in, for example, cell B5 then you can put =INT(B5/14) in cell C5 and =MOD(B5,14) in cell D5 will give you stones in C5 and the remaining pounds in D5.

Alternatively, and a bit more convoluted, but if you want the figure presented as Xst Ylb then put =TEXT(INT(B5/14),"0") & "st " & TEXT(MOD(B5,14),"0") & "lb" in cell C5

Lincoln_Imp

LucianH wrote: »

In relation to your second question, if you have the number of pounds in, for example, cell B5 then you can put =INT(B5/14) in cell C5 and =MOD(B5,14) in cell D5 will give you stones in C5 and the remaining pounds in D5.

Alternatively, and a bit more convoluted, but if you want the figure presented as Xst Ylb then put =TEXT(INT(C3/14),"0") & "st " & TEXT(MOD(C3,14),"0") & "lb" in cell C5

Excellent reply :T

john1

Years ago I had to open a P/W protected Excel workbook I found Google supplied all the answers


So from experience if I was you I would secure the workbook file with something like Sophos Free Encryption to prevent any unauthorised opening

mr_fishbulb

john1 wrote: »

Years ago I had to open a P/W protected Excel workbook I found Google supplied all the answers


So from experience if I was you I would secure the workbook file with something like Sophos Free Encryption to prevent any unauthorised opening

Depends what version of Excel you have - 2007 and onwards uses strong AES encryption (which is what your Sophos tool uses). As long as you use a long password you'll be fine.

Excel 2003 used RC4 and didn't implement it too well so the encryption on that can't be relied upon.

scotty1971

LucianH wrote: »

In relation to your second question, if you have the number of pounds in, for example, cell B5 then you can put =INT(B5/14) in cell C5 and =MOD(B5,14) in cell D5 will give you stones in C5 and the remaining pounds in D5.

Alternatively, and a bit more convoluted, but if you want the figure presented as Xst Ylb then put =TEXT(INT(B5/14),"0") & "st " & TEXT(MOD(B5,14),"0") & "lb" in cell C5

thanks for that ,but do not have a clue how to do it

LucianH

scotty1971 wrote: »

thanks for that ,but do not have a clue how to do it

Have responded to your PM to provide further details.