Yes. You can press CTRL-A to select all cells from the worksheet. Then
CTRL-C to copy, then editpaste specialvalues. The formats will stay the
same but the formulas will be replaced with values.
"kincaid05" wrote
in message ...
I'm trying to convert a spreadsheet so that I can import it into a SQL
server. It has alot of extra columns that were only used to make
calculations on the sheet. Is there anyway I can finalize a sheet,
deleteing all the formulas and leaving only the values that were
calculated for that cell.
The problem is as I start deleting columns I start getting #REF's
popping up cause data is missing. Any help or suggestions are
apreciated, Thanks.
--
kincaid05
------------------------------------------------------------------------
kincaid05's Profile:
http://www.excelforum.com/member.php...o&userid=25232
View this thread: http://www.excelforum.com/showthread...hreadid=387197