Hidden secrets in Excel Quick Access Toolbar Part 2

Have you ever encountered the situation like this: You want to copy and paste only the visible part of a range that contains hidden columns/rows, like the one below:

One work around is to go to Home->Editing->Find and Select->Go to special

Then choose “Visible cells only” from the window.

However this method involves a number of clicks and you have to spend a couple of seconds to locate the menu every time you perform the task. If you have a worksheet with many hidden rows/columns, it will be very tedious.

To improve on the efficiency of performing such task, we can make use of the Quick Access Toolbar and utilize “Select Visible Cells” command. Follow the steps below:

1. Click on the inverted triangle on the QAT and choose “More Commands”

2. In the customization window, choose all commands from the dropdown list

3. Scroll down to find the “Select Visible Cells” command and click on “Add” button to add the command to the QAT and make sure the command appears in the box on the right hand side. Click “OK”

Now go back to the worksheet and just click “Select Visible Cells” in the QAT for once after you select the range. You save all the time navigating through the menus and windows! If you are a fan of shortcut key, simply activate this feature using the combination “ALT+;”.

New! Comments

Have your say about what you just read! Leave me a comment in the box below.

Share this page:

What’s this?

Enjoy this page? Please pay it forward. Here’s how…

Would you prefer to share this page with others by linking to it?

Click on the HTML link code below.
Copy and paste it, adding a note of your own, into your blog, a Web page, forums, a blog comment, your Facebook account, or anywhere that someone would find this page valuable.

<a href=”https://www.advanced-excel.com/”>Advanced Excel – From a Business Perspective</a><a href=”https://www.advanced-excel.com/”>Advanced Excel – From a Business Perspective</a>

Excel Courses for Business Professionals

How to sleep and lose weight

Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation.

advanced-excel.com is in no way associated with Microsoft