How to Lock a Picture to a Cell in Excel 2011

Occasionally you will need to add a picture to a spreadsheet, or someone will send you a spreadsheet with pictures in it. But if you need to move a row or column that contains pictures, you will probably run into a problem where the data in the row or column moves, but the pictures do […]

How to Remove Leading Spaces in Excel 2013

Last updated: January 19, 2017 You might discover that you need to know how to remove leading spaces in Excel when you have data that is difficult to work with, and you can’t figure out why. Sorting data alphabetically is a very useful ability that can make the information in your Excel worksheet easier to […]

How to Create a New Worksheet in Excel 2013

A Microsoft Excel file is called a workbook, and a single workbook can contain multiple worksheets. This is helpful when you have a lot of data for a single purpose, but which may not necessarily belong on a spreadsheet together. Excel workbooks will typically include three worksheets by default, but that number can be modified […]

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 […]