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

Nothing ruins a workflow like inserting new data and realizing your Excel table isn’t big enough. I used to drag those edges constantly—until I learned this simple trick that makes my tables expand on ...