+ Reply to Thread
Results 1 to 9 of 9

Viewing formula in a cell when I select it

  1. #1
    Registered User
    Join Date
    09-09-2014
    Location
    Cyprus
    MS-Off Ver
    2013
    Posts
    5

    Viewing formula in a cell when I select it

    Hi, recently when I'm using my excel sheet (2013) when I click on the cell it then shows the formula and clicks inside it. My 'show formula' is not selected, and it's causing some bother by selecting and adding cells into the formula. I'm only clicking once with my mouse, but notice that this normally happens if you click twice. Is this an issue with my mouse or is there a property that I need to change in my cells? Will be grateful for any help, haven't ever come across this before

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13
    Posts
    963

    Re: Viewing formula in a cell when I select it

    Please post the file, Thanks
    Remember you are unique, like everyone else

  3. #3
    Registered User
    Join Date
    09-09-2014
    Location
    Cyprus
    MS-Off Ver
    2013
    Posts
    5

    Re: Viewing formula in a cell when I select it

    Hi there,

    Thanks for your quick response - wasn't sure how to post the file so here is the link for google drive where you can download it from: https://drive.google.com/file/d/0B4V...it?usp=sharing

    Thanks!

  4. #4
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13
    Posts
    963

    Re: Viewing formula in a cell when I select it

    Thanks but I need it in xls or xlsx format.

    To post go to 'Go Advanced' >> 'Manage Attachments' >> 'Add File' etc ...

  5. #5
    Registered User
    Join Date
    09-09-2014
    Location
    Cyprus
    MS-Off Ver
    2013
    Posts
    5

    Re: Viewing formula in a cell when I select it

    Hi, Hope this works
    Attached Files Attached Files

  6. #6
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13
    Posts
    963

    Re: Viewing formula in a cell when I select it

    Thanks, that's done it.

    OK, so in order to see all the Formulas on the worksheet, I need to go to the Formulas tab on the Ribbon & select 'Show Formulas'.

    Otherwise normally, if I want to see what is inside a Cell, a Value OR a Formula, I can just select that Cell.

    If I click again OR double click, I will see the Formula in the Cell.

    I've done this on your worksheet and it works OK.

    Can you describe exactly what's wrong in the worksheets behaviour?

  7. #7
    Registered User
    Join Date
    09-09-2014
    Location
    Cyprus
    MS-Off Ver
    2013
    Posts
    5

    Re: Viewing formula in a cell when I select it

    Hi, thanks for your reply! My problem is that it is selecting the formula with one mouse click (when we only want to select the value) which I guess from your reply means that it is an issue with the mouse rather than the excel, seeing as it should only select the formula if it is clicked on twice?

  8. #8
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13
    Posts
    963

    Re: Viewing formula in a cell when I select it

    Possibly, have you got your mouse setup to your normal Left Click/Right Click settings?

    Try Both Right & Left Click to see.

  9. #9
    Registered User
    Join Date
    09-09-2014
    Location
    Cyprus
    MS-Off Ver
    2013
    Posts
    5

    Re: Viewing formula in a cell when I select it

    Hi there, the mouse clicks were set correctly but I guess it must be double clicking by itself - time for a change of mouse!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with a formula to create a viewing heirarchy please
    By walkitoff in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2013, 10:50 AM
  2. Formula to select specific numbers from a cell and input into another cell
    By highrankednoob in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-12-2013, 06:28 PM
  3. Replies: 10
    Last Post: 07-08-2013, 01:47 PM
  4. Select a cell with conditional formating having a formula for a cell address?
    By EXCELOST in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-03-2010, 06:19 AM
  5. Condition Formatting - Viewing CF formula at each cell
    By rwgrietveld in forum Excel General
    Replies: 4
    Last Post: 01-06-2010, 03:33 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1