Forum Discussion

ksmith's avatar
ksmith
Brass Contributor
Jun 14, 2020
Solved

Cannot select content of some cells from one worksheet to another with = formula

I have a accounting workbook for our household expenses with a worksheet for each month.  In the NEXT month, I use the = formula to select a cell from the previous month; i.e. In the opening debits c...
Formulas and Functions
  • wumolad's avatar
    wumolad
    Jun 24, 2020
    ksmith

    Good to hear the comment was helpful.

    Please mark as the solution to close the discussion.

    Cheers,
wumolad's avatar
wumolad
Iron Contributor
Jun 15, 2020

Hi ksmith 

 

Have you tried to manually type in something in the affected cell? It's possible the cell has been formatted as text or custom formatted?

 

Check the format cells to see if this is the case and then change to general or number.

 

Cheers

  • ksmith's avatar
    ksmith
    Brass Contributor
    Jun 23, 2020

    wumolad 

    When I have  the problem worksheet visible, I can select the problem cell (C3) and type into.  However, the problem is when I try to insert the equal = sign  formula in an adjacent cell (KS Debits) then switch back to select the problem cell C3, I cannot select C3.  I have to select an adjacent cell, then scroll up to C3.

    I have attached a png file below.

    • wumolad's avatar
      wumolad
      Iron Contributor
      Jun 23, 2020

      ksmith 

       

      Can you make a copy of the workbook and delete other information that are sensitive and send the sheets having the issue across, so we can go through.

       

      Cheers

      • ksmith's avatar
        ksmith
        Brass Contributor
        Jun 23, 2020

        wumolad

        Can try.  There are 113 worksheets; one for each month and the template which I copy.  I can delete all months except for the last  2 , and include the template (that's where the problem might originate). will do soon. O.K...in attached worksheet, June, July and Aug work o.k.  But if you try to use =G4 on template sheet, to O21 on August sheet, you cannot select O21.  

    • Bennadeau's avatar
      Bennadeau
      Iron Contributor
      Jun 23, 2020

      Hi ksmith,

      I had a similar issue a few years ago. Turns out it was a dual monitor / windows 10 / scale issue. Weird, I know.

      So, if you have dual (or triple or more) monitor, one test you can do is disconnect them all but one and see if you have the same issue. If it fixes it, then reconnect your monitors, right click on your desktop > display settings. Then ensure both monitors are set to the same scale. 

      It's a long shot and a PITA but this may be your issue.

       

       

      • ksmith's avatar
        ksmith
        Brass Contributor
        Jun 23, 2020
        Sorry..only using a laptop so that idea is out. Wtill have several of you guys working on it. Thanks
  • ksmith's avatar
    ksmith
    Brass Contributor
    Jun 20, 2020

    I can manually enter the number.  I have tried protect and un-protect but I don't really understand the instructions on how to un-protect.  If it is protected, it is the only one on the worksheet that is.

    • wumolad's avatar
      wumolad
      Iron Contributor
      Jun 22, 2020

      ksmith 

       

      You have to unlock the cell if it has been locked. Follow the information on the image below.

       

      Under home tab, go to format [in cells group] and select lock cell.

       

       

      Cheers

      • ksmith's avatar
        ksmith
        Brass Contributor
        Jun 22, 2020

        there is no "Unlock" option for this cell.  The worksheet is not protected so I don't know what's going on.  It's just that one cell on every worksheet I create with the COPY command from my master worksheet, which is not protected.

Resources