Question about Microsoft Business & Productivity Software

1 Answer

Linking multiple formulas

How do I link multiple cells in different worksheets to autosum in the master sheet, so if I populate any sheet, it automatically shows on the main one?

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

I want all excel formula

Posted on Dec 30, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert 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 repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

I get an error when I tally cells that have errors because of dividing empty cell by empty cell.


Hi I dont really have much to do with Excel as I essentially build and repair and install, gosh I still type with two fingers!! Now below I have provided a link to Microsoft . Ways to count values in worksheets etc. If the problem persists try to update Office with what ever sercice packs are required and see if this helps. the link is http://office.microsoft.com/en-au/excel-help/ways-to-count-values-in-a-worksheet-HA010287849.aspx and I do hope it helps.
Cheers

Oct 28, 2011 | Microsoft Excel for PC

1 Answer

How do I add a number from one work sheet to another in excel ?


You can access numbers from another worksheet by using the formula (=SheetName!P1)
That would access cell P1 on the worksheet called "SheetName"

Jan 12, 2009 | Microsoft Office Standard for PC

1 Answer

Disable formulas with in a work sheet of Microsoft exl


  1. Select the cells with the formulas you want to disable.
  2. You can now either hide the formula by pressing CTRL and ` at the same time, or you can delete the formula by pressing the delet key on your keyboard.
Here's an easy way to select multiple formulas:
  1. Do one of the following:
  2. On the Edit menu, click Go To.
  3. Click Special.
  4. Click Formulas, and then select the check box next to the type of data you want to select.

Jul 23, 2008 | Microsoft Business & Productivity Software

1 Answer

Reference other worksheet in excel


eg if i want to add to numbers
in sheet 1 i have the value 20 in cell B3
in sheet 2 i have the value 10 in cell B4

thus the formula would be:

=sheet1!B3+sheet2!B4

Mar 13, 2008 | Microsoft Excel for PC

2 Answers

Unsure of correct formula


You can add a reference from the worksheet 1 to all other worksheets

Is it OK?

Mar 08, 2008 | Microsoft Excel for PC

1 Answer

Exel 2003


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.

default.aspx?assetid=za010939481033 Refers to the worksheet named Marketing default.aspx?assetid=za010939491033 Refers to the range of cells between C1 and C10, inclusively
  1. Click the cell in which you want to enter the formula.
  2. 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.) default.aspx?assetid=za060515351033, type = (equal sign).
  3. Click the tab for the worksheet to be referenced.
  4. Select the cell or range of cells to be referenced.

Jan 01, 2008 | Microsoft Office Standard for PC

1 Answer

Hi friends


Have all worksheets open including the one that is to be the tally sheet.
On the tally sheet, select a cell that you want to link to one of the other sheets and press the equals signto begin the cell formula. Without pressing the enter key, click on the cell in the other worksheet that you want to show up in your tally sheet.
Press enter to complete. This will link that cell in the two worksheets together as long as the spreadsheets remain stored in the same places.

Dec 24, 2007 | Microsoft Excel for PC

1 Answer

Microsoft Excel


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:

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

Nov 29, 2007 | Microsoft Excel for PC

2 Answers

Budgets in excel


Dear Madiha35,

 

I would recommend the use of the Table Function in Excel.

 

Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.

 

Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.

 

Excel 2007 had a budget format workbook

New workbook, Select Budgets in the last hand navigation, Select Personal Budget.

 

Step 1:  Enter your data into the worksheet.

 

Step 2:  Create Table

             Highlight the relevant data

             On the insert tab, click on Table

             

Step 3:  Verify Table range is correct, Click OK

 

Step 4:  Select the cell you where you wish to Sum Data.

         Click on Autosum.

 

Step 5:  To Insert new data

         Click on the sum row in the table, (Not the entire worksheet row)

         Right click, Insert, Insert Table rows from above

 

Step 6:  Enter new data in row

 

Step 7:  Data is automatically calculated in formula.

Oct 22, 2007 | Business & Productivity Software

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

102 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18330 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...