How to Create a Pivot Table in Excel 2013
Microsoft Excel is full of useful tools that can help you get the information that you need from your source data. But if you have …
Microsoft Excel 2013
How-to guides and tutorials about topics related to the Microsoft Excel 2013 application and ways that you can edit spreadsheets.
How to Convert MM to Inches in Excel 2013
Converting units of measurement is a necessary evil for a lot of people in a wide variety of fields. Fortunately if you want to convert …
How to Find an Average in Excel 2013
Microsoft Excel includes a number of different ways that you can calculate totals or values based on your cell data. But if you need to …
How to Stop Showing a Dollar Sign in Excel 2013
Formatting data properly in Excel can solve a lot of problems that you might have with your formulas, or with readers understanding your data. But …
How to Delete a Comment in Excel 2013
We have previously written about how to add a comment to a cell in Excel 2013, but what if you need to delete a comment …
How to Delete a Header in Excel 2013
Information in the header of a spreadsheet can include things like page numbers, you name, or the name of a report. But if that information …
How to Split Full Names Into Two Cells in Excel 2013
Excel has a lot of helpful features for managing data, and many of them can save you a lot of manual work. For example, you …
How to Print Each Worksheet of an Excel 2013 Workbook on One Page
When you have an Excel workbook with a lot of individual worksheets, you might need to print all of those sheets at once, and you …
How to Make a Table in Excel 2013
While the layout of a spreadsheet in Microsoft Excel is reminiscent of a table by default, Excel actually has a tool to make tables from …
How Do You Name Columns in Excel 2013?
Adding a row of headings to the top of your spreadsheet is an effective way to describe the data in your cells. This is especially …
How to Insert an Arrow in Excel 2013
If you want to subtract in Excel, there’s a formula that can help you do it. The same goes for other common mathematical operations, as …
How to Calculate Age from a Birthdate in Excel 2013
Excel has a lot of tools that can help you calculate values based on data that you’ve entered. You’ve probably had to add up values …
How to Display Numbers Without a Comma in Excel 2013
Are some of the numbers in your spreadsheet currently formatted to display commas as a 1000 separator? This is an option in Excel, and it …
Can I Name a Worksheet Something Other Than Sheet1, Sheet2, etc in Excel 2013
Excel files are often referred to a spreadsheets, but they are actually files called workbooks, and they can contain multiple spreadsheets within them. These spreadsheets …
How to Add Row Numbering in Excel 2013
Numbering your rows in Excel is helpful when you need to reference a particular cell either to another person or as part of a formula. …
How to Change the Page Order in Excel 2013
It’s very common for an Excel spreadsheet to be too large to fit on one page. Additional cells are then pushed to another page, and …
How to Hide Multiple Worksheets in Excel 2013
The ability to hide worksheets in an Excel workbook can be very helpful when you need to share a spreadsheet with someone else, but there …
How to Change the Order of Items in the Excel 2013 Quick Access Toolbar
The Quick Access Toolbar in Excel 2013 gives you the ability to quickly perform some common commands that would otherwise require you to navigate through …
How to Delete All Comments from a Worksheet in Excel 2013
We have previously written about how to delete a comment in Excel 2013 when you have a specific comment in a spreadsheet that you no …
How to Concatenate Text in Excel 2013
Retyping data is always a hassle in spreadsheets. It’s also prone to errors, so you might be looking for a better way to combine data …
How to Refresh a Pivot Table in Excel 2013
Entering all of the data into your spreadsheet and using it to create a pivot table in Excel is a great way to manage your …
Why Are My Column Labels Numbers Instead of Letters in Excel 2013?
If your Microsoft Excel application has column numbers instead of letters, then you may be wondering not only how that happened, but how you can …
How to Delete a Text Box in Excel 2013
If you have a text box in an Excel spreadsheet that you need to delete, then you might be wondering how that is possible. There …
How to Select Entire Spreadsheet in Excel 2013 (An Easy 2 Step Guide)
Occasionally you might need to make a change that affects all of the cells in a spreadsheet. But if you’ve ever tried to manually select …
How to Expand Cells Horizontally in Excel 2013
While the standard Excel cell width can hold several characters’ worth of data before things start to become hidden, you will probably need to know …
Why Can’t I Double Click a Cell to Edit It in Excel 2013?
You can edit cells in Excel 2013 by selecting a cell and clicking inside the formula bar at the top of the window, or you …
How to Turn Off Screen Tips in Excel 2013
Excel 2013 can provide you with additional information about some of the buttons and features in the program when you hover over them. These pop-up …
How to Add Leading Zeroes to Numbers in Excel 2013
If you are working with numbers that might include zeroes at the start of those numbers, then you might be running into a problem. Excel …
How to Return All Worksheets in an Excel Workbook Back to Normal View
Excel 2013 has a few different view options that you can select from to help you format your spreadsheet properly. The view setting is an …
How to Calculate the Number of Workdays Between Two Dates in Excel 2013
One way that you can use Excel 2013 is to keep track of ongoing projects, or important dates that occur either in your personal life …
How to Change or Edit an Existing Header in Excel 2013
The header section of an Excel spreadsheet is a great place to add a page number, or include important information that can help to identify …
How to Change Tracking Numbers from Scientific Notation in Excel 2013
If you are working with a lot of shipping data in a Microsoft Excel spreadsheet, then you will likely need to store information about tracking …
Why Is Excel Still Printing Lines When I Have Already Turned Off Gridlines?
Excel spreadsheets can be difficult to read when you print them without any kind of lines to separate data in cells. On paper this can …
How to Stop Excel from Removing the Second Decimal Place If It’s a Zero
Excel 2013 has a wide range of formatting choices that can be applied to cells in a worksheet. But some of the default formatting choices …
How to Resize a Picture in Excel 2013
Many of the pictures that you have on your computer, whether they are screenshots or pictures from a digital camera, are probably rather large. This …
How to Reset a Picture to Its Original Size in Excel 2013
A picture that you insert into a spreadsheet in Excel 2013 is unlikely to be the right size or in the right format that you …
How to See Which Files Excel 2013 Will Open By Default
Microsoft Excel is the common choice when you need to select a program to open .xls or .xlsx files. In fact, it probably obtained those …
How to Show Two Decimal Places in Excel 2013
A spreadsheet can look a little messy and be difficult to read when it has inconsistent formatting. But often, this inconsistency is simply due to …
Why Aren’t My Arrow Keys Working in Excel 2013?
Rather than using your mouse to click between the different cells of your spreadsheet in Excel 2013, you may have found that the arrow keys …
How to Turn Off Background Error Checking in Excel 2013
Excel 2013 is constantly scanning for errors in your workbook. This occurs in the background and is the reason that you often see a small …
How to Hide Gridlines in Excel 2013
Gridlines in Excel 2013 offer an effective way to visually separate your data into distinct cells. These gridlines can appear on the screen when you …
How to Set Excel Column Width in Inches
If you’ve ever tried to adjust the width of your columns for printing then you have probably found it to be a little frustrating. This …
How to Multiply in Excel 2013
If you are trying to figure out how to multiply in Excel 2013, then you might be struggling to find the formula or option to …
How to Disable AutoRecover for a Specific Workbook in Excel 2013
The AutoRecover feature in Microsoft Excel 2013 can help to save your work in the event that your computer shuts down unexpectedly before you have …
What is the Difference Between “Clear Hyperlinks” and Remove Hyperlinks in Excel 2013?
Excel 2013 has a habit of turning text that looks like a Web page address or file location into a link. This is helpful if …
Why Isn’t My Sum Updating in Excel 2013 Anymore?
A sum that is not updating automatically in Excel 2013 can be frustrating and, depending upon the importance of the information that it affects, potentially …
How to Cross Out in Excel 2013
Microsoft Excel has a lot of formatting options that let you do things like convert text to numbers in Excel. But you may be looking …
How to Alphabetize in Excel 2013
Excel 2013 provides numerous utilities that allow you to organize, store, and interact with your data. Perhaps one of the most helpful and most commonly …
How to Print an Excel Spreadsheet on A4 Paper
In a perfect world, you wouldn’t need to make any changes to your Excel files before you print them. But whether you need to know …
How to Put a Bulleted or Numbered List in Excel Cell
Microsoft Excel’s default layout of cells in rows and columns is a great place to start when you’re organizing data. But you might be wondering …