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/169543-hiding-cells.html)

swiv

hiding cells
 
When i select a column and then select "Hide" in the window toobar, the
entire workbook is hidden.

I only want to hide the specifiic cell, how do I accomplish this?

Swiv

Carim

hiding cells
 
Hi,

Use Format Cells Custom ;;;

HTH

dartanion

hiding cells
 
Are you tring to hide a column or a single cell? If its column, then its
Format Column, Hide. If its a single cell then I believe you can only hide
the contents of the cell and not the cell itself

"swiv" wrote:

When i select a column and then select "Hide" in the window toobar, the
entire workbook is hidden.

I only want to hide the specifiic cell, how do I accomplish this?

Swiv


Gord Dibben

hiding cells
 
Wrong menu. WindowHide hides the worksheet.

Select a column and FormatColumnHide.

Same for a row.

Note: you can't hide a single cell, just hide the contents of that cell by
Custom Format of ;;;


Gord Dibben MS Excel MVP

On Thu, 13 Dec 2007 06:17:01 -0800, swiv wrote:

When i select a column and then select "Hide" in the window toobar, the
entire workbook is hidden.

I only want to hide the specifiic cell, how do I accomplish this?

Swiv




All times are GMT +1. The time now is 10:46 AM.

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