Category: Worksheet

Shades of gray

We need this to be documented s8mewhere So, here it is...

Recover the unrecoverable

Working a lot with Excel means seeing lots of errors and bugs inside Excel Some of those are not likely bugs, but more like reaching...

SimpleANBox

This is a financial box, a saving account, a credit, a loan, or any other financial amount that has input and output. During my time...

Skills Grid

A small Excel file to show how we can create a chart-like Excel sheet Used in my Resume to show different skill sets and the...

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,...

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...