One of the first thing my Excel Macros & VBA students want to learn is how to protect their precious code. Learn the simple, straightforward method.
Category Archive: Ask Jackie
Ask Jackie: How do I copy and paste a cell’s comments? Excel Tip by @learntech
by Jackie Kiadii – Atlanta-based Excel Trainer Question: This question came up in a recent Excel for Peak Performers course. I have a comment in one cell that applies to many cells. I really do not want to type the same comment 50 or so times. Since the data in each cell is different, a …
Word 2007 Tutorial – How to Get Rid of the Calibri Default Font
While teaching a Word 2007 course recently, a student mentioned how annoying it was to have to change the font every time she started a new document. (As you may know, Word 2007 comes with a default font of Calibri.) Fortunately, changing this option is really easy. Type CTRL D to launch the Font dialog …
Excel 2003 – Control Enter Key Action
Question: When I hit enter after typing an item, Excel automatically takes me to the cell below the current cell. Is there anyway to change this so that it moves to the cell on the right? Answer: Changing this feature can be valuable, particularly when you have to do a lot of data entry. Here’s …