ILT – How to Add a Drop Down List (ComboBox) Into an Excel Cell

21-08-2012 How to configure an Excel cell, Excel Cell Range, Excel Column or Excel Row so that each of its cells will allow a user to select a value from a drop down list  (combo box) rather than typing? Steps Select the cell, range, row or column you want to display with a drop downContinue reading “ILT – How to Add a Drop Down List (ComboBox) Into an Excel Cell”

The Dashed Print Area Line in Excel

01-06-2012 Excel shows which content will be included in a page (when printed) with a dashed outline. If you can’t see this follow these steps (just one of them 🙂 ): Go to File Menu and Select Print You don’t have to do a print or anything just go to this view. This will remindContinue reading “The Dashed Print Area Line in Excel”

How To Temporarily Undo Or Turn Off Auto-Correct In Excel

22-05-2012 The auto correct feature can run you mad sometimes. For example, today I had to type EHR in Excel and it kept auto correcting it to HER 😦 I did a quick search and following are our options around this: Try Undo-ing (ctrl+z) – this works for earlier versions of excel but not forContinue reading “How To Temporarily Undo Or Turn Off Auto-Correct In Excel”