Paste a block of cells
Copy cells from Excel or Google Sheets (or the sample below), click a cell and paste: the block is filled in from that cell, to the right and down. A value that is not a number is left out, and a message tells you how many.
Note: Try it
Click “Copy the numbers” under the sample. Then click the XS × Black cell of the empty table and press Ctrl+V (⌘V on a Mac): all 20 cells are filled at once.
| Size | Black | White | Navy | Olive |
|---|---|---|---|---|
| XS | 2 | 3 | 1 | 2 |
| S | 6 | 8 | 4 | 5 |
| M | 10 | 12 | 7 | 8 |
| L | 8 | 9 | 6 | 6 |
| XL | 3 | 4 | 2 | 2 |
|
Size
|
Black
|
White
|
Navy
|
Olive
|
|---|---|---|---|---|
|
XS
|
|
|
|
|
|
S
|
|
|
|
|
|
M
|
|
|
|
|
|
L
|
|
|
|
|
|
XL
|
|
|
|
|
Leave it empty and press Enter to clear the cells.
Move with the keyboard
The arrow keys move between cells. Enter goes down to the next size, Shift+Enter goes up. Tab moves to the next cell as usual.
Note: Try it
Click S × Black, type 9 and press Enter: you are in M × Black, ready to type the next count. Press the right arrow to go to M × White.
|
Size
|
Black
|
White
|
Navy
|
Olive
|
|---|---|---|---|---|
|
XS
|
|
|
|
|
|
S
|
|
|
|
|
|
M
|
|
|
|
|
|
L
|
|
|
|
|
|
XL
|
|
|
|
|
Leave it empty and press Enter to clear the cells.
Set a whole row or column to one value
A small pencil button sits next to each size and color. It is shown faintly at all times and gets darker when you point at the name. It fills every cell of that row or column with the same value. The pencil next to “Size” in the corner does the whole table.
Note: Try it
Click the pencil next to M on the left, type 6 and press Enter: every color of M becomes 6. Click the pencil again and press Enter with the box left empty: the row is cleared.
|
Size
|
Black
|
White
|
Navy
|
Olive
|
|---|---|---|---|---|
|
XS
|
|
|
|
|
|
S
|
|
|
|
|
|
M
|
|
|
|
|
|
L
|
|
|
|
|
|
XL
|
|
|
|
|
Leave it empty and press Enter to clear the cells.
Copy the table
The “Copy table” button above the table copies it with the names of the sizes and colors, ready to paste into Excel or Google Sheets.
Note: Try it
Click “Copy table”, then paste into a spreadsheet: the sizes are in the first column and the colors in the first row.
|
Size
|
Black
|
White
|
Navy
|
Olive
|
|---|---|---|---|---|
|
XS
|
|
|
|
|
|
S
|
|
|
|
|
|
M
|
|
|
|
|
|
L
|
|
|
|
|
|
XL
|
|
|
|
|
Leave it empty and press Enter to clear the cells.