by David Hakala

When you press the Enter key in an Excel worksheet, it normally drops you down to the next cell in the column. But it doesn’t have to be that way. Excel allows you to specify to which cell the selection goes after you press the Enter key, or whether the selection remains unchanged.
Click to continue reading…

Create new Worksheet from Master Using Macro in Excel 97, 2000, 2002, 2003, and 2007

in applications

Set Microsoft Excel up to perform a repetitive task even if Excel’s macro recorder won’t record it. A bit of code will allow a new worksheet to be created from a master.

Read the full article