How to Display the Document Panel in Excel 2010
File that you create in Microsoft Office programs, such as Microsoft Excel, include information that describes the file. This information is called metadata and can …
Microsoft Excel 2010 How-To Guides
Learn how to adjust the settings and make changes to the spreadsheets that you are editing in Microsoft Excel 2010.
How to Select the Cells Containing Formulas in Excel 2010
When you discover an error in Microsoft Excel, and that error is part of a formula, then the level of difficulty in resolving the problem …
How to Add a Page Break in Excel 2010
Microsoft Excel 2010 will automatically include page breaks in your printed worksheet based on your paper size and margins. Unfortunately these page breaks do not …
How to Remove Cell Borders in Excel 2010
A new, blank worksheet in Microsoft Excel consists of a series of cells that are split into rows and columns. You can visually distinguish these …
How to Stop Printing Gridlines in Excel 2010
A worksheet that you print in Microsoft Excel 2010 will not include gridlines by default. However, many people adjust the settings of their worksheets to include …
How to Unhide a Hidden Workbook in Excel 2010
Microsoft Excel windows can easily become cluttered, which can make it difficult to concentrate on the task you are trying to complete. One way to …
How to Print Titles in Excel 2010
A common way to format a spreadsheet is to include a row of cells at the top or a column of cells at the left …
How to Use R1C1 Reference Style in Excel 2010
If you have ever run into issues with cell references in Excel formulas, then you may be looking for another way to use them. Or …
How to Remove a Border from a Text Box in Excel 2010
When you create a new text box in your Microsoft Excel 2010 worksheet, it will have a border. Typically this border is dark grey and …
How to Select Draft Quality Printing in Excel 2010
Highly customized spreadsheets in Microsoft Excel often go through several different versions before they are finalized and ready to be used or seen by their …
How to Unhide Column “A” in Excel 2010
Unhiding the first column, or column “A” in an Excel spreadsheet presents a unique challenge. The typical method for unhiding a column will not apply …
How to Put the Worksheet Name in the Footer of an Excel 2010 Worksheet
If you have ever printed a lot of different similar-looking reports, then you know how helpful it can be to have those reports include identifying …
How to Remove an Add-In from Excel 2010
Microsoft Excel 2010 can do a lot of different things, leading many users to take advantage of the program whenever possible. But there are certain …
How to Change Page Size in Excel 2010
The Normal view in Microsoft Excel 2010 is simply a large, continuous grid of cells that are organized into rows and columns. This view makes …
How to Switch to Page Layout View in Excel 2010
When you are working on a spreadsheet in Microsoft Excel 2010, the focus is usually on the data that you are adding, and the information …
How to Add a New Worksheet in Excel 2010
The Microsoft Excel files that you have saved on your computer, and that you occasionally share with work colleagues or teachers, have file names with …
How to Turn on Automatic Calculation in Excel 2010
Are you working with a spreadsheet in Microsoft Excel 2010 where you change a cell that is included in a formula, but the result of …
How to Change a Worksheet Name in Excel 2010
Splitting data up into individual worksheets in a Microsoft Excel file is an efficient way to organize information. It also prevents you from needing to …
How to Put Parentheses Around Negative Numbers in Excel 2010
When you are working with a lot of data in Microsoft Excel 2010, it is often beneficial to format certain types of data so that they …
How to Hide the Scroll Bars in Excel 2010
When your Excel worksheet starts to fill up more than the visible cells on your screen, then you will need to a way to view …
Copy Cell Formatting from One Cell to Another in Excel 2010
Cell formatting, much like the formulas that you use within those cells, is an important element of how data in an Excel 2010 spreadsheet is …
How to Delete Cell Contents in Excel 2010
Sometimes you no longer need the data that is entered into a cell. Whether the data is incorrect or it has been updated, there are …
How to Select Non-Adjacent Cells in Excel 2010
If you have been using Microsoft Excel for at least a short amount of time, then you have probably encountered a situation where you needed …
How to Display a Formula Result in a Text Box in Excel 2010
Text boxes can be a useful tool in Microsoft Excel. One particular example is when your spreadsheet has a lot of data in it, but …
How to Copy a Worksheet to Its Own Workbook in Excel 2010
When you work with Excel 2010 often for work or school, you may eventually find that you are using the same data over and over …
How to Unhide Everything in Excel 2010
Hiding rows, columns or worksheets in Microsoft Excel is an effective way to stop displaying information in your spreadsheet without deleting it. Whether this is …
Why Is Excel 2010 Showing the Formulas Instead of the Answers?
You may discover that you need Excel to show results instead of formulas when you enter a formula that remains visible. An Excel spreadsheet can …
How to Vertically Center Text in an Excel 2010 Cell
A cell in a Microsoft Excel 2010 worksheet can contain a variety of different types of information, and many of the possibilities will result in …
How to Make All Rows the Same Height in Excel 2010
You may already know that you can change the height of a row in Microsoft Excel 2010, but it can be tedious when you need …
How to Remove a Header Image in Excel 2010
Some organizations like to add watermark images to their Excel files, either as a means to identify the source of the file or to add …
How to Remove a Hyperlink in Excel 2010
Microsoft Excel 2010 is capable of adding hyperlinks to text that you have entered into cells in your worksheet. These links can either be added …
How to Stop Printing Row and Column Headings in Excel 2010
Excel 2010 offers a variety of options that can be added to or removed from your printed worksheets. One of these options is the ability …
How to Remove the Percentage Symbol in Excel 2010
Cells in an Excel spreadsheet can contain many different kinds of data, and they can be formatted in many different ways. If you are working …
How to Spell Check a Worksheet in Microsoft Excel 2010
Spell check is a commonly used utility in Microsoft Word to locate and fix words that have been misspelled. But Word documents are not the …
How to Select All of the Cells in an Excel 2010 Spreadsheet
When you need to make changes that affect multiple cells in Excel, the best way to do so is typically to use your mouse to …
How to Remove the Background from a Picture in Excel 2010
You likely already know how to insert a picture into your Microsoft Excel spreadsheet, but what you might not realize is that there are some …
How to Switch Vertical Text to Horizontal in Excel 2010
There are a lot of different formatting options in Microsoft Excel 2010, but there are some that you might encounter less frequently than others. One …
How to View the Print Area in Excel 2010
Excel spreadsheets that were created by or edited by other people can often have formatting that is not immediately visible when you first view the …
How to Display Numbers as Fractions in Excel 2010
Microsoft Excel 2010 provides a vast assortment of tools and features that will help you to manage data in your spreadsheets. By default, the numbers …
How to Rotate a Picture in Excel 2010
Adding a picture to a spreadsheet in Excel 2010 is something that most Excel users will need to do at one time or another, but …
How to Remove a Footer in Excel 2010
The footer section of an Excel 2010 spreadsheet is displayed on every page of a worksheet that prints out. This is great when you want …
How to Remove All Page Breaks in Excel 2010
If you are printing a spreadsheet that has a lot of formatting, such as an order form or invoice, then you may find that Excel …
How to Round to One Decimal Place in Excel 2010
Learning how to round to one decimal place in Excel 2010 can be a very helpful way to simplify the display of numerical values in …
How to Find a Median in Excel 2010
Excel 2010 is a great tool when you have a lot of data that you want to compare. You can easily perform mathematical operations on …
How to Print with Row and Column Headings in Excel 2010
Printed Excel spreadsheets always suffer from the fact that they can be difficult to follow. This is especially true of multi-page spreadsheets that are missing …
Why Is Excel 2010 Printing in Black and White?
Receiving an Excel file from another person is often a frustrating proposition, especially if you need to print or edit the file. People have individual …
How Do I Lock an Image to a Cell in Excel 2010
It’s very common for Microsoft Excel spreadsheets to contain images, but they don’t behave the same way as data when they are first inserted into …
How to Insert a Picture Into a Cell in Excel 2010
While Microsoft Excel is typically used as a way to store, sort and manipulate text and numbers, it is also a helpful way to store …
How to Automatically Add a Dollar Symbol in Excel 2010
Excel can be used in a lot of different ways, but perhaps one of the most common uses is generating reports that include monetary values. …
How to Center Text in a Column in Excel 2010
Information in adjacent cells in a spreadsheet can become difficult to read if there isn’t a lot of white space between each cell. One way …