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. Fortunately Excel 2010 has a number of different ways that you can customize the appearance of your printed spreadsheets, […]
How to Change the Color Scheme in 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 […]
How to Print on Legal Paper 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 […]
How to Insert a Picture Into a Cell 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 […]
How to Lock an Image to a Cell in Excel 2010
I often find that I need to lock a picture to a cell in Excel 2010 when I am creating product spreadsheets for customers that require images as part of that data. The default behavior when you insert a picture in Excel is a little unusual if you are accustomed to working with pictures in […]
How to Insert a New Worksheet in Excel 2010
Many Excel users typically only work with one worksheet in a workbook, but there is a lot that you can accomplish when you start leveraging the relationship that can exist between multiple worksheets within a single workbook. Often this will require you to insert a new worksheet in Excel so that you can include additional […]
How to Unmerge Cells in Excel 2010
Microsoft Excel 2010’s default state is a series of cells laid out in rows and columns of equal sizes. But as data is added to those cells and you begin to format that data to appear a certain way, you may find that you need to merge certain cells in order to achieve a specific […]
Where Did the Gridlines Go in Excel 2010?
The gridlines that separate your cells in a Microsoft Excel 2010 spreadsheet are helpful for keeping cells visually distinct from one another. So when those gridlines are not visible, the data in your cells can seem very haphazard. If you are working with a spreadsheet in Excel 2010 and the gridlines have been hidden, then […]
How to Change the Cell Shading Color in Excel 2010
Cell shading, or fill color, is an effective way to highlight data in a spreadsheet, or to indicate that certain cells are associated with one another. But if a cell already has an existing fill color, then you may be looking for a way to change it. Fortunately cell fill colors can be changed in […]
How to Print a Row at the Top of Every Page in Excel 2010
Excel 2010 is a really great program for organizing and calculating data. But printing has never been something that was very easy to handle in spreadsheets, and the problem amplifies itself when you are dealing with multi-page spreadsheets that contain a lot of columns with similar-looking data. These situations can make a printed spreadsheet difficult […]