By default, in Excel, when you press the Enter key, you will move down to the cell below. When you need to copy a formula down through a number of cells, this is a little bit of a pain; you

So many people use Microsoft Excel daily that it would seem to be the one application everyone understands. It isn’t. While most people use Excel daily, not everyone knows how to do much beyond the basics, and no one knows

Finding information about functions can be difficult, especially if you do not know the name of the function, or if you are trying to find a function that will do what you need. Two ways to find help with functions

Freeze Panes in Excel allow users to scroll for information and still have the ability to match column and row headers, allowing a user to not need to constantly scroll back and forth in a worksheet to figure out which

All too often, we believe our Excel files are something they are not. An example of this is when someone instructs us to use an Excel template, but the file is actually a regular notebook. This can lead to disaster,

The light gray Excel gridlines are a normal part of Excel workbooks when opening a new blank workbook. For some, these gridlines are annoying. Unfortunately, there are no default settings for eliminating gridlines in new workbooks. However, there are a

Are you tired of holding printed sheets next to each other to compare the row or column headers? Ever wonder how to get the header rows or columns to show up on each printed page of an Excel worksheet? This

Ever wonder how somebody created a dropdown list in Excel? There are two ways to do this. 1. Create the list in Excel somewhere, or have your list handy, so you can type the choices in your list. 2. Select

Creating an Excel template allows a person to reuse a workbook setup over and over, without the need to recreate the wheel every time, nor continuously to clean out old information. By using a template, your workbook is ready and

A Timeline can be inserted into your PivotChart, if dates are listed in your table. After you insert your PivotChart, add a Timeline, located in the Filters group of the Insert tab. Watch this short video to see a Timeline