MS Excel: hide a selection of data (not an entire row or column)?

P

Panda Q

I would like to hide a portion of cells without hiding the entire row or the
entire column in a single worksheet.
 
J

Jim Thomlinson

Can't be done. Rows and columns have a hidden property, but individual cells
do not. What you could do would be to use formatting or conditioanl
formatting to make the text colour the same as the background colour. The
value is still in the cell but it does not appear because of the colour.
 
F

FSt1

hi
excel can't do that.
you can hide entire rows or columns but not individual cells or groups of
cells.

Sorry
Regard
FSt1
 
P

Panda Q

Thanks everyone.

To make it clear for me, along the same lines, let me post an example.

In rows 1-15, if I have column A, B, and C, C is a total of A and B, and
there is additional information that I do not want to hide in rows after 16,
pretty much the only way to "hide" the information in column A and B for rows
1-15, is to format the font color to match the background color?

Because deleting that portion would mess up the total function, right? And
there's no method to hide only select cells (by shifting them left or up or
whatever), similar to if you deleted them?

Thanks everyone! You're response time was awesome!!
 
Top