From the category archives:

Excel Tips & How-To

Excel Tips & Tricks: Changing default direction of cell movement

by Michelle MangenJune 22, 2009 Excel Tips & How-To

When working in Excel and you hit Enter by default moves down to the cell just below where you are working. However, you may want to move in a different direction? For example, I have mine set to move to the right as most times that is the direction I am filling data into my [...]

Read the full article →

Excel Shortcut & Tips: Customize your Toolbar to work more efficiently

by Michelle MangenJune 15, 2009 Excel Tips & How-To

Excel is an amazing program and as with all Microsoft Office products there are so many ways you can customize the software so that you can get maximum efficiency out of it. By modifying your Toolbar in Excel you will be able to “one” click on the task you wish to perform (similar to clicking [...]

Read the full article →

Excel Shortcut & Tip-Automatically Alternate Row Color

by Michelle MangenJune 8, 2009 Excel Tips & How-To

If  you have sheet that has a lot of rows it can be difficult to “read”. For example, I do a monthly rent roll for a Lender that has 235 rows. Using Conditional Formatting to alternate the row color makes it much easier to read for everyone. Of course, because I use this every month [...]

Read the full article →