Forum Discussion
Hiding cells in a worksheet
Can you hide just a cell in a worksheet or can you only hide worksheets themselves.
And if you can only hide worksheets themselves does anyone have any recommendations on the best way to hide a small amount of information like the cost of a single item in a vehicle repair log?
NikolinoDE has given you a laundry list of ways to hide some things. I want to back up and ask for a bit more information here:
- What's the context? I.e., the bigger picture? Do you, for example, have a detailed sheet of all costs for a given repair job, and are wanting to print a higher level summary that doesn't show some details but still is accurate on the overall total?
- You give the example of hiding a single item, but if this repair log has several (or many) individual items that you'd want to not display in detail, then it might make more sense to bunch the individual items but still on an invoice show "Miscellaneous Replacement Parts" or "Labor" that shows the total for the various details that fall into those categories.
- From whom are you hiding this data? (customer? middleman? other?) Is it safe to assume you're not trying to hide work that's been done; just to make an invoice (or other summary document) more "user friendly" by omitting the minutiae.
Hi, mathetes
I have been asked to put together a maintenance log for our fleet and the owner was wanting to include the purchase price of each vehicles so it can also calculate depreciation. However he doesn't necessarily want everyone to be able to see how much they spent for them.
Thus the question about hiding just one or two cells.
Thanks for your help!
Let me assure you that everybody who has access to the workbook will know the purchase prices. No matter what you do to hide them.
