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 …
Articles to help you answer questions and fix problems that you might be having with different versions of the Microsoft Excel spreadsheet application.
Not sure where to start? Check out our featured Microsoft Excel guides below:
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 …
The commenting system in Microsoft Office products like Excel is ideal when you are collaborating on a document with a team and need to question …
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 …
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, …
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 …
An Excel 2013 spreadsheet that uses the default print settings will often be difficult for readers. It might also be off-centered, depending upon the number of …
Sometimes a cell in an Excel worksheet requires a bit of explanation. But it may not be feasible to include that explanation in the cell …
It can be frustrating, even problematic, when your Excel formulas are not working. We use formulas in our Excel spreadsheets to automatically calculate values for …
Are you familiar with a lot of the formulas in Excel, but you don’t remember the exact parameters that you need to use? Microsoft Excel …
I have found that spreadsheets I receive from other people often have some formatting that is already applied. One big one is the print area, …
Headers and footers in an Excel spreadsheet offer a simple way to put repeating information at the top of every printed page of your spreadsheet. …
Text that you enter into the cells of an Excel 2013 spreadsheet is typically oriented from left to right. But there may be situations where …
Manually entering a series of numbers into an Excel row or column can be tedious. It’s easy to start typing too quickly and enter an …
While everyone that uses Microsoft Excel has their own tendencies and preferences, it is common among many of these users to choose a blank workbook …
Microsoft Excel’s Print menu includes a lot of ways that you can format your spreadsheet for printing. However, some of these options are kind of …
Excel workbooks with multiple worksheets are a great way to coordinate data that might not necessarily belong on the same worksheet, but that is relevant …
Excel spreadsheets rarely print how you want them to, and properly configuring a spreadsheet for the physical page is often cited as one of the …
Microsoft Excel gives you a lot of ways to store and edit the data in a worksheet. In fact, there are so many different options …
Repeating information at the top of each printed page of an Excel spreadsheet is helpful when you wish to include a report name or some …
Many Excel 2013 users will find that they need to adjust their print settings so that their spreadsheets fit better on a printed page. We …
Excel 2013 is compatible with a variety of different file formats, and you can even choose the default format in which Excel 2013 files are …
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 …
Printing an Excel spreadsheet can be difficult when the data that you have is not ideally suited for a piece of paper. It can be helpful …