Use Hot Key Quick Select excel2007/2003 visible cells

Source: Internet
Author: User

After you subtotal the data in an Excel worksheet, often we just need to summarize the results without having to participate in the aggregated data, so you display the summarized results to level 2, hide the data that is involved in the totals, and then select and copy them. But when you paste them into another worksheet, you find that the data that was originally hidden from the participating totals is copied and displayed. What should I do about it?

To work around this problem, you can do the following things again:

1. To show the aggregated results to level 2;

2. For Excel2003, on the Edit menu, click Position, click Locate Criteria, select the Visible Cells Check button, and then click OK.

For Excel2007, click the Start tab, in the Edit group, click Find and select, click Position Criteria, select the Visible Cells Check button, and then click OK.

3. Copy and paste the selection into the new worksheet.

In fact, step 2 above can be replaced with a hotkey, that is, ALT +;(semicolon), because the hot key is to select only visible cells in the current range. While the function is the same, using hotkeys is much quicker than using commands.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.