Tip Printed from ExcelTip.com

---

Pasting Multiple Copied Ranges Using the Clipboard


In Excel 2000, the Clipboard holds up to 12 copied ranges.

To make the Clipboard toolbar visible:
Press Ctrl+C+C
OR
From the View menu, select Toolbars and then Clipboard.

In Excel 2002 and Excel 2003, use the keyboard shortcut Ctrl+C+C to open the Task Pane dialog box, which contains the copied ranges (up to 24) that have been saved to memory.