The one disappointment here is that the Windows Clipboard doesn’t offer a Paste All button. It also shows images, paragraphs from Word, and more. The Windows Clipboard isn’t limited to only Excel ranges. You can even see history of previous things copied to the clipboard. Press Win+V, and the range copied from the first computer is available on the second computer.
With Sync Across Devices, you can copy some cells from one computer and then immediately move to the other computer. You should enable Sync Across Devices on each computer and phone. You can also have a mobile phone where the Edge browser is signed into the same account. In order for the Sync Across Devices to work, you need to have multiple computers that are signed in with the same Windows account. In the Clipboard settings, turn on Clipboard History and Sync Across Devices, as shown in Figure 2. To enable them, go to Start, Settings, System, Clipboard. The amazing features of this clipboard are turned off by default.
Windows 10 (and now Windows 11) offers a new clipboard that you can display using the Win+V keyboard shortcut. The last option controls if the taskbar icon will display a status near the icon. Right-click this icon to open the Clipboard pane, to stop collecting, or to change options. Show Office Clipboard Icon on Taskbar will display a small clipboard icon in the Windows taskbar.Collect Without Showing Office Clipboard allows Excel to keep the clipboard history without the Clipboard pane taking up any screen space.Note that this setting isn’t turned on by default, so you’ll need to use the dialog launcher to display the Office Clipboard the first time. Show Office Clipboard When Ctrl+C Pressed Twice is an optional setting that gives you a faster way to open the Office Clipboard.Show Office Clipboard Automatically will make sure that the Clipboard pane appears every time Excel is opened.To clear all clipboard history, use the Clear All button near the top of the Clipboard pane.Īt the bottom of the Clipboard pane is an Options button, where you can change these settings: If you need to paste or clear a single item, hover over the item to reveal a drop-down menu with Paste or Delete. The paste happens starting from the oldest item to the newest, so the pasted data correctly shows Andy through Zeke in sequence.
Excel pastes all 24 names in a vertical list. Select A9 and click the Paste All button in the Clipboard pane.The list of Sam through Zeke is added to the top of the Clipboard pane. The list of Mike through Robert appears above Gary in the Clipboard pane. The newer copy of Gary through Lou is shown above Andy in the Clipboard pane. The Clipboard pane showed Andy through Flo. Here are the events that lead to Figure 1: By clicking on the Paste All button, the rectangular data was arranged into a single column. In Figure 1, the pane lists four separate Copy events. Once the Office Clipboard is visible, Excel will start collecting each item that’s copied or cut from Excel. If you drag the Clipboard title bar off the right side of the screen, you can dock the Clipboard pane on the right. Unlike most Excel task panes, the Clipboard pane appears on the left side of the screen. Click the dialog launcher in the lower-right corner of the Clipboard group to open the Office Clipboard task pane. The Clipboard group on the Home tab of the ribbon offers icons for Paste, Cut, Copy, and Format Painter.