Excel Tips & Tricks: Changing default direction of cell movement

Excel Tips & Tricks: Changing default direction of cell movement

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...

Excel Shortcut & Tip-Automatically Alternate Row Color

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,...