How to Copy a Worksheet in Excel 2013

I’ve created many Excel workbooks that contain multiple copies of the same worksheet. Whether the workbook is for a weekly or monthly report where each worksheet is a slightly modified version of the same template, or a worksheet from one book might be effectively used in another, it can save a lot of time and […]

How to Shrink Text to Make it Fit in a Cell in Excel 2013

Data that is entered into the cell of an Excel 2013 worksheet can often be larger than the cell itself. You have probably learned how to resize rows and columns to make them larger or smaller, but you may encounter a situation where you are unable to adjust cell sizes. In this case, the best […]

Keyboard Shortcuts to AutoFit Columns and Rows in Excel 2013

Excel can be a lot easier to use once you get comfortable using keyboard shortcuts to perform common actions. Copying and pasting, for example, is one action that can be made much quicker by using a keyboard instead of a mouse. But there are keyboard shortcuts for many more Excel functions, including the AutoFit Column […]

Three Ways to Fit to One Page in Excel 2013

Excel spreadsheets typically don’t print the way that you want them to. Occasionally you will get lucky and the number of rows or columns in your spreadsheet will match up perfectly with the dimensions of your printed page, but more often than not, you will have one column or one row that adds another page, […]

How to Count the Number of Blank Cells in a Range in Excel 2013

When entering data into a spreadsheet in Microsoft Excel 2013, it is not uncommon to have blank spaces that are missing data. On small spreadsheets, or in small ranges of cells, it can be easy to manually count the missing spaces. Unfortunately it is much more difficult as the spreadsheet gets larger, and it can […]

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