20 Most Recent Excel (SS8SATAS5128400R) Questions & Answers

You can recover your lost excel password with the use of excel password recovery software likehttp://www.stellarinfo.com/password-recovery/excel-password-recovery.php First use trail version if you are satisfied with result then go with full version?

Hi SAJID MEMON,

This one is a little hidden, it's an option under the save as window. So go to file->save as then you should see either a down arrow on the save button, which opens up a sub menu or a tools option in the top right. Under tools select general options, then you should see the password options there.

You will need recovery software to recover password for the protected files
here is the link
link1
Excel Password Remover 2008
--------------------------------------------------------------------------------------------------
Low feed backs hurt my ratings and I tried my level best to resolve the issue. so please show your appreciation by rating it.
Thanks for using fixya support..You have a wonderful day

If you don't have MS Office, then you will have to purchase either the Excel component as a stand alone but you would be better off with the whole MSOffice as it contains your Word processor, Database, Excel, Powerpoint presentation software and in the 2003 version also Publisher.

It is not too badly priced anymore, but if you cant afford it then you may be able to borrow a copy whilst you are doing your course from a friend, but you will have to uninstall it afterwards.

MS Excel is not afree program.
You will need to purchase a copy of MS Office which includes Excel.
For an alternative free program OPEN OFFICE is a full-featured officesuite that's compatible with Microsoft Office.
If you want Open Office you can download this free program.
Click on this link to download :-
http://www.openoffice.org/

click here

HI!
Just go to google.com and type the following into the search box.

Excel Password Unlocker free download

and find a free office password unlocker.

most password unlocker tools do not give you the password to unlock your workbook, they just go into the system workings and unlock the entire workbook for you.

save a copy of your locked up workbook. only try the breakers on a copy, just in case.

Hi SAKHIE

You need to run a utility, link below
http://www.straxx.com/excel/password.html

could you please supply us with the version of Excel you are using? it's under Help About Excel

You can import data from one sheet to another. If you want to bring a total from Sheet 1 to Sheet 2, then in Sheet 2 enter [=sheetname!cell] (without the brackets of course. You will now have the data from Sheet 1 in a cell in Sheet 2 and you can do anything you want with it. One note: if the sheet name has a space in it (Sheet Name) you have to enclose the name in single quotes; that tells it that the whole thing is the name. For example, Monthly Sales, A10 is the total for last month; to put it in this month for a running total, you would enter in Sheet 2 ['Monthly Sales'!A10] (without the brackets again). Now you can have a running total between the two sheets.

Use the installer disks. Of course, you can switch to OpenOffice, which is free:
http://why.openoffice.org

= (a3) minus (b3) won't do it for you?

Hi blackhand18,

This might be different on your version of excel but try this

=INFO("release")

Hi Hss Holdings,

The easiest way to do this is to use a formula called vlookup. You need to have the raw data some where in the workbook, but it can be a separate sheet. Put all the raw data in a table, make sure the account number is on the furthest left column, then start entering the formulas

vlookup(value_to_find, table_to_check, column_index_number, range_lookup(true/false))

value_to_find = the value you want to find on the left most column of the table
table_to_check = the table you want to find the data from
column_index_number = the column number of the data field you want to return into this cell, 1 = the left most column.
range_lookup = false for an exact match, true for the nearest match

Say the table is on sheet2 between A1 and E300

B15 is whatever you type, so no formula needed here
B12 =VLOOKUP(C1,Sheet2!A1:E300,2,FALSE)
G12 = B12 =VLOOKUP(C1,Sheet2!A1:E300,3,FALSE)
etc

Hi you can Apply below mention formula
=ABS(SUM(COUNTIF(RANGE,"CATAGARI")-(COUNTIF(RANGE,"CATAGARI")))

RANGE = FROM WHICH CELL TO YOU WANT TO APPLY THIS FORMULA TO TILL WHICH CELL.
CATAGARI = WHAT DO U WANT < FOR FOR FIRST > FOR SECOND

Hi KDina,

If you need me to work on this project for you please contact me at [email protected]

Hi,
I am using MS-2007, i got the solution upto some level only.
i can't say exactly whether it is right or not.
my solution is :

first change the settings in ControlPanel/Regional and Language Options.
Click on Customize button/open the Date Tab and set the date format there.
and then proceed with CSV.
Open CSV in Excel and divide Text to coloumns.
Ur all Date Cells will be in particual Format.
and Select that coloumns and right click Format Celss....etc.
Thanking u.

If u found any Douts, Suggestions ,Plzz let me know.

If you right click the cell in question and go to Format Cells..., on the protection tab there should be a check mark in the locked box. Go to the tools menu and choose Protect and Protect Sheet, enter a password and your cells will be protected.

Any cells you want to allow changes to when the sheet is protected should have the Locked checkmark removed.

god knows