This tool selects all visible cells of a selected range or the entire active sheet. If no range is selected, the entire worksheet becomes the work area.
The advantage of using this useful tool is the fact that we can
easily detect hidden cells -although it does not select them, it
does leave a trace in the form of a line.
Look at the row numbers in this example. You will see that rows 9-15 are hidden, but a trace can be seen (a non-selected line).
Tools for Excel Tables Secure Payment Options
Special! Free Choice of Complete Excel Training Course or Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
See Also: Excel Add-ins Index or, All Software
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft