I have a worksheet which references other worksheets and formulas in all the cells which reference other worksheets. I would like this worksheet with its results to be standalone now. I know there is a command so I get only the hard numbers in the cells, not the formulas. Does anyone remember how to do this? Thanks!

Select all the cells, Copy, Paste Special, Values
If you have formatting you want to keep repeat this, but do:
Select all the cells, Copy, Paste Special, Formats

---

"In science it often happens that scientists say, 'You know that's a really good argument; my position is mistaken,' and then they would actually change their minds and you never hear that old view from them again. They really do it. It doesn't happen as often as it should, because scientists are human and change is sometimes painful. But it happens every day. I cannot recall the last time something like that happened in politics or religion." (1987) -- Carl Sagan

Thanks, davester!

Actually, that second item with the formats is only if you are pasting into a different location.

---

"In science it often happens that scientists say, 'You know that's a really good argument; my position is mistaken,' and then they would actually change their minds and you never hear that old view from them again. They really do it. It doesn't happen as often as it should, because scientists are human and change is sometimes painful. But it happens every day. I cannot recall the last time something like that happened in politics or religion." (1987) -- Carl Sagan