Microsoft Excel is a great product but one of the most frustrating things about Excel is trying to get a spreadsheet to fit into a normal 8.5x11 page. In the past I've always had to play around with setting the print area or condensing the spreadsheet to fit on one page. But with the release of Excel 2010, there's an easier way to see what your spreadsheets will look like, … [Read more...] about How to Show a Page Preview in Excel 2010
Excel
Excel 2010: How to Select or Change the Print Area
Unlike in Microsoft Word where a page is page, Excel 2010 (and, in fact, all previous versions) don't really understand the concept of a "page". Thus, in order to print using Excel, it's up to the user to let Excel know what data you want on a page. In Excel, the area of a spreadsheet (worksheet) to be printed is called the Print Area. Excel will generally automatically set … [Read more...] about Excel 2010: How to Select or Change the Print Area
Excel 2010: How to Print Sheet on One Page
I'm often asked how to condense an Excel 2010 spreadsheet for printing on one page -- so in this post I will show you how to make that happen. First consider that every spreadsheet is not meant to be condensed into one page -- you can shrink any print area of an Excel spreadsheet into one page -- but it may be unreadable at that size. So to shrink the worksheet to fit (in … [Read more...] about Excel 2010: How to Print Sheet on One Page
Excel: Increase the Number of Files in the Recent File List
In this quick tutorial we will go over how to increase the number of "remembered" files in the Microsoft Excel Recent Files list in the File Menu. 1. First, head to the Tools Menu and select Options. 2. In the menu that opens, select the General tab at the top, and locate the Recently used file list and make sure the box is checked. Then simply enter the number of files … [Read more...] about Excel: Increase the Number of Files in the Recent File List
Excel Tutorial: A Guided Tour of the Excel Menus Part 4 – The Insert Menu (Video)
In this video tutorial series we are going to take a tour of the menu items in Microsoft Excel. Instead of working through a spreadsheet example start to finish, in this series we are going to walk through the Excel menus to give you an idea of what commands are located on each menu, as well as what each of these commands do. By learning this way, you will be able to get a “big … [Read more...] about Excel Tutorial: A Guided Tour of the Excel Menus Part 4 – The Insert Menu (Video)