Search : in
By :

Show cell heading instead of formula

Last answer on Sep 22, 2009 2:01:45 pm BST gvis, on Sep 22, 2009 6:38:36 am BST 
 Report this message to moderators

Hello,

I would like to help a visually challenged friend who extensively uses MS Excel.

There are different types of formulas in one sheet. He would like to see the content of the formula and not the formula itself. For example, in Column A1, it is basic pay, column B1 has HRA and column C1 has DA. Column D1 is total. A2, B2, C2 have corresponding figures while D2 gives the sum of A2, B2 and C2. Using the show formula function, he can see the formula. What he would like to see in D4 is something like this - <Sum of Basic, HRA, DA> He uses a screen reading software and finds it difficult to scroll through each cell to understand how the values are arrived at especially when different set of formulas are used in a sheet.

Can anyone please help?

Thanks in advance.

Configuration: Windows XP Internet Explorer 6.0

Best answers for « Show cell heading instead of formula » in :
Run macro automatically (Solved) Show
[Excel]changing cell formula to text Show [Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to extract this formula in cell A6 as a string of text? That is ... I want cell A6...
Excel – Formula for cell calculation Show Excel – Formula for cell calculation Issue Solution Note Issue Simple formula of =J3-SUM(L3:X3) BUT if J3 is empty then I want the formula to run as =C3-SUM(L3:X3) What is the proper formula to get the calculation to utilize J3 if...
Excel - Send value of cell to target ShowExcel - Send value of cell to target Issue Solution Note Issue Is it possible to send the value of a cell (copy and paste special) to another cell where the value would not be disturbed when the source value changes to '0'? My...
Text String count within a Cell ShowText String count within a Cell Issue Solution Note Issue I have number of records (see below) and want to know if I can use a function to count the number of records that contain a specific text string within each cell entry? e.g....
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Download Slide Show Movie Maker Show
Download USA Unlisted Cell Phone Numbers ShowHas you friend flown for America without telling you where he/she would settle? Don’t panic! USA Unlisted Cell Phone Numbers is a program which can help you. By using this program, you simply need to know his/her phone number in order to find...
Download Internet Cell Boost Show
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Structure of an email (Headers and bodies) ShowStructure of an email An email has three basic parts: The header, a set of lines containing information about the message's transportation, such as the sender's address, the recipient's address, or timestamps showing when the message was sent by...
Ask your question Reply

1

 Trowa, on Sep 22, 2009 2:01:45 pm BST

If you are trying to understand what a formula does, select the "extra" option from the top menus (6th option from the left). Then select the 13th option from the top (something like "check formula"). Lastly click on the 5th option from the top (something like "evaluate formula").
On the menu that appears, repeatly click on the "evaluate" button to see each step of the formula.
Use this on all the formula's you would like to understand better.

Hope this helps.

Best regards,
Trowa

   
Reply to Trowa
Ask your question Reply
They need your help