Excel: Select 100 Columns in Subtotals

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Problem: My data set is a hundred columns wide. In the Subtotal dialog, I have to click 6 columns, then scroll, click 6 more columns, then scroll. It is incredibly tedious. Having a "œSelect All" button would be incredibly helpful.

Strategy: Using the keyboard seems to be the fastest way. If you press the spacebar, the selected row will toggle from checked to unchecked. Scroll up, click on the words "œWeek 1" to select that row. Then, begin pressing spacebar, down arrow, spacebar, down arrow. It will still be tedious, but faster than using the mouse and scrolling.

  1. Individually click hundreds of checkboxes.

For more resources for Microsoft Excel