Question about Computers & Internet

1 Answer

Excel Coordinates don't show up in Formula Bar

I've just started having a problem with my Excel that is affecting old and new documents. Instead of seeing A1, B4, C5 in the formula bar; I can only see a formula that looks like the following:

=(RC[-1]*RC[-29])

When I double click on the cell, the other cells that comprise the formula are highlighted. I only see numbers on both axes instead of letters on the X axis and numbers on the Y axis.

Can you help?

Posted by on

  • sfrose Jan 02, 2008

    I tried as you suggested and no luck. It's happening on new documents as well as old. I don't have the Excel program set to default to Protect Sheet.

    The strangest part is that I no longer see letters on the Y-axis. That's why the coordinates aren't clear. I can go back and double click on a cell to see which cells the formula refers to- it highlights them. But otherwise, it's impossible for me to tell.

    Still confused.


×

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 53 Answers

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

  1. Select the range of cells whose formulas you want to hide. You can also select the entire sheet.
  2. On the Format menu, click Cells, and then click the Protection tab.
  3. Select the Hidden check box.
  4. Click OK.
  5. On the Tools menu, point to Protection, and then click Protect Sheet.
  6. Make sure the Protect worksheet and contents of locked cells check box is selected.
Good Luck!
Wayne

Posted on Dec 28, 2007

Ad

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 there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How do you subtract on Excel


EXCEL view the operation as a function fX and you enter it like this: =MINUS(H21,H22) This will show up in the cell and on the function bar above the column letters. The cell number would have a value in it. In this example H21 would have the value 10,and H22 would have the value 5. The formula would reside say in H23 and would show the result of the operation as 5.
10
5
5 (Formula in cell is as shown above)

Sep 19, 2017 | Excel Computers & Internet

1 Answer

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

Mar 27, 2017 | Microsoft Office Excel 2003 for PC

1 Answer

Problem was found in Micorsoft excel 2003. When I copy the formula from one (original) cell to another (new) cell, the formula in the new cell has updated but the value show on the new cell was the...


Once you have copy the cell from where the formula cam from, on the destination cell,
go to
1. Edit
2. Paste Special
3. Formula.
4. Press Enter

This should resolve your problem. Regards.

Aug 11, 2010 | Microsoft Office Excel 2003 for PC

1 Answer

MS excel issue


Using a time format for the data cells and data that looks like 12:00:10 AM the result you want is displayed no matter which formula is used. If the date portion of the data cell is not deleted then the result is 00:00:00. Delete the date portion of your data cells to get the result you want. (For example: When I enter 10 into a cell that is formated for time xx:xx:xx it shows 1/11/1904 12:00:00 AM in the formula bar and 00:00:00 in the cell. When I delete 1/11/1904 in the formula bar and show only the 12:00:10 the cell shows 00:00:10. Then it makes no difference which formula you use.)

Sep 19, 2009 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...

4 Answers

Ms-office


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.

Jul 08, 2009 | Microsoft Office Excel 2003 for PC

2 Answers

Excel 2007


  1. Select all cells (either press Ctrl+A or click on the small upper left square on the edge of the worksheet)
  2. In the menu bar, go to Format - Cells
  3. In the popup menu that opens, click on the Protection tab (it should be the last one on the menu)
  4. Deselect the small box tagged Locked
  5. Click on OK. Now all your cells can be overwritten, regardless the protection status of the worksheet.
  6. Select only the cells containing formulas that you want to hide (If you need to perform multiple selection, you can press and hold down the Ctrl key, while clicking on each cell you want to select)
  7. In the menu bar, go to Format - Cells
  8. In the popup menu that opens, click on the Protection tab
  9. Tick the small box tagged Hidden and the Locked box as well. If you don’t tick the Locked box, other users of your worksheet would be able to overwrite the formula cells, without even knowing that they contain formulas (as they become invisible following this operation).
  10. Click on OK
  11. In the menu bar, go to Tools - Protection - Protect Sheet
  12. If you want, you can input a password for unlocking the worksheet. This will prevent others from unlocking it. If you don’t want to do that, leave the password field blank and press OK.
  13. Now click on one of your cells containing formulas and look at the formula bar. It should be empty, although the formula is still there. The cell would remain locked, but it would be automatically updated when changing the content of its precedents relating to the contained formula.

Jun 25, 2009 | Computers & Internet

2 Answers

When I enter a formula the cell displays the formula and not the result. For instance, I type: =left(L27,13) Instead of showing me the 13 leftmost characters in cell L27, it shows ''=left(L27,13)''. Any...


You can change this under the Excel, options menu. Select the advanced option and uncheck the option to "Show Formulas in cells instead of their calculated value", or you can jjst press Ctrl + `
This will either turn on or off the show formula option.

Apr 27, 2009 | Microsoft Excel for PC

2 Answers

FORMULA PROBLEM IN MS EXCEL


The cells you are trying to sum are probably text and not numeric values. Format them as number or convert them to numbers.

Apr 18, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Finding the correct row num


You would have to combine the use of 2 functions. The Address and Match funbctions.
Lets say the number you want the address of is located in cell F1 and you have 2 columns of numbers. One colum in Column A and the other in column B. I will give you 2 formulas. The 1st one will return just the row number. The 2nd one will return the cell address.

Option 1: Lets say you just want to know the row reference of the number in cell F1. Place this formula in cell D1. =MATCH(F1,A1:A20)
If you have another column ytou want the row number of, place the formula in lets say cell D2 and change the column references from 'A' to 'B'.

Option 2: If you want the cell reference, place this formula in cell D1 and D2 instead of the firt formula.
=ADDRESS(MATCH(F1,A1:A20,0),1,1,TRUE)
And just like the first option, for the 2nd column, put the formula in D2 and change the column reference 'A' to 'B'.

Feb 17, 2009 | 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 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

567 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

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

Answer questions

Manuals & User Guides

Loading...