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

The TOCOL and TOROW functions are just two ways to rearrange data in Microsoft Excel. For example, you can flip the rows and ...

Calculating payroll can be a time-consuming endeavor, so automating as much of the process as possible will save you hundreds of hours by the end of the year. Fortunately, Microsoft Excel comes with a ...

Not everyone is an Excel spreadsheet expert and you may not always know how to write the formulas you need for a given data set. If you're having trouble figuring out the right formula for your data ...

Learn the secret to building interactive Excel reports with slicers and disconnected tables—no PivotTable needed for dynamic ...

Copying material from the internet into your Excel spreadsheet can be easy. Or pretty difficult. It all depends on what exactly you're trying to copy and how you would like it to appear in your ...

How to Print From Microsoft Excel and Avoid Printing Problems Your email has been sent Adjusting print settings, margins and sheet options are all great ways to avoid issues when printing an Excel ...

How to quickly make Excel subtotals stand out from the data Your email has been sent Microsoft Excel’s Subtotal feature is a great tool, but you can make the ...

CTRL+PgUp Switches between worksheet tabs, from left-to-right. CTRL+PgDn Switches between worksheet tabs, from right-to-left. CTRL+SHIFT+(Unhides any hidden rows within the selection. CTRL+SHIFT+& ...

Learn the secrets of Excel structured tables to save time, eliminate errors, and create smarter, more dynamic spreadsheets.

Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.