Pivot Table maybe?

[Questionfor]

Good morning patient excel people....
I love excel but I know I could use some training on the finer points - but just now I am running a medium sized enterprise and have zero free time. I have a question I am sure someone will know the answer to, and I truly hope you don't mind helping me - you will be a life and sanity saver!
I use excel to record and update and use bookings for work jobs - its as simple as columns showing the date, the staff members name, the job address, and the details of what must be done at the address. What I wish to be able to do is that for the cell where we enter the details of the job work to be done (eg. "change the sprinkler heads here, but be careful of the golden canes in the corner, and take the trenching machine with you") ideally I would like the contents of this cell not to be displayed all the time while I am working on the sheet, simply because it takes up too much space on the screen (i.e. the cell is wrapped and displays beautifully, but this means every line gets quite long down the page, and after a while I can't see enough booking lines on the screen to get a good overview of bookings in a particular area that day. So I just want a way to hide the actual work details of the job (but it would be handy to have a basic reference that would give some idea, such as "Sprinkler Repair", but would actually not show all the detailed text about the job, unless I double-clicked the cell (or some other method of quick click that would show the details.)
Is this possible?
Many thanks
Deb

 

[RasGhul]

You could just have a summary column for each row and shapes to Hide Column("Job works") and un-hide?

A pivot table would work but maybe too time intensive for your requirements.