Quickly move to the end or beginning of big chunks of data.
Archive for the ‘excel’ Category
Navigation through Excel sheet – End Of Data
Monday, August 2nd, 2010Master/Detail drop down lookup in Excel
Tuesday, June 29th, 2010Excellent trick when you should have Master/Detail lookup combo box in your Excel form. This is quite often needed. Here is an example:
View locked and unlocked cells in Excel
Friday, April 9th, 2010Since last time I’ve become kind of Excel guru ), I want to start publishing some of my tips discovered.
In this post I will explain how to quickly identify all Locked and Unlocked cells on the sheet using Office 2007. This is very useful for developing complex sheets.
