Replacing Formulas

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I am redoing a spreadsheet with several pages. In each page the cells
refer to a sheet that contains a master list of items. THus in the
cells it shows the item but really is a formula for the item to be
retrieved from the master list. I would like to delete the master
list. My question is: How do I get the items on each sheet to not
become blank when I do so? Do I have to retype the items or is there
some way of eliminating the formula and replacing it with the item
name?

I hope I have made myself clear. Thanks for any help.

Bob
 
Maybe try a copy > paste special > values "in-place" ?
This will convert the formulas to values

Let's say col A is one column which you want to convert all formulas therein
to values

Right-click on col A > Copy
Right-click again on col A > Paste special > Values > OK
 
Back
Top