How to Save as a CSV in Excel 2010 By Default
Excel 2010 is a very versatile program that lets you perform a number of spreadsheet-related activities. It also has the ability to convert spreadsheet documents …
Microsoft Excel How-To Guides
Articles to help you answer questions and fix problems that you might be having with different versions of the Microsoft Excel spreadsheet application.
Not sure where to start? Check out our featured Microsoft Excel guides below:
- How to Create a Drop-down List in Excel – create and use a drop-down list in one of the cells in your spreadsheet.
- How to Subtract in Excel – use a formula to subtract cell values or numbers from one another.
- How to Remove the First Character in Excel – use a formula to remove the first one, two, or more characters from a string in Excel
How to View the Scroll Bar in Excel 2010
Unless you are only dealing with small amounts of data in Excel 2010, then you have likely become dependent upon the horizontal and vertical scroll …
How to Do the Max Function in Excel 2010
Excel 2010 is a very powerful spreadsheet program, and it includes so many features that there are some that even advanced users might not use …
How Do I Combine Multiple Columns Into One Column in Excel 2010
Microsoft Excel 2010 spreadsheets provide a great way for you to separate related data so that you can sort and edit some information without affecting …
Paste Data as a Picture from Excel 2010 to Word 2010
Microsoft Office products, such as Word and Excel, are generally pretty compatible with one another. If you need to get data from one program to …
Excel Guide to Removing Duplicates from a Spreadsheet
When you are importing data from another source, or you are working with a large spreadsheet that is continuously updated with new records, you can …
Set Selected Cells as Print Area in Excel 2010
Sometimes when you are working with a large spreadsheet you might encounter a situation where you need to print some of the data in the …
Increase AutoRecover Frequency in Excel 2010
Many people that have been using Excel for a significant period of time are likely to have an unpleasant memory where their computer crashed, or …
How to Show Page Breaks in Excel 2010
Microsoft Excel 2010 data is typically best viewed on your computer screen. Unfortunately, it just is not always possible to force someone to view it …
Change the Default Gridline Color in Excel 2010
The gridlines in Microsoft Excel 2010, whether the ones that you are printing or the ones on your screen, are a key element in keeping …
Change the Number of Recent Documents in Excel 2010
Microsoft Excel 2010 provides some convenience features meant to improve the usability of the program. One of these options is the list of documents on …
How to Remove Gridlines from View in Excel 2010
If you have been using Excel for a while, then you have probably become accustomed to the way that it looks. The layout of the …
How to Hide Row and Column Headings in Excel 2010
The numbers and letters at the top and left side of your Excel 2010 spreadsheet are called headings. They are a helpful way to identify …
How to Average a Group of Cells in Excel 2010
Microsoft Excel 2010 has a lot of tools that you can use to easily accomplish tasks that Excel users commonly perform. While many of these …
How to Split Data in One Column to Two Columns in Excel 2010
Correctly formatted data is very important when you are trying to get information into a database or if you are working with a formula in …
How to Print Comments in Excel 2010
While Microsoft Excel 2010 spreadsheets, in their default format, contain many ways for you to alter the appearance of your worksheets, the only way to …
How to Get Out of Header and Footer View in Excel 2010
One of the biggest problems people encounter when they are printing out a lot of similar Excel 2010 spreadsheets, or if they are working on …
How to Ignore the Print Area in Excel 2010
Learning how to set a print area in Excel 2010 provides you with the option of choosing a group of cells in your spreadsheet that …
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 …
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 …
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 …
How to Change the Date Format in Excel 2010
Microsoft Excel 2010 is pretty good at recognizing data that fit into certain criteria and converting that data to the appropriate format. One case where …
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 …
How to Set Print Margins in Excel 2010
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 …
How to Make a Custom Header in Excel 2010
When you are dealing with large amounts of data in Microsoft Excel 2010, your printed spreadsheets can get confusing. This can be multiplied depending on …
How to Format Alternating Row Colors in Excel 2010
Improving the display of your spreadsheet is important when you are trying to improve the readability for a human audience. Most people have a hard …
How to Sort By Color in Excel 2010
Excel includes a number of different ways that you can filter data. So if you are wondering how to sort by color in Excel 2010, …
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 …
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 …
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 …
How to Display More Decimal Places in Excel 2010
Learning how to increase the number of decimal places in Excel 2010 is important for anyone that is working with spreadsheets where two decimal places …
How to Change Horizontal Axis Labels in Excel 2010
Microsoft Excel 2010 is a very helpful tool for organizing and displaying data. While most users might not take full advantage of the features that …
How to Keep the Top Row Visible in Excel 2010
Viewing a lot of data in Microsoft Excel 2010 can be very frustrating. As good as Excel is at a lot of things, this is …
How to Import Excel List Into Outlook Contacts
With so many different programs available for managing your email and your email messages, you will probably switch from one program to another at some …
How to Fit a Spreadsheet on One Page in Excel
Excel has a lot of formatting options that you can modify to change the look of your data. But there are a good number of …
Microsoft Excel 2010 Pivot Table Guide
Microsoft Excel contains a number of different tools and formatting options that can make it easier for you to work with your data. Some of …
Microsoft Office Starter 2010
Once you have unpacked and set up your new Dell computer, you will notice that there are already a number of different programs and shortcut …
Excel Compare Columns
There are plenty of “Excel compare columns” methods that you could employ within Microsoft Excel, and the option that you choose is ultimately going to …
Open XML Files with Excel in Windows 7
XML files can provide a variety of information to multiple programs, but a common use for them is storing data in a tabular format, similar …
How to Convert PDF to Excel with Acrobat
PDF files are a popular form for sending data because the formatting will remain intact, regardless of which PDF-compatible program is used to open the …