Multi-Cell Selection & Editing

Cells work like Google Sheets. One click selects the cell and outlines it. A second click, or a double-click, opens the editor and puts a cursor in it. Selecting does not open an editor, so you can drag across a range or press Delete without typing into anything.

Range selection works on the Breakdown, the BG breakdown on the Background tab, CS Back crew calls, PR Front, PR Back and Exhibit G. Click and drag across cells to select a range. It stays highlighted until you act on it or press Escape.

Ways to select:

• Click and drag across cells to select a range
• Hold Shift and click to extend your selection
• Drag the small square at the corner of a selected cell to copy its value into the cells next to it
• Tap and drag on a touch screen

With a range selected:

• Press Delete or Backspace to clear all selected cells
• Ctrl+C copies the range as tab-separated text, so it pastes into Excel or Google Sheets
• Ctrl+V pastes. One value pasted over a range fills every cell. A block copied from a spreadsheet fills from the first selected cell
• Right-click for a context menu with more options

Drag handles and taps work on tablets and phones. A drag has to travel about five pixels before it counts as a selection, so a tap with a slightly unsteady thumb still registers as a tap. Once a drag selection starts, page scrolling is suppressed until you lift off.