RickyDuvet
New Member
- Joined
- Aug 23, 2018
- Messages
- 1
Hi All,
I'm sitting behind a corporate firewall so posting pictures is not possible, so i'll counjour the image with words and copy/paste....maybe. Oh, I'm using Excel 2016.
I hold a data table, these headings, all in their own column. (This is a sample, my actual data table is 23 columns wide) With every new customer all colums are completed.
<tbody>
</tbody>
During the working day however, I usually only need the following to be visible, (Actually only 10 of my actual data table) so have hidden the others using grouping on the columns.
<tbody>
</tbody>
What I woudl like to be able to do is to automate the "Zoom to Width" function so that when I expand or collapse, the number of columns visible always are er..."Zoomed To Width"
Thoughts/Suggestions?
Thanks in advance.
RickyD
I'm sitting behind a corporate firewall so posting pictures is not possible, so i'll counjour the image with words and copy/paste....maybe. Oh, I'm using Excel 2016.
I hold a data table, these headings, all in their own column. (This is a sample, my actual data table is 23 columns wide) With every new customer all colums are completed.
Customer | Replied? | Date Received | Status | Notes | Address | Location Code | Team ID |
<tbody>
</tbody>
During the working day however, I usually only need the following to be visible, (Actually only 10 of my actual data table) so have hidden the others using grouping on the columns.
Customer | Address | Location Code | Team ID |
<tbody>
</tbody>
What I woudl like to be able to do is to automate the "Zoom to Width" function so that when I expand or collapse, the number of columns visible always are er..."Zoomed To Width"
Thoughts/Suggestions?
Thanks in advance.
RickyD