Split Range command (Data menu)

Use this command to divide a range of data into additional rows or columns. This command displays the Split Range dialog box to specify the necessary settings to carry out the command.

This command is not available when the currently active worksheet is empty.

Shortcuts

Toolbar: