How to Determine the Day of the Week from a Numerical Date in Excel 2013

Excel 2013 has a lot of helpful tools and tricks that you can use to find information about data contained in a worksheet. One of these tricks involves the use of a formula to help you determine the day of the week for a numerical date in one of your cells. Our tutorial below will […]

How to Hide Comments and Indicators in Excel 2013

Comments in Microsoft Excel 2013 allow you to identify a problem or question that you have about data in a cell, without affecting the data itself. After you create a comment there is typically a small arrow at the top-right corner of the cell, called a comment indicator, which indicates that a comment is attached. […]

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