Setting up perfect printing for my models has always been a challenge to me. There are several elements of a perfect setup: 1. Consistent footer and header across every sheet 2. Consistent scale across every sheet 3. Pages aren't being cut off at awkward spots (adjusting manually would affect scale and thus break #2)
What are your tips for having a perfect printing setup for your models?
| +178 | Americas M&A League Table Q2 Updated | 73 | 9h |
| +132 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 26 | 18m |
| +107 | Restructuring: Anti-climactic Experience | 26 | 7h |
| +74 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 12 | 1d |
| +73 | IB Net Worth / Savings Check | 29 | 1h |
| +51 | Boutique firm wants access to my LinkedIn? | 40 | 1d |
| +39 | Investment Banking is Hard | 17 | 19h |
| +31 | PWP vs BofA | 23 | 2h |
| +24 | Who pays the highest right now? | 14 | 2h |
| +21 | Big 4 Transaction diligence (FDD) vs Valuations and modeling for goal to get in IB | 5 | 4d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
I'll just comment on all your formatting posts, shall I. #theraputicformatting
If the content within a cell is too many lines long, make sure to click the 'wrap text' option. This allows the cell size to automatically enlarge. This will make it easier for those to see all of the text inside the box.
Double clicking on the top most line between two columns will snap to auto-fit the column.
For spreadsheets with many rows and columns, it is possible to repeat the column header and row headers across multiple sheets.
.
Help me Print in $% Excel (Originally Posted: 09/06/2013)
Printing in Excel is incredibly difficult for both modeling as well as any Comp Set from Capital IQ. If you increase the font size, it cuts up the pages terribly, if you adjust scale, your model and or work product becomes so tiny the MD's are incredibly agitated. WHAT IS THE ANSWER? I have tried with some success to set print area's on some models and then print to fit columns/rows on pages, but this takes FOREVER when you have to print multiple iterations or is downright impossible if it is a huge list of companies or a large model....Can someone please help me with suggestions on how to set up excel to print out models/lists in a readable, perfectly spaced way? ANY suggestions would be helpful as this takes up incredible amounts of time.
I usually just try to fit all columns to one page and set it to portrait. I think that as long as you fit all columns on a page and the rows print on back or next page that it looks fine (as there are usually way too many rows to fit on one sheet anyways). Then just save those settings in print options. Not sure if that helps or is relevant to how you need to format your stuff.
Anihilist is right, the key is not trying to fit the whole model on one page but fitting the columns onto the page width and letting the rows flow to as many pages as needed to make it readable, making sure to repeat any header rows and zoom as needed. You can also decrease your margins. Also, best to structure your model as you're making it so that it will fit a good print area, instead of thinking about print area when everything is done.
Excel Printing Issue.. can anyone lend a hand? (Originally Posted: 10/18/2013)
Just a standard spread sheet for internal purposes. Far left column frozen, about 12 companies from left to right after that. Trying to make it so where at any given time you can hit print and it will print the first column (frozen) and the first 6 names on one page, and then the first column(frozen) again with the second 6 names on a second page. Anyone?
Assuming you're using Excel 07/10: Set two print areas, each containing 6 names. In 'Print Titles' (under Page Setup) enter the header column into "Columns to repeat at left". That should do the trick
Yep do this. Then insert a page break and place it between the two middle companies. You may also want to insert a black column in between the two to keep the spacing consistent.
Voluptas doloribus eligendi et possimus ut molestias. Architecto laborum quasi doloremque sequi omnis dolor. Consequatur aut facere sapiente. Quia ut ut ipsa illo non quia. Ex vel eius ad fugiat perferendis. Tempora beatae pariatur perferendis doloremque.
Tempora tenetur est esse et consequatur. Inventore aut suscipit impedit expedita. Aperiam consequatur laudantium eligendi voluptatum tenetur. Nulla molestias voluptate totam. Molestiae ut odit et ipsum ab.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...