How to Add the Filename to the Header in Excel 2013

When you have a lot of printed spreadsheets lying around your workspace, it can be difficult to determine which file a spreadsheet came from. One helpful way to solve this problem is to include identifying information in the header section of your worksheets. An effective way to do this is by inserting the filename in […]

How to Only Display the Year for a Date in Excel 2013

There are a lot of different options when it comes to formatting a date in Excel, and the variety of reasons that you might be storing dates in a spreadsheet will dictate the format that you select. But if the only important part of a date for your purposes is the year, then you might […]

How to Remove Gridlines in Excel 2013

One of the most common changes made to Excel spreadsheets that are going to be printed is the addition of gridlines. We have discussed how to print gridlines in Excel 2013, but what if you have a spreadsheet where you wish to stop gridlines from printing? Or what if you want to remove the gridlines […]

How to Make Page Layout the Default View in Excel 2010

Excel 2010 has a handful of different views that you can select between when viewing the data in a spreadsheet. We have previously shown you how to switch to the “Page Layout” view in the program, but that method will only allow you to change the view for the current sheet. If you create a […]

How to Turn Off the Auto Fill Options Button in Excel 2010

The Auto Fill feature in Microsoft Excel 2010 is very useful when you need to fill a series of cells with a series of numbers. In fact, it can be a real time-saver when you need to number rows in a spreadsheet.   But the Auto Fill feature often includes a pop-up Auto Fill Options […]

How to Only Have One Worksheet by Default in Excel 2013

Most workbooks in Microsoft Excel 2013 will include 3 worksheets by default. Using multiple worksheets within an Excel workbook is helpful when you have a lot of related data that does not belong in the same spreadsheet, but a large percentage of Excel users will rarely ever use more than one sheet within their workbooks. […]

How to View a List of Worksheets in Excel 2013

Using multiple worksheets within an Excel 2013 workbook is common when you have a lot of data that you want to keep in the same file, but which may not fit properly on one sheet. But as you begin to add more and more worksheets to one workbook, it can be difficult to navigate between […]

How to Split Full Names Into Two Cells in Excel 2013

Properly formatted data can make it much easier to complete tasks in Excel 2013, but it is rare that the data we have is ideally suited for the work that we need to do. This is common when working with names in Excel, as many companies and individuals will store full names in one cell […]

How to Remove Cell Indentation in Excel 2013

Spaces preceding data in a cell can make your spreadsheet look less professional, and may even create potential problems for people working with your data. This indentation can occur if you have copied and pasted the data from another source, or if if has been introduced to the worksheet by accident. Fortunately the amount of […]

How to Unhide a Worksheet in Excel 2013

It’s common to hide a worksheet in Excel 2013 if it contains information that should not be edited, if the data on the sheet isn’t relevant, or if there are too many tabs at the bottom of the workbook, and you only want to display the most important ones. But you may eventually need to […]