Hi Everyone, I am creating a sheet in which information is inputted into it. I have a series of four rows which information is inputted into. Then these 4 rows are copied downwards 12 times. However, based on the job, not all 12 fields are used, so as a result, I would like to hide these from the user, so that if they need an extra field, they can unhide the 4 rows which are grouped together, rather than copying and pasting. I have experimented with the group option within the data tab, however this required a gap between separate groupings, which cause a large amount of white space when all the groups are collapsed. Does anyone know how I can have extra fields hidden away for use if needed without creating the white space at the end of the sheet?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Hiding Columns in the form of a group
Similar threads
- Question
