Microsoft Excel’s sheet view collaboration feature is not new, but now it supports hiding rows and columns and applying groups.

How to generate a list of hyperlinks in Excel It’s not unusual for a complex workbook to include a list of hyperlinks to each sheet in the workbook.

Learn how to merge multiple CSV files into one Excel sheet. You can combine or join more than one CSV file into one Excel Worksheet.

Applying the same formatting to each sheet in an Excel workbook is ideal when each of your sheets is set up the same, but it can be helpful in other circumstances as well.

If you cannot insert, add or create new cells in worksheets in Microsoft Excel, remove cell protection and unmerge the Rows to begin with.