The ability to move columns in Excel is a great benefit when dealing with long strands of data in Excel. Here's how to do it.
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 ...
You can hide and unhide rows in Excel by right-clicking, or reveal all hidden rows using the "Format" option in the "Home" tab.
By default, when you select a formula or source field in a dialog box, Enter mode is activated. You can see this in the ...