How to Save as xls By Default in Excel 2010
The Excel 2010 default file save format in .xlsx, which is great when you are working with people that are using Excel 2010 or newer …
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 Change Column Order in Excel 2010
The initial structure of a spreadsheet in Microsoft Excel 2010 isn’t always perfect, and you sometimes need to put rows or columns in different locations. …
How to Remove a Split Screen in Excel 2010
Microsoft Excel has several different viewing options that you can pick from when you are editing your spreadsheets. The correct view is the one that …
How to Move a Worksheet Between Workbooks in Excel 2010
Copying and pasting data between Excel worksheets, or even different workbooks, is a great way to work efficiently. Occasionally, however, you may have an entire …
How to Strike Through in Excel 2010
Text formatting comes in a variety of options. You’ve probably changed a font or font color before, which is an effective way to adjust the …
How to Remove Strikethrough in Excel 2010
Many applications offer you a variety of different ways to change the appearance of your text. You’ve probably done things like bold text or underline …
How to Add the Current Date to a Cell in Excel 2010
There are a lot of tools in Microsoft Excel that serve very specific purposes. Many people won’t use a lot of these, but they can …
How to Insert Bullet List Items in Excel 2010
While much of the data that you add to a Microsoft Excel spreadsheet might only take up one line, situations might exist where you want …
How to Create a Drop-Down List in Excel 2010
A spreadsheet with a lot of typos can be tough to work with, so reducing those types of errors is important. A dropdown list is …
How to View a Google Calendar File in Excel
Google usually provides data in a format that is compatible with other applications. You might have already found that you can download Docs files to …
How to Show Developer Tab – Excel 2010
Many tech tutorials that you find online for Microsoft Excel will tell you to navigate via the tabs at the top of the window. This …
Why is My Worksheet Backwards in Excel 2010?
Microsoft Excel has a couple of different potential layouts, though many people will only ever see one. A layout option that can be really confusing …
How to Unfreeze the Top Row in Excel 2010
If you have previously frozen the top row of your spreadsheet so that it was easier to identify the data in your cells, then you …
How to Unhide a Worksheet in Excel 2010
Did you previously hide a worksheet because it contained important information that you didn’t want anyone to edit? Or perhaps you simply have too many …
How to Show Ruler in Excel 2010
While your primary concern when working with data in an Excel spreadsheet may be ensuring that the data is correct, you may also need to …
How to Automatically Insert Decimal Point in Excel 2010
If you spend a lot of time in Microsoft Excel then you have probably either forgotten to include a decimal point at some point, or …
Excel Print Guide – Changing Important Print Settings in Excel 2010
Microsoft Excel is a great way to manage and edit large amounts of data. The row and column structure, combined with all of the different …
How to Delete a Sheet in Excel 2010
New Microsoft Excel files often contain a couple of blank tabs where you can add data. But if you only need one tab for your …
Why Isn’t My Entire Spreadsheet Printing in Excel 2010?
If you have finished creating or editing a spreadsheet in Microsoft Excel and then gone to print it out, you might find that it hasn’t …
How to Make a Row Bigger in Excel 2010
Adjusting the size of the cells in your spreadsheet is a pretty common occurrence, so you will eventually need to know how to make a …
How to Hide Tabs in Excel 2010
Being able to edit a visible property for one of your cells or worksheets in Microsoft Excel typically involves switching between the different tabs on …
How to Print All Columns in Excel 2010 on One Page
Microsoft Excel can be a difficult application to work with when you need to print a spreadsheet. One common problem involves getting your column to …
How to Fill Column With Same Value in Excel 2010
It’s possible that you have already noticed how often the mouse cursor can change as you hover over various parts of your spreadsheet. These cursor …
How to Turn Off Autofill in Excel 2010
Taking advantage of the various convenience features in applications like Google Sheets or Microsoft Excel is a great way to make yourself more efficient. One …
What is the Difference Between a Workbook and a Worksheet in Excel 2010?
Have you seen the terms “worksheet” and “workbook” a lot when reading about Microsoft Excel? They may seem like the same thing, or at least …
How to Move a Row in Excel 2010
Learning how to move a row in Excel 2010 is a good way to quickly adjust the layout of the data in an Excel worksheet. …
How to Unhide Formula Bar in Excel 2010
Knowing exactly what you are working on is critical in Microsoft Excel, especially when you are adjusting a formula. One way to make this a …
How to Remove an Excel 2010 Watermark
While there is no direct way to add a watermark in Excel, there are a variety of alternatives, including header and footer tools, basic image …
How to Change Page Margins in Excel 2010
Microsoft Office users often have experience with changing page margins in their documents, although that experience is likely with Microsoft Word rather than Microsoft Excel. …
How to Find a Row Sum in Excel 2010
If you haven’t used the formulas that Microsoft Excel provides, then you may not realize just how powerful the application can be. While its formatting …
How to Make Negative Numbers Red in Excel 2010
Microsoft Excel offers a lot of different tools that you can use to apply custom formats to your cells. Some of these involve cell rules …
How to Insert a Column in Excel 2010
When you are putting a lot of data into a spreadsheet it’s really easy to forget something or to decide later that you want more …
How to Make an Excel White Background in Excel 2010
Unless you have made some changes to the default setting for new workbooks in Microsoft Excel 2010, then you probably have white cell backgrounds by …
How to Merge Cells in Excel 2010
If you are fortunate enough to be working with an Excel spreadsheet where all of the data can be arranged in the default layout without …
How to Remove Page Break in Excel 2010
An Excel spreadsheet, like other documents that you might create in Microsoft Office programs such as Word or Powerpoint, will print as much information on …
How to Print on Legal Paper in Excel 2010
Print settings are often an afterthought when working with data in Excel, but it can quickly turn into a headache when you print your spreadsheet …
How to Remove Page Numbers in Excel 2010
One useful thing that you can do when working with Excel worksheets that are going to print on multiple sheets of paper is to ensure …
How to Make a Text Box in Excel 2010
Adding text boxes in Microsoft Excel may seem odd, considering the layout of a spreadsheet and the way that the application is generally. But you …
How to Set Columns to Repeat at Left – Excel 2010
Making a spreadsheet print properly can be difficult. As the file grows larger and the data uses more pages, readers might have trouble remembering what …
How to Make Page Layout the Default View in Excel 2010
Excel has a combination of default settings that are meant to appeal to a large number of users. One of these settings is the view, …
How to Remove a Password from an Excel 2010 Spreadsheet
Locking a worksheet in Excel can be a useful tool depending on how that worksheet is being shared. But someone viewing a locked spreadsheet might …
How to Change the Default Paper Size in Excel 2010
Excel printing problems come in a number of shapes and sizes. Whether you have a column that keeps trying to fit on its own page, …
How to Change the First Page Number in Excel 2010
It is helpful to add page numbers to your Excel 2010 worksheet if there are a lot of pages, or if you think it is …
How to Enter Data Into Multiple Worksheets at the Same Time in Excel 2010
Separating data into multiple worksheets within a workbook can be helpful in a lot of situations for which you would use Microsoft Excel 2010. But …
How to Format Dates as Days of the Week in Excel 2010
Data that is entered into the cells of a worksheet in Microsoft Excel 2010 can take many forms. Fortunately, Excel also offers multiple formatting choices …
How to Display or Hide the Fill Handle in Excel 2010
It is a common thing in Excel 2010 to fill a group of cells with the same value, or to fill a group of cells …
How to Hide Page Breaks in Excel 2010
Occasionally your Microsoft Excel 2010 worksheet will show a series of black dotted lines that indicate the page breaks for the worksheet. These page breaks …
How to Change the Print Resolution in Excel 2010
The print resolution that is specified by a document or image on your computer can have a big impact on both the quality of the …
How to Indent in Excel 2010
When the cells in a Microsoft Excel worksheet are nearly filled with similar data, it can be difficult to read and understand the information contained …
How to Zoom in on a Selection in Excel 2010
Sometimes the amount of data in a spreadsheet can be so overwhelming that you have difficulty focusing on the important parts. This might have led …
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 …
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
To select all cells in an Excel 2010 spreadsheet, click the ‘Select All’ button located at the top-left corner of the spreadsheet or use the …
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
You can round an Excel cell to one decimal place by right-clicking on it, choosing Format Cells, clicking the Number option, then setting Decimal Places …
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 …