How Do I Make Columns Automatically Expand in Excel 2010

The default cell size in Microsoft Excel 2010 can fit approximately 8.5 characters. When you are working with small numbers and no letters, this sizing is going to be appropriate for most situations. Unfortunately not everyone works with data like that, and you may find yourself needing wider columns on a regular basis. While you […]

How to Automatically Number Rows in Excel 2010

When you are first creating a set of data in Microsoft Excel 2010, there is probably a lot of data entry that is occurring. While this is, by its’ very nature, a tedious activity, it can be made even more so if you are just typing slightly different values on each row. For example, “Product […]

Disable Formula Updates in Excel 2010

You can use formulas in Microsoft Excel 2010 to perform calculations based upon the values in your spreadsheet. The benefit to using cell numbers and letters over actual values is that the formulas that you have created will update their values if you edit a cell value. This is extremely helpful and can aid you […]

How to Merge Cells in Microsoft Excel 2010

If you are lucky enough to be working with an Excel spreadsheet where all of the data can be arranged in the default layout without any additional configuration by you, consider yourself lucky. Individuals making spreadsheets that require no formatting are certainly in the minority. If you have read this article about adjusting your cell […]

Switch a Row to a Column in Excel 2010

Unless you are working with a data set with which you are very familiar, it can be difficult to ascertain exactly how the data in your spreadsheet is going to need to be laid out. Or maybe it is data that you are familiar with, but you need to use it in a different manner […]

How to Rotate Text Vertically in Excel 2010

Last updated: January 10, 2017 You are able to write vertically in Excel, or make text vertical in Excel, if you have a project that requires your text to be displayed in that fashion. The method for performing either action is the same. The only variable is when you choose to click the Vertical Text […]

How to Change the Size of a Cell in Excel 2010

Cells in Microsoft Excel 2010 have a default size of 8.43 characters wide by 15 points high. This size is ideal for many situations, but you will eventually encounter a piece of information that will not fit within these default parameters. Fortunately you can choose to make any cell either smaller or larger to accommodate […]

How to Open CSV Files with Excel by Default

Last updated: March 3, 2017 You may have decided that you want to open CSV files in Microsoft Excel by default if you find that double-clicking those files is causing them to open in another program. The typical default setting usually has CSV files opening in Notepad but, as the data layout for many .csv […]

How to Convert CSV to Excel 2010

The Excel 2010 file format, .xlsx, is capable of storing multiple sheets within the workbook that you have created. Using multiple sheets in one workbook is the ideal solution when you have a lot of different spreadsheets that are all related to the same topic and you want to access all of that data without […]

Microsoft Excel Skills to Know When Job Hunting

If you are just entering the job market, or if you are looking to make a career change, then you have probably determined that a lot of the available jobs require some kind of computer training. The actual extent of the necessary skills are going to vary wildly depending upon the type of job you […]