Insert a worksheet row above.
Assist Pro + → Data Cleaning → Rows & Columns → Insert Row Above
Part of Assist Pro+. Eligible tools can also be selected through Assist Pro’s 30-tool Vault allowance. Check the Vault for availability.
Open the tool and follow its prompts. Use a copy of your workbook when trying an action for the first time, then check the result.
Browse all toolsClick within the target data column, row or table, with your headers and data aligned. On Assist Pro + › Data Cleaning › Rows & Columns, choose Insert Row Above to insert a worksheet row above. Check adjacent formulas, hidden rows and table boundaries after the action.
Restructuring or cleaning a wide worksheet before building the final report or analysis.
Speeds restructuring rows and columns in reports when you need to insert a worksheet row above.
Aligns client source extracts to testing templates by helping insert a worksheet row above.