To copy the entire worksheet, click the box at the top left-hand corner of
the worksheet, where the column and row labels intersect. This will select
the entire worksheet. The copy, paste special and select "values" in the
pop-up. You can use the mouse by right clicking with the mouse somewhere in
the worksheet cells.

I find some reports downloaded from another program have hidden rows and/or
columns. If this is true in your case and you want to easily unhide the rows
and columns, while the entire worksheet is selected, press "CTRL (" and "CTRL
)"

"Viktoras" wrote:

I have exported details from sage program to exel and I can see all
information (names.numbers) in exel sheet, but actualy there is only formulas
in the cells and then I try to copy information I get only hieroglyphs, how
can I change thouse formulas into values ?