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 …
How-to guides and tutorials about topics related to the Microsoft Excel 2013 application and ways that you can edit spreadsheets.
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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. …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …