Revision history [back]

To duplicate a formula in Google Sheets while keeping the cell references in even or odd-numbered cells, follow these steps: 1. Enter the formula in the desired cell. 2. Select the cell where the formula is entered by clicking on it. 3. Hover over the bottom right corner of the cell until the cursor turns into a plus sign (+). 4. Hold down the Ctrl key (Windows) or Command key (Mac). 5. Drag the corner of the cell to the right or left, depending on whether you want to keep the even or odd cell references. 6. Release the mouse button and the Ctrl/Command key. 7. The formula will be duplicated in the adjacent cells, with the cell references adjusted to maintain either even or odd-numbered columns.