Forum Discussion

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
Jun 24, 2020
ksmith

Good to hear the comment was helpful.

Please mark as the solution to close the discussion.

Cheers,

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

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
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
  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.
- ksmith
  Brass Contributor
  Jun 22, 2020
  
  Your reply...."Under home tab, go to format [in cells group] and select lock cell". that did not work at all. Still cannot access this cell.