All articles with 'Hidden' Tag

Copy Paste Visible Cells only (Two more ways to do it)

Published on Aug 28, 2017 in Excel Howtos, Keyboard Shortcuts, Learn Excel
Copy Paste Visible Cells only (Two more ways to do it)

Last week, we talked about how to copy and paste visible cells alone (ie exclude any filtered rows or hidden columns etc.) In the comments section many of you suggested two more ways to deal with this annoying problem. Let’s take a look them.

Continue »

How to find what is in the hidden cells? [quick tip]

Published on Dec 11, 2013 in Excel Howtos
How to find what is in the hidden cells? [quick tip]

You have been there. You are looking at a complex workbook with some hidden rows /columns. You want to know what is in that hidden cells. Alas, the worksheet is protected.

It is like the special coffee machine on top floor reserved for senior executives. You know it is there, but you cannot get to it. Now what?!?

Simple. Follow this process.

(I am talking about hidden cells, not the coffee machine.)

Continue »

Worksheet Properties via a Menu

Published on Jan 25, 2011 in Excel Howtos, hacks, Huis, Posts by Hui
Worksheet Properties via a Menu

The Properties button on the Developer Tab in Excel 2007/10 can be used to access a number of Worksheet properties normally only available through VBA and even a few which aren’t available through VBA.
Lets take them for a spin.

Continue »

The Selection Pane

Published on Dec 2, 2010 in Excel Howtos, Huis, Learn Excel, Posts by Hui
The Selection Pane

New to Excel 2007 is the Picture Selection Pane.

This is a neat little tool which allows quick sorting and editing of the visibility of pictures and other objects on a worksheet.

Continue »