Copying data and images in spreadsheetsAdded by IBM on December 11, 2013 | Version 1 (Original)
|You can use keyboard shortcut keys in all browsers or menu item only in IE browser to cut, copy, and paste data and images within a spreadsheet, between spreadsheets, or between a spreadsheet and an external application.
- Select the range that you want to cut or copy.
Tip: If the range that you select contains an image or hidden data, they will not be copied.
- Press Ctrl+X to cut, or Ctrl+C to copy.
- Click the location where you want to paste the data.
- Press Ctrl+V to paste.
Within a spreadsheet, you can use Ctrl+A to copy an entire sheet of selected data, including styles and hidden data. However, styles and hidden data cannot be pasted to another spreadsheet or external application. Images in the spreadsheet cannot be pasted to external application.
Parent topic: Managing data ranges