Excel stops copying the formula when it reaches the last cell with adjacent data. Enter "=Average (C:C)-2.66*Average (A:A)" in cell D2 and copy the formula down the column to create the lower limit.

Learn how to use a data validation control to allow users to select when to run multiple VBA procedures in Microsoft Excel.

Copy graphs with lot more professional and cleaner look in your presentations from your Excel book, using Ctrl+Alt+V - Windows Enhanced MetaFile.

Essential Shortcuts Aside from the well-known Excel keyboard shortcuts, these are the ones I use the most often and save me the most time.