Question

What is Split Worksheet? Write down the steps to split a worksheet.

Answer 1

Split panes to lock rows or columns in separate worksheet areas. ... You cansplit a worksheet on columns, too. Select the column to the right of the column where you want the split, and use the Split command. Or, you cansplit on a row and a column.