20 Most Recent Microsoft Office Excel 2003 for PC Questions & Answers

Subtraction can be done in two ways in Office using the following formulas in the formula (fx) bar:
  1. =A1-A2
  2. =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.

Microsoft Office... • Answered on May 29, 2018

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

Microsoft Office... • Answered on Mar 27, 2017

Click in the Cell where you want the first number (1) Scroll down to where you want the last number and while Holding the Shift key and click in the bottom cell. Now click Fill on the menu bar then series.

Microsoft Office... • Answered on Sep 21, 2015

how to remove the excel file security pass word

solution explain tel plz

Microsoft Office... • Answered on Mar 13, 2015

Insert a text box and drag to the size that you want the page to be.

Microsoft Office... • Answered on Sep 20, 2014

Should be with totals section

Microsoft Office... • Answered on Sep 20, 2014

how i connect one excel sheet to another excel

Microsoft Office... • Answered on Jul 01, 2014

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.

Microsoft Office... • Answered on Jun 20, 2014

If you want to delete the column:select column -> hit Ctrl -If you want to hide the column:select column -> Format -> Column -> Hide

Microsoft Office... • Answered on Oct 31, 2013

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.

Microsoft Office... • Answered on Nov 08, 2012

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.

Zulfikar Ali
[email protected]

Microsoft Office... • Answered on Nov 08, 2012

The formula in both versions is the same:


i.e. The below formula will increase its count by one if any of the 18 cells it's checking are equal to 1.

Microsoft Office... • Answered on Nov 08, 2012

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 Office... • Answered on Oct 23, 2012

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...

Microsoft Office... • Answered on May 17, 2012

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.

Microsoft Office... • Answered on Feb 12, 2012

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.

Microsoft Office... • Answered on Nov 30, 2011

Not finding what you are looking for?
Microsoft Office Excel 2003 for PC Logo

Popular Tags

120 questions posted

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts


Level 3 Expert

1997 Answers


Level 3 Expert

8092 Answers

Jax Planet
Jax Planet

Level 2 Expert

923 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

View Most Popular

Office Microsoft

  • Office Microsoft

Most Popular Question

ms office

  • Computers & Internet