Have you ever printed a spreadsheet in Excel and it was aligned at the left side of the sheet? In some cases, this is perfectly fine, but in other situations, this could look bad or unprofessional. This can leave you trying to learn how to center a worksheet horizontally in Excel. If you need to… Continue Reading How to Center Worksheet Horizontally in Excel 2010 (and Vertically, Too)
Applying a formatting change to unformatted data in Microsoft Excel can be pretty straightforward. You simply select whatever text, number, or object you want to format, then you find the appropriate button or menu. But if you want to change something that is already formatted, such as if you want to remove an existing fill… Continue Reading How to Change the Excel Cell Shading Color in Excel 2010
While there are a number of techniques that you can use to organize large amounts of data, such as giving a sheet tab a more descriptive name, or color coding rows or columns inside a worksheet, you can employ title rows and create row and column headings to make cells easier to identify. Excel 2010… Continue Reading How to Print First Row on Every Page – Excel 2010
If you have used Excel for a while, then you have probably acclimated yourself to the visual appearance of the program. But the colors of the application might be wearing on your, leaving you looking for something different to spice up your daily activity in your spreadsheets. One simple change that you can apply is… Continue Reading How to Change the Color Scheme in Excel 2010
Excel spreadsheets are notoriously difficult to print. The default print settings don’t include gridlines, won’t repeat titles or headers on each page, and are not at all optimized to fit your data into the constraints of your paper size. Our Excel printing guide can show you how to fix a lot of these issues, and… Continue Reading How to Print on Legal Paper in Excel 2010
Learning how to insert a picture into a spreadsheet in Excel 2010 is useful when you encounter a situation that calls for more than just data in your cells. Adding pictures to your cells is common for businesses that need to supply customers with product information, or even in personal situations where you might be organizing… Continue Reading How to Insert a Picture Into a Cell in Excel 2010