Working with date values in Excel is not as easy as it sounds. Should you enter dd/mm/yy or mm/dd/yy? Do you enter slashes or dashes or dots? And what was the date of the third Monday in July last year anyway? Pop-up Excel Calendar solves all the headaches by adding a pop-up calendar to your Excel.
Pop-up Excel Calendar can be activated automatically or manually.
The calendar is activated automatically whenever you click or enter a date cell in which you need to enter a date value. Pop-up Excel Calendar can identify a cell as a date cell if the target cell meets one of the following criterions: the cell has a date format; the cell has a date-like value; the cell is underneath a cell with a date value or format in it; the cell is underneath a cell that has some form of the word "date" in it.
When Pop-up Excel Calendar identifies a cell as a date cell, an in-cell icon button is shown automatically near the target cell. Click the icon button to open the calendar and pick a date.
If the target cell can not be identified as a date cell, you can open the calendar manually. By default, Pop-up Excel Calendar adds commands for opening the calendar to the cell right-click menu (which is displayed when you right click a cell), the Standard toolbar, and the Pop-up Excel Calendar toolbar. However, you can choose to remove/add any of the command buttons whenever you like.
Pop-up Excel Calendar works even if the Excel workbook / template window is split, frozen, or zoomed. It also provides options to let you control how the calendar works. You can set the First Day of Week option to adjust the calendar layout; set the Default Date Format option to have the calendar set a date format if the target cell is not formatted as date.
With this new version you can have the calendar form display automatically. It also supports custom date formats. All registered users with a valid license key are entitled to upgrade to the new version free of charge.
Excel VBA and Excel UserForms Training 1
Save over 45% off the individual prices Each lessson is between 5 and 10 Word Document pages long. There are also 10 Excel Workbook Examples.Lesson 10 has Time Saving Microsoft Excel Solutions. It is a downloadable book in Windows help file format that contains hundreds of solutions to Microsoft ...
Create PDFs 1.3
Easy to use tool automatically converts all Excel files in a folder pdf format Easy to use tool that automates the creation of pdf documents. Create PDFs converts all the Excel files in a selected folder to PDF format. No need to open each file manually. Uses the free Microsoft pdf writer. Works with Excel 2007. ...
Worksheet Sort 3.0
Sort worksheets in an Excel workbook A-Z or Z-A. Worksheet Sort will sort the worksheets in an Excel workbook in either ascending (A-Z) or descending (Z-A) order. The trial version is limited to sorting only 10 worksheets in a workbook. ...
Fuzzy Match 1.5
Excel add in tool that evaluates cell contents and returns probability of match Microsoft Excel tool that evaluates the contents of two cells and gives a probability of a match; a value between 0 and 1 is returned. Easy to use custom function works just like any other Excel formula. Works with Excel 2000 2002 2003 2007. ...
XL Navigator 1.1
An add-in for navigating in Microsoft Excel. XL Navigator is an add-in that allows you to quickly and comfortably navigate and administer Workbooks, Spreadsheets, Names and Links of Microsoft Excel. XL Navigator shows all opened Excel workbooks as a thoroughly organized catalogue that allows you ...
Advanced Excel Find & Replace 2.1
Microsoft Excel add-in that much extends Excel's build-in Find. Advanced Excel Find & Replace is an add-in for Microsoft Excel 2000, Excel XP (2002) and Excel 2003. It enhances Excel's built-in Find and in addition to all features of the built-in Find allows simultaneous search in values, formulas and comments, search ...
FindReplaceExcel 1.01
Find + replace excel text + formulas in cells in batches automatically FindReplaceExcel is a find/replace utility to search Excel files for text, values and comments and replace the text inside cells automatically without opening workbooks . The program can search ranges in worksheets. Multiple drives and directories can ...
4TOPS Compare Excel Files 2.0
Program to compare excel files gives easy to interpret reports using HTML 4TOPS Compare Excel Files is an easy to use program that clearly reports where and what the differences between two Excel workbooks are. features: - Easy to interpret reports using HTML; - Differences in the Analysis report and Visualization reports are ...
Excel Misprint Finder 1.0
Aren't you sick and tired of misprints? It is a specially designed tool to help you polish off all misprints in your Excel workbook.The Misprint Finder is an add-in for MS Excel 2000 & XP that:* Quickly finds values with one to four misprints* Recognizes ...
CZ Excel Converter 1.0
CZ Excel Converter is the award-winning, powerful batch document converter that converts between XLS, HTML, XML, MTH, CSV, TEXT, DBF, Lotus 1-2-3, WKS, WQ1, SLK, DIF and more!The software supports batch conversion, command line and folder watcher. Batch ...
