I have a spreadsheet that I wish to hide a range of cells - I can see how to hide full spreadsheets and workbooks but dont know how do you hide a range of cells.
Please can someone explain how?
Thanks.
I have a spreadsheet that I wish to hide a range of cells - I can see how to hide full spreadsheets and workbooks but dont know how do you hide a range of cells.
Please can someone explain how?
Thanks.
You can 'hide' Rows and Columns. You cannot hide individual cells.
You can 'hide' the contents of cells by following the instruction in Excel HELP:
-------------------------------------------
Hide or display cell values
If you want to use values without displaying them on the worksheet , you can hide them. When you hide a value in a cell, the cell appears blank. The formula bar, however, still contains the value.
Select the cell or range of cells that contains values that you want to hide or values that are hidden.
On the Format menu, click Cells.
On the Number tab, do one of the following:
To hide all values, click Custom in the Category list, select the existing codes in the Type box, and then type ;;; (three semicolons) in the Type box.
Important The selected cells appear blank on the worksheet, but a value appears in the formula bar if you click one of the cells.
To display hidden values, click General in the Category list to apply the default number format, or click the appropriate date, time, or number format.
--------------------------------------------
HTH
Bruce
Bruce
The older I get, the better I used to be.
USA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks