Forum Discussion
Solved
Convert page/cell reference to Text
Hi Everyone! My first time here, and I searched and cannot locate an answer to my question. I am working with a multiple page spreadsheet that has references to previous pages. Example the last ...
Found the solution!
I selected the page and followed the instructions from #2 on. Worked like perfectly.
- Select the cells for which you want to convert formulas to values.
- Bring your mouse cursor over the outline of the selected cells. (You will see an icon of four arrows pointing in the four directions).
- Press the RIGHT button of your mouse.
- Click on Copy Here as Values only.
Thank you, my issue does not relate to pasting Values.
The spreadsheet is part of a Book of many Pages, where the cells in subsequent Pages are populated from the information from the previous Page.
The last Page of the Book contains Cells that are filled with references to previous Pages,
(ie: "=January!K16").
My task is to convert the references in the last Page to Values. I am searching for a method that would convert of the Cells on the Page, rather than copying and pasting the Value of one Cell.
Found the solution!
I selected the page and followed the instructions from #2 on. Worked like perfectly.
- Select the cells for which you want to convert formulas to values.
- Bring your mouse cursor over the outline of the selected cells. (You will see an icon of four arrows pointing in the four directions).
- Press the RIGHT button of your mouse.
- Click on Copy Here as Values only.