List of Categories

CATEGORY: Excel

How to Show a Page Preview in Excel 2010

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…

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…

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…

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…

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…