Excel Online Bulk Formula Copier

WHAT IT DOES

Excel Online Bulk Formula Copier is a spreadsheet productivity tool that streamlines the process of copying formulas across multiple cells in Excel Online. Instead of manually dragging the fill handle down or across, or using Ctrl+C / Ctrl+V repeatedly—a process that can be tedious and error-prone—this script automates the entire workflow. It reads the current Excel Online sheet page, identifies the selected cell with its formula or content, and allows you to bulk copy the formula to a specified number of cells in either the down or right direction. The tool handles the complete interaction sequence: detecting the active cell, selecting the target range, and performing the fill operation using Excel's native fill handle or copy-paste mechanism. Real-time feedback shows the active cell reference and content, and the operation completes with a confirmation. This is ideal for spreadsheet users, data analysts, accountants, and anyone who frequently needs to replicate formulas across large ranges in Excel Online.

WHERE IT RUNS

This script operates exclusively on Excel Online (*.office.com/* and *.live.com/*) as a userscript injected through the BotGentz extension. It runs within the context of your current browser tab and cannot access other tabs, bookmarks, history, or downloads. The script reads the page DOM to identify the active cell reference (from the name box) and formula/content (from the formula bar), and interacts with Excel Online's native UI controls—the fill handle, copy-paste keyboard events, and cell selection—to perform formula copying. All operations occur locally in your browser; no data is sent to external servers.

HOW TO USE

1. Open any Excel Online spreadsheet and select the cell containing the formula you want to copy.

2. Click the BotGentz extension icon and select "Excel Online Bulk Formula Copier" from the script list.

3. The panel opens on the right side of the page. It automatically detects and displays your active cell and its content.

4. Select the fill direction: "Down" or "Right" from the dropdown.

5. Enter the number of cells to fill (1-100) in the input field.

6. Toggle "Confirm before copy" if you want a confirmation before performing the fill.

7. Toggle "Paste special (values only)" to copy only values instead of formulas (if supported).

8. Click "Copy Formula" to begin. The script will copy the formula to the specified range.

9. The operation completes with a notification, and the sheet updates automatically.

WHY IT WORKS WHERE OTHERS FAIL

Many Excel Online automation tools fail because they attempt to call Microsoft's internal API endpoints or rely on brittle DOM selectors that change with every Office UI update. This script takes a resilient approach: it locates the actual interactive DOM elements Excel Online renders—the formula bar (for reading formula content), the name box (for reading active cell reference), and the fill handle (for performing the fill operation)—and triggers native events on them, exactly as a human would. The script uses a two-tier strategy for filling: first attempting to use the fill handle (the primary Excel method), then falling back to copy-paste with keyboard events if needed. It uses KeyboardEvent and MouseEvent simulations that mimic real user interactions, ensuring Excel's JavaScript UI registers the operations. By interacting at the UI layer rather than the framework layer, it remains functional across Microsoft's frequent code updates.

THE PANEL

The script uses BotGentz's BGPanel system, which provides a floating, draggable panel on the right side of your screen. Drag the panel by its header to reposition it anywhere on the page—the panel remembers its position per site and snaps to the nearest edge when released. Click the minimize button to collapse the panel to a small floating bubble; click the bubble to expand it back. Resize the panel vertically by dragging its bottom edge. Press the Escape key to close the panel entirely. All panel state (position, collapsed/expanded) is persisted locally using GM_setValue, so your preferences survive page reloads.

PLEASE NOTE

This userscript requires the free BotGentz browser extension—it is not a standalone application. Excel Online periodically updates its website layout and UI components; if the script stops working, an updated version may be released. The script requires that a cell with content be selected before copying; empty cells will result in copying blank content. This script does not store, transmit, or process any of your Excel data outside your local browser. It does not access your password, hidden inputs, or file inputs. All formula copying is performed through Excel Online's own authenticated session using the official user interface. Use responsibly and double-check the target range before confirming.