How-To Geek on MSN

Excel's UNIQUE function can't skip columns—unless you use this trick

Nest CHOOSECOLS inside UNIQUE to extract non-adjacent columns, and use INDIRECT for interactive header dropdowns.
How-To Geek on MSN

Stop manually hiding Excel rows and columns for meetings: Use this hidden tool instead

Excel's Custom Views tool lets you create a snapshot of your spreadsheet, allowing you to toggle between layouts.
TechRepublic

The best keyboard shortcuts for rows and columns in Microsoft Excel

The best keyboard shortcuts for rows and columns in Microsoft Excel Your email has been sent Everyone wants to work efficiently so learning ways to do small tasks quicker is always a win. All of the ...
TechRepublic

Use this Excel quick fill handle trick to insert partial rows and columns

Use this Excel quick fill handle trick to insert partial rows and columns Your email has been sent Learn the many ways to insert entire and partial rows and columns in Excel, including a fill handle ...