The processing server is unreachable right now (maintenance or network). Uploads will fail; please try again later.
Splits the sheet shown when the file opens (a header name is looked up on every sheet); formulas become their last calculated values.
standbyChoose a file
Upload the workbook, enter the header text (e.g. Department) or the column letter (e.g. B) and press Split. Every distinct value in that column becomes its own file, downloaded as a zip.
Yes. Tick the separate tabs option: each value gets its own tab, named after the value.
Yes. The header and any title rows above it appear in every part, with fonts, fills, borders, number formats, column widths and frozen panes copied.
They go into a part called (空白 blank), so nothing is lost.
Formulas become their last calculated value: rows move to new positions, so the original references would point at the wrong cells.
If you split into tabs, take the result straight to Clean for sharing. If you split into files, unzip them and clean them all at once on that page.
You can filter and copy each value by hand, or write a VBA loop. With many values that takes a while; here it's done in one go.