Forum Discussion
Convert page/cell reference to Text
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.
ArthurJohnston The title of your posting suggests you want to copy and paste values. This will remove the formula like =January!K16 and keep whatever the result of the formula was.
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.