How to Hide Columns in Excel - TechRepublic
Question
January 21, 2009 at 09:56 AM
khale

How to Hide Columns in Excel

by khale . Updated 17 years, 4 months ago

I have a worksheet with checkboxes. When a user selects a checkbox, another sheet is populated with the information relevant to that checkbox. Say for example, in Sheet A there are three checkboxes, one is Apples, one is Organges and the other is Grapefruits. In sheet B is a column with apples in COL A, organes in COL B and bananans In COL C and the differnt places where the fruit can be purchased is listed in each row. A user comes and places a checkmark in apples and bananas, How can I automatically hide the column for bananas for ease of printing?

This discussion is locked

All Comments