How to Add the Filename to the Header in Excel 2013
While you may already be familiar with specific formatting requirements that you need for school or work when working in Microsoft Word, it’s also possible …
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:
While you may already be familiar with specific formatting requirements that you need for school or work when working in Microsoft Word, it’s also possible …
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. …
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 …
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 …
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 …
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 …
Configuring the data in the cells of your Microsoft Excel spreadsheet is often just one part of creating and distributing data. While a spreadsheet may …
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 …
Microsoft Excel 2010 does its best to format the data you enter into your worksheets so that it is in the format that it thinks …
While some of the spreadsheets that you create in Microsoft Excel will fit comfortably onto a single, portrait sheet, a spreadsheet with a large number …
When you are trying to change the appearance of text or data in Excel, then you need to select the cell that you wish to …
Microsoft Excel 2010 is an almost infinitely customizable program. Aside from being able to choose, edit and modify every cell in your spreadsheet, you can …
Taking advantage of the ability to have multiple sheet tabs in Microsoft Excel is a great way to keep similar types of data organized. For …
While much of the data that you add to a spreadsheet in Microsoft Excel will probably go inside the cells, you may find that you …
If you spend a lot of time creating, editing, and formatting data in Microsoft Excel, then you might choose to create a chart that presents …
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 …
Placing your data into cells in Excel provides you with ways that you can compare and interact with your data. Typically this will involve various …
When you are first creating a set of data in Microsoft Excel 2010, there is probably a lot of data entry that is occurring. While …
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 …
Since Microsoft Excel spreadsheets often rely on the precision of data that is entered into cells, it’s helpful to be using the unit of measurement …
Does the font style that is used when you create new workbooks in Excel seem unappealing or tough to read? If you, as the creator …
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 …
If you’ve ever re-typed a lot of data in an Excel spreadsheet, then it’s probably something that you don’t want to do again. So if …
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 …
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 …
Print areas in Microsoft Excel are a good solution when you need to print some of the data in a file, but not all of …
If you are just entering the job market, or if you are looking to make a career change, then you have probably determined that a …
Excel spreadsheets show a pattern of lines on the screen that represent the perimeters of the cells. These are called gridlines, and they make it …
Sometimes you will have data in a spreadsheet that you don’t need to display but you don’t want to delete. This is the perfect situation …
Printing in Microsoft Excel can be a frustrating endeavor. The default settings are often not ideal, which can leave you wondering how to do things …
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, …
A Microsoft Excel workbook can frequently include a number of different tabs called worksheets. Each worksheet in your Excel file might include important information that …
A default spreadsheet in Microsoft Excel 2013 is going to display rows and columns of cells that are separated via a sequence of lines. These …
Excel workbooks are actually collections of different spreadsheets that you can use to organize data within one file. But the sheet navigation at the bottom …
Sometimes when you are editing an Excel file, you are working with sensitive information. Since anyone with access to your computer or the Excel spreadsheet …
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 …
Printed spreadsheets in Microsoft Excel for Office 365 can be difficult to read when there aren’t lines separating data. Many people will add these lines …
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 …
Managing information in Excel can be difficult as your spreadsheet gets larger and larger. It becomes even more difficult when you are removing duplicates in …
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 …
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 …
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 …
Sometimes the data that you type into a spreadsheet is something important that shouldn’t be changed by anyone. Use these steps to lock a cell …
Text that you enter into a cell in Microsoft Excel is going to go from left to right or right to left based on your …
There are a variety of different document types that you may have on your computer, including ones with a .csv file type. These are often …