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.
(more…)
by David Hakala
Sometimes you have a repetitive task that cannot be recorded by Excel’s macro recorder. Take, for instance, this fairly common example. You need to create a new worksheet, give it a name, place it at the end of all the tabs in your workbook, and save the updated workbook.
(more…)
Powered by WordPress