Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to automatically copy a cell to clipboard with single click in Excel?

Normally, when copying a cell to clipboard, you need to select the cell firstly, and then press the Ctrl + C key to copy it. How to automatically copy a cell by just clicking on it without pressing the hotkeys? Method in this article can help you.

Automatically copy a cell to clipboard by clicking with VBA code


Easily copy cells or multiple ranges with row height and column width in Excel

Kutools for Excel's Copy Multiple Range utility can easily copy cell data or multiple ranges with row height and column width in Excel. See screenshot below:

Kutools for Excel includes more than 300 handy Excel tools. Free to try with no limitation in 60 days. Download the free trial now


Automatically copy a cell to clipboard by clicking with VBA code


The following VBA code can help you copy a cell to the clipboard by just clicking it in Excel. Please do as follows.

1. Open the worksheet you want to make cells copied to clipboard automatically, right click the sheet tab and then select View Code from the right-clicking menu. See screenshot:

2. In the opening Microsoft Visual Basic for Applications window, please copy the VBA code into the Code window.

VBA code: Automatically copy a cell to clipboard by clicking

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Not Intersect(Target, Range("A1:A9")) Is Nothing Then
        Target.Copy
    End If
End Sub

Note: In the code, A1:A9 is the cells you will copy to clipboard automatically. Please change it based on your need.

3. Press the Alt + Q keys to close the Microsoft Visual Basic for Applications window.

When clicking on any cell of range A1:A9, the cell will be copied automatically to the clipboard as below screenshot shown.

And then, you can select a destination cell and press Enter key to paste the copied contents.


Related articles:



Recommended Productivity Tools

Office Tab

gold star1 Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 300 New Features for Excel, Make Excel Much Easy and Powerful:

  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

Screen shot of Kutools for Excel

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Felipe Moretti · 7 months ago
    Muito obrigado!
    Trabalhei por alguns anos no ctrl C crtl V de uma mesma planilha de dados para o sistema que eu uso no trabalho... essa simples ação de já selecionar copiando me tirou um "fardo" enorme das atividades diárias!
    Deus abençoe!