Here are the best uses of the Arrow keys in Excel with Scroll Lock mode turned on. Pressing Ctrl+Shift+Up, Down, Left, or Right Arrows selects the current cell and all cells above, below, to the left, ...

A selected Worksheet Tab in Microsoft Excel is white, but what if you want to add a splash of Color or distinctive Colors to your Worksheet Tab. Adding Color to your Worksheet Tabs is an easy way to ...

Excel doesn’t have a direct equivalent. To achieve the same result, you’d either have to piece together complex formulas with functions like SEARCH or write custom VBA scripts. While those approaches ...