Sheet() and Sheets()

Getting total number of sheets (Sheets), or ID of this sheet (Sheet). The two new formulas Sheet() and Sheets() can do well, yes not perfect, we still need to have …

Convert cell into textbox

Often times, I found myself the need to design a sheet where I want users to input something, and I need them to focus on that particular single input (or …

Highlight dates dynamically

Conditional formatting is another powerful feature in Excel, especially when you combine it with functions A simple function as in below if you set it up inside Conditional formatting, can …