Tip Printed from ExcelTip.com
Pasting From Multiple Copied Ranges in Excel 2007


To make the Clipboard Task Pane dialog box visible:

Select Home -> Clipboard -> right small arrow.
The Task Pane dialog box contains the copied ranges (up to 24) that have been kept in memory.