Copying a worksheet in Excel 2003 allows you to paste the information into another spreadsheet, saving you the time it would take to retype everything. Follow these steps.
Highlight the entire worksheet or those cells with text in them. To highlight the entire worksheet quickly, press "Ctrl + A." For individual cells, hold down the Ctrl key and click on each cell or drag the mouse across a group of cells.
Step3
To copy the selection, press "Ctrl + C." Or you can click on the “Edit” button in the top toolbar and select "Copy" from the list of options.
Step4
Paste into a new worksheet.
Tips & Warnings
When using the Ctrl + C copy method, there must be no empty cells among the cells you wish to copy.