Let’s assume you have many worksheets, all in the same structure. Or they are at least in a similar structure. Now, you want to combine them into one worksheet. For example copying them underneath each other so that you can conduct lookups or insert PivotTables. In this article, you learn four methods to merge sheets… Continue reading Merge Sheets: Easily Copy Excel Sheets Underneath on One Sheet!
Especially for large Excel workbooks with many sheets it’s crucial to organize the content. You should—for example—sort worksheets in a logic sequence. One way to sort sheets would be in an alphabetical order. This article introduces three simple methods for sorting Excel worksheets.
Sometimes you want to do changes to several worksheets at the same time. That requires, that all the worksheets have the same structure. So, how to do that?
Unhiding hidden worksheets in Excel was for a long time troublesome, especially if there were many hidden worksheets in your workbook. Fortunately, Microsoft has just released a new feature in Office 365 (now: “Microsoft 365) for unhiding multiple sheets at once. So far, so good. But what, if you want to unhide “very hidden” sheets?… Continue reading How to Unhide All Hidden & ‘Very Hidden’ Excel Sheets at Once