Alchemist Sheets

A magical spreadsheet with formula reactivity and AI-powered transformations. Edit cells, create formulas with =, and transform data with the AI function.

Sheet

ABCDEFG
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

Available Functions

SUM(B2:B5)

Sum of values in range

AVERAGE(B2:B5)

Average of values in range

COUNT(A2:A5)

Count non-empty cells

MAX(D2:D5)

Maximum value in range

MIN(D2:D5)

Minimum value in range

AI(G2, "prompt")

Process cell content with AI

Quick Formula Creation

To easily create formulas with cell references:

  1. Click a cell and type = to start a formula
  2. Click on any other cell to add its reference to your formula
  3. Continue adding operators like +, -, * and more cell references
  4. When your formula is complete, press Enter to save it

Example: Type = and click on cells B2, type +, then click on B3

Enhanced Fill Handle

Fill handle now supports continuous drag operation:

  1. Click on any cell with content to select it
  2. Notice the blue square in the bottom-right corner (the fill handle)
  3. Click and hold the fill handle, then drag across multiple cells
  4. When you release, the content will be copied to all cells in the selection
  5. For formulas, cell references adjust automatically based on position

Try this: Enter a formula in one cell, then drag the fill handle down to apply it to an entire column!

AI Function Examples

Syntax: =AI(cell, "prompt")

  • =AI(A2, "Translate to Spanish") - Translates cell A2 content to Spanish
  • =AI(B3, "Summarize in 10 words") - Creates a 10-word summary of cell B3
  • =AI(C4, "Convert to bullet points") - Formats C4 content as bullet points
  • =AI(D5, "Extract keywords") - Extracts main keywords from D5