20 Most Recent
Microsoft Office Excel 2003 for PC Questions & Answers
Ms-office
Subtraction can be done in two ways in Office using the following formulas in the formula (fx) bar:
- =A1-A2
- =SUM(A1,-A2)
The above formulas refer to cell reference A2 subtracted from A1. As usual, you can use number values instead of cell references.
The SUM formula subtracts by changing the sign of the reference. Remember the sign rules, and thus - -x is in effect +x.
Macro help in Excel
go google and type in--- user manual for excel---
there is a pdf version about 900 pages long that explains everything you want to know and do in excel
Excel oquestion
how to remove the excel file security pass word
solution explain tel plz
Sometimes when I use a formula in Excel 2003 it
Make sure, when you entr a formula that you hit the ENTER key instead of just moving to tyour next cell. To have all numbers added or moved, use the"Special" application, or change the value. Such as -if you are working in text mode and you enter numbers, they are only numbers in text mode. They don't have a value. Correct the cells to reflect numbers. Right click, format cell - select what you want.
I want to know how I can to apply the formula
Enter data the number 10 on cell A1. Enter data the number 20 on cell B2. Mouse click on cell C3. Press equal sign, press left arrow, press *, press left arrow twice, press enter. Mouse click on cell C3. You'll see your formula on the address bar. Hope this helps.
I want verify the data
Hi Manjee,
There is no formula used in data dropdown list, so it can not be verified as a formula using evaluate formula, trace errors, trace dependents, trace precedents etc.
If you want to create such lists simply:-
- Select input range then goto
data --> validation --> allow, list --> select the list range
- To veryfy you can follow the same process
data --> validation --> allow, list ,
now you can see the exact range from where the data is picked.
Thanks
Zulfikar Ali
[email protected]
09899780221
Countifs
The formula in both versions is the same:
=countif(range,value)
i.e. The below formula will increase its count by one if any of the 18 cells it's checking are equal to 1.
=countif(A1:B9,1)
LENGHTY IF STATEMENT
To find the second character in a string in A1 use =mid(A2,2,1)
To check if it is a number use =isnumber(value(mid(A2,2,1)))
I hope this helps to get past the part you are stuck on - not being familiar with your problem it's difficult to give you any more advice.
Microsoft Excel files: File size becomes very big while saving.
Whenever Excel closes unexpectedly, "ghost users" can remain in a "shared" workbook. Excel tracks changes in order to synchronize between users, resulting in huge file sizes. In order to fix the problem click Share Workbook (Review tab, Changes group in 2007 or Tools/Share Workbook in earlier). On the Editing tab see if there are any "Users" using the workbook. If so, remove them by clicking "Remove User." When you save again, the file should be back to normal. Being this is a Microsoft product, I want to re-emphasize the word "should" from my previous sentence...
I can't get Microsoft Excel 2003 to delete cells
Hello,Unless the excel spreadsheet is locked for editing then all you should have to do is Left Click on the cell you want to delete and press Backspace or the DEL key on your keyboard.To delete multiple cells left click and hold in the middle of the first cell and drag your mouse down or across to highlight multiple cells. Then press the Backspace or DEL key on your keyboard.
Whenever I open a new spreadsheet now it
You're right - it was caused by recording a macro. When you record a macro you are given the option to store the new macro in "This Workbook", a "New Workbook" (the default), or in a "Personal Macro Workbook". It looks like you selected "Personal Macro Workbook".
The recorded macro is stored in a special workbook called "Personal.xls". This workbook is loaded every time Excel is loaded. If you don't want this workbook loaded, then just delete it or rename it.
The file is buried deep in Microsoft's application data area. On my Vista computer it's in C:\Users\frogfund\AppData\Roaming\Microsoft\Excel\XLSTART
On my Windows XP computer it's in C:\Documents and Settings\frogfund\Application Data\Microsoft\Excel\XLSTART. Depending on your computer your Personal.xls might be in a slightly different location. You might need to do a search using Windows Explorer.
If you are still having troubles finding personal.xls
1. Open Excel,
2. Open the Visual Basic editor (hit Alt-F11 or click Tools-Macro-Visual Basic Editor)
3. Click Tools-References to bring up the references dialog
4. Click on VBAProject in the list. The file location will be displayed near the bottom of the dialog box. Sometimes this might be cut off at the end, but it should give you a good idea where the file is located.
5. Click Cancel to close the dialog.
On my Excel worksheet there
Are you using Office Excel 2003? That website is for the 2007 version. That button does not exist in the 2003 version. You will need to upgrade to Office 2010 if you want the button.
Not finding what you are looking for?