Home >Topics >excel >Why does Excel display all the content after copying and pasting data?

Why does Excel display all the content after copying and pasting data?

烟雨青岚
烟雨青岚Original
2020-06-22 10:36:4957170browse

Why does Excel display all the content after copying and pasting data?

# Why is the entire content displayed after copying and pasting data in Excel?

Cause: The filtered data cells were not positioned as "visible cells" before being copied.

Solution:

1. First filter the data in the excel table, for example, filter the number "1".

Why does Excel display all the content after copying and pasting data?

#2. Then select the filtered cells and click the "Locate" option under the "Find" column in the toolbar.

Why does Excel display all the content after copying and pasting data?

3. Then select "Visible Cells" in the "Position" dialog box that opens, and click Position.

Why does Excel display all the content after copying and pasting data?

#4. Locate the visible cell and press "Ctrl C" to copy.

Why does Excel display all the content after copying and pasting data?

#5. Then right-click the cell where you want to paste, and click Paste as Value.

Why does Excel display all the content after copying and pasting data?

#6. Now you can paste the copied filtered data into a blank cell.

Why does Excel display all the content after copying and pasting data?

Recommended tutorial: "excel tutorial"

The above is the detailed content of Why does Excel display all the content after copying and pasting data?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn