hiding partial rows &/or columns

Folks, i have been trawling through the forum looking for hints tips and methods to be able to this.

I have a drawing in excel, and depending on what options are selected, component parts are added or removed from the drawing. There is a list if items in Column A, the letter "a" will be in column B to indicate that component has been selected and the drawing should then unhide it. if the column is left blank the compoment will be hiden. Is it possible to hide partial rows and columns. So far all I have found is hide entire row or columns.

Thanks for the help.
Peter.

No. Consider, if one hid D1:D8 and left the rest of the column visible, D8 would be above E9, which makes E:E not a column, etc..

Excel will hide only full columns or rows.

You could use formatting to "grey out" the appropriate cells.

Thanks Mike, i can understand that and have been looking at alternative methods to achieve my aims - conditional formatting has been one.

I've posted up another thread asking a similar question - where after discussing with the pepes that going to use the sheet - hiding the entire column is a better option.

Peter.

I have done something similiar to this before by making the entries in the colomns or rows conditionally formatted to change to a "white" font, thereby making them invisible against the white background.

You can do this by using the conditional formatting statement to change the cell entries in column B to a selected font color that matchs the backround color when the corresponding cell in column A = "whatever you chose".

Yep, thats a good option, it has been considered. however, the bit that needs to be hidden, is part of a drawing - if its to be hidden to show the completed drawing it needs to be hidden not just painted out.
Thanks for the thought.