Question about Microsoft Excel for PC

Ad

Jhgfjg

Posted on Oct 25, 2008

Ad

Hello

yes it is.

example

sheet1

A1 (50)

A2 (50)

sheet2

(A1)=

"=Sheet1!A2+Sheet1!A1" <-this is the actually code in sheet2 column A1

ok let me explain

in A1 and A2 in sheet1 you got 50 and 50 like numbers.

in A1 on Sheet2 you have = sheet1 a1 + sheet1 a2.

did you get it?

dont know else how I should explain it...

good luck

Posted on Oct 09, 2008

Ad

Hi,

a 6ya Technician can help you resolve that issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.

click here to Talk to a Technician (only for users in the US for now) and get all the help you need.

Goodluck!

Posted on Jan 02, 2017

first start excel and click on formula tab -->Calculation options -->Manual

Now open file, if asks for update formulae, say no.

Now select entire sheet, select formulas tab--> Error Checking -->Trace Error.

It will locate all error containing cells, now rectify the error save it reopen in excel to see if problem is solved.

Now open file, if asks for update formulae, say no.

Now select entire sheet, select formulas tab--> Error Checking -->Trace Error.

It will locate all error containing cells, now rectify the error save it reopen in excel to see if problem is solved.

Apr 12, 2017 | Microsoft Excel for PC

pen both the sheets in the same window as:-

1. View Tab-->New Window --> Arrange All --> tiled

2. Open first sheet in first window and second in second window

3. now create formula simply by clicking in corresponding sheets and selecting cells.

Alternatively you can use following format of addressing:-

1. SheetName!CellAddress (Same Workbook)

2. [WorkbookName]SheetName!CellAddress (Different Workbooks)

For more clarification please mail on ali_zulfikar@yahoo.com with screenshots.

1. View Tab-->New Window --> Arrange All --> tiled

2. Open first sheet in first window and second in second window

3. now create formula simply by clicking in corresponding sheets and selecting cells.

Alternatively you can use following format of addressing:-

1. SheetName!CellAddress (Same Workbook)

2. [WorkbookName]SheetName!CellAddress (Different Workbooks)

For more clarification please mail on ali_zulfikar@yahoo.com with screenshots.

Jul 16, 2014 | Microsoft Excel for PC

why not? however, you can also insert an apostrophe (') at the start of the equation before copying the entire formula so that the formula will be treated as a text thus preserving all cell references. dont forget to remove the apostrophes after you have pasted them though for the formulas to work again.

Jul 29, 2009 | Computers & Internet

=VLOOKUP(A2;Sheet1.$A$3:D27;2;0)

The cell I created this formula in was Sheet 3 Cell C9 - to show the different sheets

A2 is the cell I want to look up

Sheet1.A3:D27 is the range of cells that contains the data I want to return, The first column relates directly to cell C9 is Sheet 3. I locked the first cell in my range as I wanted to apply the same formula across other cells hence the $

2 is the number of the column that has the data I want to return, I had a choice in this formula of 4 columns

0 is the value to complete the formula

The cell I created this formula in was Sheet 3 Cell C9 - to show the different sheets

A2 is the cell I want to look up

Sheet1.A3:D27 is the range of cells that contains the data I want to return, The first column relates directly to cell C9 is Sheet 3. I locked the first cell in my range as I wanted to apply the same formula across other cells hence the $

2 is the number of the column that has the data I want to return, I had a choice in this formula of 4 columns

0 is the value to complete the formula

Feb 11, 2009 | Microsoft Excel for PC

type in "=" and then go to the cell in the 2nd sheet and click on the cell that contains the value you want carried to sheet 1. Then drag copy the forumula in sheet 1 to all the cells you want it to relate to. Now, if you place a value in e.g. A1 of sheet 2, then that same value will appear in A1 of sheet 1.

Good luck.

Good luck.

Sep 13, 2008 | Microsoft Computers & Internet

i want all excel formula

Jun 15, 2008 | Microsoft Computers & Internet

You can refer to cells that are on other worksheets by perpending the name of the worksheet followed by an exclamation point (**!**)
to the cell reference. In the following example, the AVERAGE worksheet
function calculates the average value for the range C1:C10 on the
worksheet named Marketing in the same workbook.

Refers to the worksheet named Marketing Refers to the range of cells between C1 and C10, inclusively

Refers to the worksheet named Marketing Refers to the range of cells between C1 and C10, inclusively

- Click the cell in which you want to enter the formula.
- In the formula bar (formula
bar: A bar at the top of the Excel window that you use to enter or edit
values or formulas in cells or charts. Displays the constant value or
formula stored in the active cell.)
, type
**=**(equal sign). - Click the tab for the worksheet to be referenced.
- Select the cell or range of cells to be referenced.

Jan 01, 2008 | Microsoft Office Standard for PC

Heyo. I have had this problem before too. This procedure prevents the cells that contain the formula from being edited.

Wayne

- Select the range of cells whose formulas you want to hide. You can also select the entire sheet.
- On the
**Format**menu, click**Cells**, and then click the**Protection**tab. - Select the
**Hidden**check box. - Click
**OK**. - On the
**Tools**menu, point to**Protection**, and then click**Protect Sheet**. - Make sure the
**Protect worksheet and contents of locked cells**check box is selected.

Wayne

Dec 28, 2007 | Computers & Internet

Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.

Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data

Select the entire data and do an auto filter

In column F filter the data by Duplicate and delete all these rows

What remains should be unique data

Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data

Select the entire data and do an auto filter

In column F filter the data by Duplicate and delete all these rows

What remains should be unique data

Dec 19, 2007 | Computers & Internet

Dear jois you can make a link from one sheet to other sheet by making a hyperlink. When you will click one cell in first sheet it would shift the sheet in the cell you will fix it.

You can follow this process:

You can follow this process:

- Select a cell that contains the external formula
- Highlight the File path and sheet name in the Formula bar, eg; 'L:\Daves\[Book2.xls]Sheet1'!
- Push Ctrl+C then push Enter.
- Select the range of cells you wish to change the reference in and go to Edit>Replace.
- Select in the Find what box and hold down the Backspace to ensure you do not have a space.
- Push Ctrl+V.
- Do the same in the Replace with box and then edit the file path to the new one needed.
- Click Replace All

Nov 29, 2007 | Microsoft Excel for PC

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

Jul 23, 2013 | Microsoft Excel for PC

186 people viewed this question

Usually answered in minutes!

×