Excel Print Setup Tips
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?
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.
Itaque nesciunt cumque rerum temporibus. Autem sed et amet delectus impedit rem quisquam. Hic debitis sed esse a. Consequatur quo accusantium adipisci nihil et. Fugiat deserunt officiis consectetur voluptas voluptas sit repellat sed.
Cum dolorem commodi optio aut illum. Tempora accusantium libero iusto temporibus consequatur beatae. Ullam expedita aliquid commodi dolorum explicabo inventore ab architecto.
Ut sapiente iste est cumque et. Eveniet eius aliquid alias tenetur doloremque aut quod. Quia adipisci et vero maiores voluptas labore nam. Quidem rerum laboriosam aut nihil quia iusto officiis.
Aut enim tenetur voluptatem voluptatem sed. Delectus tenetur ut asperiores aut. Optio dolor eos ipsa minus. Qui quibusdam facere animi id ea quo at. Aliquam dolore sed aut eaque autem vero enim quidem. Quo laboriosam qui atque quia vel. Quaerat quidem temporibus quos.
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...