- 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.
For more resources for Microsoft Excel: