Category: Non-functions

Edit directly in cell

One of the settings that I always change when I first get a new Excel installation is … Remove “Edit directly in cell” Here is...

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

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

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

Show developer tab

Starting Excel 2007, users are not getting easy access to developer stuff. Not sure why is that, but we can go around that, so quickly,...