MrExcel.com - Your One Stop for Excel Tips & Solutions

Select 100 Columns in Subtotals

September 27, 2022 - by

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.

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.

There are 270 numeric columns that you have to add Subtotals for. Choosing 270 individual checkboxes in the Subtotal dialog will not be fun.
Figure 718. Individually click hundreds of checkboxes.

This article is an excerpt from Power Excel With MrExcel

Title photo by Hal Gatewood on Unsplash