How To Copy A Table In Excel

Table of contents:

How To Copy A Table In Excel
How To Copy A Table In Excel

Video: How To Copy A Table In Excel

Video: How To Copy A Table In Excel
Video: Excel Copy Paste Tricks 2024, April
Anonim

The operation of copying an Excel table consists of three stages: selecting the table, copying it, and pasting it into a text editor document. There are three ways to perform these actions: via the context menu, using the keyboard, or via the toolbar.

How to copy a table in Excel
How to copy a table in Excel

Instructions

Step 1

Select the Excel table. To do this, click once between the designations of columns and rows, or place the cursor on the first top cell and, while holding down the left mouse button, move the cursor down and along the entire table, thus the cells will be highlighted.

Step 2

To copy an Excel table: position the cursor on the highlighted table. Click the right mouse button. In the context menu that appears, select the "copy" command or press the Ctrl + insert keys on the keyboard at the same time. To copy a table using the main menu on the toolbar, call the "edit" command and click "copy". In this case, the boundaries of the copied tabular section take the form of a running snake. After you insert the table in the right place, the snake does not disappear, the program makes it possible to insert the table as many times as needed.

Step 3

Open the text document where you are going to paste the copied Excel spreadsheet.

Step 4

Place your mouse cursor where the table should be positioned in your document.

Step 5

Press the right mouse button and select the "paste" command in the appeared context menu. Or insert using the Shift + insert keys. You can also do this through the main menu "Edit", activate the "paste" command.

Step 6

If you are working in a text editor, it will be easier to create a table in Excel and then copy it into the document you want. Moreover, Excel allows you to make calculations without a calculator or quickly and easily copy cells and their contents.

Recommended: