Compare2, a tool to compare two sheets using formulas
Tool will compare between two sheets using formula/functions method. Once you type in full folder locations (for both files), file names and sheets names in...
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...
Excel ad from early 90s
Guess what I just found in my old archive !...
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,...