Offset Function Dynamic Print Range

Dynamic Print Range

What is the Offset Function? You can read about the excel offset function here – there are several examples and explanations showing how the different parts of the offset function work. This page is going to show an example of a dynamic print range. Excel Offset Function

Read more

Offset Function

Excel Offset Function 5

What is the Offset Function? The offset function is a powerful Excel formula, the purpose of which is to return a single value or a range of values that is a given number of rows or columns from a specified reference (i.e. a specific cell – your

Read more

Automatically Alternate Row Coloring

Automatically alternate row coloring

Automatically Alternate Row Coloring in Excel Two Ways to Alternate Row Coloring in Excel If you’re using excel 2007 or 2010, probably the quickest and easiest way to get automatically alternate row coloring is by using Excel’s built-in table feature. However, there are several instances when the solution

Read more

Excel Shortcut Keys

Excel Shortcut Keys

If you spend a lot of time on the keyboard, learning a few tricks will not only speed things up but simplify your life.  All of the shortcut keys below are Excel focused.  This is a free template for download, and you can easily modify it to

Read more

Add a Scroll Bar

Excel Scroll Bar

There are several instances when having a scroll bar linked to an Excel chart can come in handy – it’s a great way to make your chart dynamic and can really enhance the functionality of an Excel dashboard. On this page, we’ll describe how to add a

Read more