joy,

Excel 2007 has some 16,000 columns, I think. But it's pretty unusual to need more than 256.

As for replacing formulas with the current results, just do this. Select the cells. Copy.
Keep the selection exactly where it is. Edit - Paste Special - Values.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"newyorkjoy" wrote in message
...
I will need much more than 256 columns on my spreadsheet. How do I go about
that? I guess I would need separate worksheets, but please explain how to
link it, etc.
a second question is: I am replacing a formula with its result. I have a
column of more than 20,000 rows. How do I do it going down the column without
doing each one individually?

--
newyorkjoy
thanks for the help!