Printing, Copying, and Exporting Worksheet Data

Worksheet data can be printed, copied to the Windows clipboard, and exported to an external file in the same way that graphs can be. Right-click on a worksheet to bring up a context menu with these commands exposed. These tasks can also be performed via the main menu: printing can be performed through the File | Print menu, copying can be performed through the Edit | Copy menu, and exporting can be performed through the Data | Export menu (so long as the currently selected or active window contains a worksheet). If a block of cells is highlighted when printing, copying, and exporting is invoked, only that block will be acted upon..

Available export formats include text files with either tab-separated values (.txt) or comma-separated values (.csv), Excel spreadsheets (.xls), html files (.htm), and xml files (.xml). Column titles are exported along with data except when exporting a region of the worksheet (by first highlighting a block of cells). To export the entire worksheet without column titles use Edit | Select all before exporting.