ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hiding Cells (https://www.excelbanter.com/excel-discussion-misc-queries/94977-hiding-cells.html)

Chris

Hiding Cells
 
I want to hide a selected range of cells from view without using the Hide
Columns or Hide Rows commands. Could someone please tell me how to do this.
Thank you in advance.

Marcelo

Hiding Cells
 
I am afraid you can't,




"Chris" escreveu:

I want to hide a selected range of cells from view without using the Hide
Columns or Hide Rows commands. Could someone please tell me how to do this.
Thank you in advance.


CLR

Hiding Cells
 
If by "hide" you mean simply make them "not so visible", you can always set
the Row Height of those rows to something like .01

Vaya con Dios,
Chuck, CABGx3



"Chris" wrote:

I want to hide a selected range of cells from view without using the Hide
Columns or Hide Rows commands. Could someone please tell me how to do this.
Thank you in advance.


Chris

Hiding Cells
 
Thanks, I kind of figured it would be this way.

"CLR" wrote:

If by "hide" you mean simply make them "not so visible", you can always set
the Row Height of those rows to something like .01

Vaya con Dios,
Chuck, CABGx3



"Chris" wrote:

I want to hide a selected range of cells from view without using the Hide
Columns or Hide Rows commands. Could someone please tell me how to do this.
Thank you in advance.


CLR

Hiding Cells
 
You're welcome Chris, and remember, you can also just change the font color
to the same as the background color and the viewer sees it as a blank
cell.......

Vaya con Dios,
Chuck, CABGx3



"Chris" wrote:

Thanks, I kind of figured it would be this way.

"CLR" wrote:

If by "hide" you mean simply make them "not so visible", you can always set
the Row Height of those rows to something like .01

Vaya con Dios,
Chuck, CABGx3



"Chris" wrote:

I want to hide a selected range of cells from view without using the Hide
Columns or Hide Rows commands. Could someone please tell me how to do this.
Thank you in advance.


David Biddulph

Hiding Cells
 
"Chris" wrote in message
...
I want to hide a selected range of cells from view without using the Hide
Columns or Hide Rows commands. Could someone please tell me how to do
this.
Thank you in advance.


Data/ Filter?
--
David Biddulph




All times are GMT +1. The time now is 10:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com