Most valuable professional
  • Excel Book Excerpt

Excel Select 100 Columns in Subtotals

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

Select 100 Columns in Subtotals

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.


Figure 658 Individually click hundreds of checkboxes.

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.

<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: