MS Excel: Copy & Paste Objects Shortcuts Windows, Mac, Web
- Fakhriddinbek
- May 7
- 2 min read
Copying and pasting objects such as charts, shapes, images, or SmartArt is a frequent task in Excel—especially when designing dashboards, reports, or templates. While the mouse works well, keyboard shortcuts offer faster, more precise control when duplicating or moving these objects.
This article explores the essential Copy & Paste Objects shortcuts in Excel 2021 across Windows, Mac, and Excel for the Web.
Why Learn Copy & Paste Objects Shortcuts?
Using keyboard shortcuts to copy and paste objects allows you to:
Maintain alignment and consistency across sheets.
Speed up repetitive formatting and layout tasks.
Position objects more accurately without relying on the mouse.
Copy & Paste Objects Shortcuts Table
Action | Windows Shortcut | Mac Shortcut | Web Excel Shortcut |
Copy selected object | Ctrl + C | ⌘ + C | Ctrl + C |
Cut selected object | Ctrl + X | ⌘ + X | Ctrl + X |
Paste copied/cut object | Ctrl + V | ⌘ + V | Ctrl + V |
Duplicate selected object in place | Ctrl + D | ⌘ + D | Ctrl + D |
Open Paste Special dialog | Ctrl + Alt + V | ⌘ + Ctrl + V | Ctrl + Alt + V |
Paste formatting only | Ctrl + Alt + V → T | ⌘ + Ctrl + V → T | Ctrl + Alt + V → T |
Paste as image | Alt + H + V + I | N/A | Alt + H + V + I |
Paste link | Ctrl + Alt + V → N | ⌘ + Ctrl + V → N | Ctrl + Alt + V → N |
Paste values only | Ctrl + Alt + V → V | ⌘ + Ctrl + V → V | Ctrl + Alt + V → V |
Paste formulas only | Ctrl + Alt + V → F | ⌘ + Ctrl + V → F | Ctrl + Alt + V → F |
Paste transpose | Ctrl + Alt + V → E | ⌘ + Ctrl + V → E | Ctrl + Alt + V → E |
Copy formatting (Format Painter) | Ctrl + Shift + C | ⌘ + Shift + C | Ctrl + Shift + C |
Paste formatting (Format Painter) | Ctrl + Shift + V | ⌘ + Shift + V | Ctrl + Shift + V |
Use Ctrl + D for quick duplication of shapes or charts on the same worksheet without overwriting clipboard contents.
Example Use Case
Suppose you've created a custom chart or shape for a dashboard. You want to replicate it across multiple sheets or regions:
Select the chart or shape.
Press Ctrl + C (Copy).
Navigate to the desired location.
Press Ctrl + V (Paste), or Ctrl + D to duplicate in place.
Conclusion
Copying and pasting objects efficiently in Excel goes beyond simple duplication—it's about controlling format, placement, and consistency with precision. These shortcuts help you streamline visual reporting and reduce dependency on the ribbon and mouse clicks. Master them to enhance your design and productivity in Excel.
コメント