(513) 874-3306
We fix and repair laptop motherboard no video, no...
Answer
what are the disadvantages?
Problem for Business and Productivity Software
Generic problem for all Business and Productivity Sof...
Excel Coordinates don't show up in For...
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?
=(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?
Comments:
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.
Solution #1
posted on Dec 28, 2007
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
Yes
No
This Problem Also Relates To:
HP HP Integrated Lights Out (;iLO) Advanced Pack 1 server license Upgrade Version (452141-B21)
Sony Media Software Pictures Sound Effects Series - Volumes 1 to 5 Volume License (SSDS2000)
Sony DRU842A Internal 20X DVD-ROM for PC
Sony Acid Music Studio 7 for PC (MSAMS7000)
Sony Acid Pro 6 Professional Music Workstation Full Version for PC
Sony ACID Music Studio 6 Full Version for PC
Apple iPlayMusic Beginner Guitar Lessons Full Version for Mac
Popular Solutions for Business and Productivity
Questions and Unsolved Problems for Business and Productivity
Answer
A Restaurant Pro Express employee (waiter) forgot to clock in for an entire shift. How do I add his...
(More)
Answer
we've just taken everything off our computer, are using an external hard drive and we are not able...
(More)
Answer
Created a new file for company B and all the information (customer names etc) transfered ok. The...
(More)
Answer
I have Windows XP, a HP C4240 All-in-one and Corel Wordperfect. I can't print Wordperfect documents....
(More)
Ask our Experts
Browse popular Problems
More Common Problems
Most Common Problems for:
For Business and Productivity...:
Related Products & Issues:
Top Business and Pro... Experts
Experience:
I have owned a computer networking sales and service company.
Ask Me
Top Computer & Laptop Repair
