Lost data when saving excel as formatted text (.prn)

as i said printing only prints what's visible so if you squash up a column and the text is not wrapped then only the visible text is printed.try copying the data to a new workbook and open up the columns

I can't. The worksheet was given to me as protected and it won't let me select the data to copy to a new workbook. On another machine, the same worksheet has everything visible, but on my machine there is data missing. What could be the problem with my machine?