Hi,
So I am back to using Excel after 6 years and after appreciating the software the first thing I notice is the massive abuse of excel functionality by my colleagues (including me).
I am using excel to print different documents like bill of materials and other similar lists. The excel sheets undergo editing regularly and that is where my OCD comes into play. Everyone takes the liberty of moving things. So when a document is ready for print it might not look like its previous versions. I want to standardize the final printing layout. Somethings that I would like to do is:
to have fixed row and column heights
fixed number of rows per page
borders of same width around the pages
rows to repeat at the top and bottom of the pages with correct page numbers added (maybe this can be done by making a dynamic header and footer)
fixing margins and scaling etc.
My idea is once the data inside the lists is ready, a click can format the sheets to the standard format for that particular document. Being not an expert on Excel and VBA I am not sure if this is possible. So my question is, whether this is possible and if yes can someone nudge me in the right direction?
Searching Google didn't help me much except suggesting a few paid plugins; maybe the keywords I used in searching aren't correct. I would appreciate any kind of help as my OCD is killing me here.
Bookmarks