by Tom Chandler | Oct 4, 2024 | Macros, Spreadsheets
In Microsoft Word and Excel, if you want to create a macro, you will want to use the Developer tab. To learn how to add this useful tab to your ribbon, click the Get Started button below.
by Tom Chandler | Jun 29, 2022 | Spreadsheets
This week’s Excel VBA macro shows you how to program a cut and paste action. Three examples are shown in the image above: The first uses four statements to cut a range of cells, reposition the cursor, paste, and finally turn off the cut/copy mode. The second example...
by Tom Chandler | Jun 28, 2022 | Spreadsheets
Excel lets you apply multiple formatting features with either the mouse or the keyboard. Some keyboard shortcuts are intuitive, such as Ctrl B for Bold and Ctrl I for Italics. Some keyboard shortcuts are not intuitive. For example, Alt HFK decreases the font size. As...
by Tom Chandler | Feb 28, 2022 | Spreadsheets
Ever wonder “How do I create a simple and easy to use PivotTable?” PivotTables are tools you can use in a spreadsheet to quickly create interactive summary reports (tables) from raw data. Because they are interactive, PivotTables allow you to easily do...
by Tom Chandler | Feb 2, 2021 | Spreadsheets
If you sort a list of month names in Excel, will January or April be first? No fooling, April is the first month, alphabetically. So, if you are not careful, sorting a list of month names may not get you what you wanted. You can however follow these steps to ensure...
by Tom Chandler | Jun 26, 2020 | Databases, Macros, Spreadsheets, Word Processing
Logging Events How do you keep track of the things you are supposed to do? Do you find that sometimes you do the same important things multiple times because you forgot that you had already done it? Worse, what happens when the auditors, boss, consultant, or mother...
