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


www.google.com

Microsoft Office... | Answered on Oct 23, 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.
Thanks

Zulfikar Ali
[email protected]
09899780221

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


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)

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

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

Ekse

Level 3 Expert

13434 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18429 Answers

Alun Cox

Level 3 Expert

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