How to Combine Two Text Columns in Excel 2013

There are many ways to store data in Excel spreadsheets, and one common choice is placing each piece of data in a separate column. This allows for a lot of flexibility when you need to make changes to everything in a column, but it can seem daunting when you need to combine the data from […]

How to Enable AutoComplete in Excel 2013

Excel 2013 has an AutoComplete option that can be turned on or off depending on individual user preference. So if you use Excel 2013 on another computer and find AutoComplete to be helpful, or if you simply want to see if you like it, then you may be looking for a way to enable AutoComplete […]

How to Prevent a Picture from Printing in Excel 2013

There are many reasons why you might insert a picture into an Excel 2013 worksheet, but you may find that the picture is problematic when you go to print that spreadsheet. Whether the picture is not important for the data that you are printing, or you simply don’t want to waste the ink to print […]

How to Set a 50 Percent Print Scale in Excel 2013

Excel spreadsheets that span multiple pages can be difficult to read on the printed page. Fortunately Excel has several tools that you can use to adjust the way that your data prints. One such tool is the print scale setting, where you can enter a percentage by which to grow or shrink your spreadsheet. Our […]

Free Guide – 7 Useful Excel Sheets to Instantly Improve Your Family’s Budget

Proper money management can go a long way in making sure that your family has budgeted correctly for monthly and daily expenses, while stillĀ putting some money into savings in the event of an emergency. If part of your New Year’s resolution involved getting a better handle on your budget, then simply getting started is one […]

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