How to Clear All Cell Formatting in Excel 2010

Everyone has their own preferences when it comes to working with data in Excel 2010. This could mean incorporating advanced elements into cell formatting and formulas, or it could mean changing the fill color of certain cells. But if you have ever worked on a spreadsheet from someone else, or if you are working on […]

How to Change the Color Scheme in Excel 2010

The default color scheme of Microsoft Excel 2010 is something that you have simply become accustomed to if you use the program with regularity. Many people accept the appearance of the program, simply because they are not aware that they can make some changes to how it looks. Fortunately this is an element of the […]

How to Clear the Print Area in Excel 2010

Microsoft Excel 2010 allows you to customize most aspects of your spreadsheet, including the way that it prints. If you had previously set the print area for a document, then you know that you can force Excel to print out an area of cells that you have specified, regardless of whether there is information in […]

How to Print an Entire Excel 2010 Workbook

The default print action for an excel 2010 file is to print the entire worksheet that is currently open. If you have read any of our other articles on printing in Excel 2010, such as this one about fitting an entire worksheet on one page, then you know how much you can customize a print […]

How to Change the Date Format in Excel 2010

Microsoft Excel 2010 is pretty good at recognizing data that fits into a certain criteria and converting that data to the appropriate format. One case where this is particularly true is with dates. If you enter anything that could be construed by Excel as a date, it will convert it to the currently selected date […]

How to Change a Cell Fill Color in Excel 2010

One of the best ways to improve the appearance of a worksheet in Excel 2010 is through the use of cell fill colors. They provide a nice break from the monotony of black text on a white background, while also creating another method of organization. In fact, you could easily employ a method of filling […]

How to Print Empty Cells in Excel 2010

While most of what you do in Microsoft Excel 2010 is meant to be viewed on a monitor, you will inevitably need to generate a document that gets printed out. Properly configuring a document for printing presents its’ own set of problems but, once you have done it enough and familiarized yourself with the rules […]

How to Keep Leading Zeroes in Excel 2010

Microsoft Excel 2010 does its’ best to format the data you enter into your worksheets so that it is in the format that it thinks you wants. Unfortunately its’ choices are not always correct, and Excel might wind up deleting information that is important or relevant. One particular situation you may find yourself in is […]

How to Set Print Margins in Excel 2010

Last updated: March 7, 2017 You will need to know how to change the page margins in Excel 2010 if you encounter a spreadsheet that is either slightly too big to fit on a printed page, or f the spreadsheet might look better if it had larger margins. But the method for changing page margins […]

How to Hide Columns in Excel 2010

Dealing with large amounts of data in Microsoft Excel 2010 can be a bit of a headache. This is not a fault of Microsoft Excel, however. Most of the trouble lies in the size of the screen on which you are viewing the spreadsheet and the amount of data that you can see at once. […]