You want to display the name of the author or who has saved the Excel file the last time? Or you want to insert the date last saved, the date created or the file size into an Excel cell? Unfortunately, there is no way without some disadvantages. Let’s take a look at three different methods.
Category: VBA
Hyperlink: 3 Ways of How to Extract the Link from an Excel Cell
Sometimes, you copy webpages. Or just a link. Or you receive an Excel sheet with links in it. In such case, you often want to extract the hyperlink addresses from the cells. There are basically just three options for extracting the hyperlink address from an Excel cell.
How to Easily Return the Indentation of an Excel Cell!
Sometimes, you receive data which is organized by indentations. For example in an Excel table, the Total has no indentation whereas all single values are indented. This could be (typically…) the case for tables provided by some controlling tools. How to deal with that? What do you do if you want to sum up all… Continue reading How to Easily Return the Indentation of an Excel Cell!
MINIF & MAXIF: 5 Ways to Insert a Conditional Minimum/Maximum Value
Until Excel 2016, there is no built-in MINIF-Formula in Excel. There are COUNTIF, SUMIF, AVERAGEIF but no MINIF nor MAXIF before the latest version. However, there are situations in which you need to get the minimum under a condition. In the following post, we are going to illustrate how to returnthe minimum using a simple example.… Continue reading MINIF & MAXIF: 5 Ways to Insert a Conditional Minimum/Maximum Value
How to Unhide All Hidden & ‘Very Hidden’ Excel Sheets at Once
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