Excel - hide & print

[LordAndy]

Is it possible to hide cells, but still have them print?

 

[SkipVought]

Hi,

You cannot hide a cell. You can hid Rows or Columns, however. Hidden Rows/Columns are...., well...., er...., hidden, and therefore not visible for either viewing or printing.

You can, however, record a macro to UNHIDE the Rows/Columns, PRINT and REHIDE, if so desired.

Skip,

_[red][/red]

 

[WalkerEvans]

LordAndy,

It is possible to completely hide the contents of a cell using the "Hidden" option under Protection with the cell format set to ";;;". If you also "Lock" the cell the contents become not only invisible, but your users won't be able to access it and make any changes. I've found this invaluable when creating sheets for multiple users - keeps them from messing with the calculations.

If this is what you're doing SkipVought's solution will work, but you'll have a couple of extra steps to perform when recording your macro.

Hope this helps.

 

[SkipVought]

LA,

This is where language is so important.

A CELL cannot be hidden. Walker's solution does NOT hide the cell. It hides the CONTENTS of the cell.

BIG DIFFERENCE. Just depends what you are trying to accomplish.

Skip,

_[red][/red]

 

[LordAndy]

Sorry guys. I am fairly new to Excel and also self taught. To be more specific - I want to hide the content of a row from view, but still have that content print.

Thanks for the help!

 

[SkipVought]

Well I guess you have a method now.

Skip,

_[red][/red]