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 …