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

Combining Ctrl + Shift + Arrow keys lets you extend your selection in any direction until Excel hits a blank cell. Start from the top-left corner of your data, try Ctrl + Shift + Right Arrow, then ...

A data set that occurs frequently consists of the values or the percentage breakdown of several categories for two time periods. A common way of plotting these data is to use a pair of pie charts.

Every time Dave publishes a story, you’ll get an alert straight to your inbox! Enter your email By clicking “Sign up”, you agree to receive emails from Business ...