Handling an Excel spreadsheet that prints out on more than one page can be cumbersome. Additionally, the second page may not have all of the necessary labels, making it difficult to understand the data that you are viewing. Fortunately you can configure your document to reduce the scale of the worksheet and so that everything prints out on one page.
Open your spreadsheet in Excel 2010, then click the “Page Layout” tab at the top of the window.
If your spreadsheet has a lot of individual columns that you need to combine into a smaller number, then the concatenate Excel formula can help a lot. It provides a quick way for you to combine different cells of data without needing to manually edit that data.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
|
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.