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. You can enable or disable the four options respectively.
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. For example, 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.
If you use date values in Microsoft Excel, why not give Pop-up Excel Calendar a try!
ReplaceMagic ExcelOnly Professional Have you ever been in situation that you need to change text, header, footer, comments, OLE object links, hyperlinks or even more in thousands of files and you had to open each file manually to make changes? With ReplaceMagic that is very simple.
Regression Analysis and Forecasting The Multiple Regression Analysis and Forecasting template provides a reliable identification of value drivers and forecasting business plan data. Advanced statistical tests performed include significance, autocorrelation and multicollinearity.
PDF2XL OCR: Convert PDF to Excel PDF2XL OCR is a data conversion tool, enabling business users to convert data from tables in PDF to Excel. With the PDF2XL OCR converter users can extract data quickly and easily from native and scanned PDF files to their computing environment.
Insert Text for Excel Insert Text is a Microsoft Excel add-on tool that allows users to quickly and easily insert text before or after existing text in a worksheet. The trial version is limited to 3 characters that can be inserted before and/or after any text.
Hide Worksheets Hide Worksheets is a must have excel add-on tool to quickly and easily hide or unhide worksheets. With Hide Worksheets it takes a matter of seconds to hide or unhide several or even all the worksheets in a workbook.
Data Manager for Excel Data Manager is an Excel add-in that allows you to convert worksheets into tables, conduct queries, and create forms. Using buttons that can be added to your forms, you can open forms, run macros, open hyperlinks, and send data to Microsoft Word.
Version: 1.0.1 Released: Sep, 1 2006 License: Shareware, $19.50 Expires: Expires after 30 Days
File size: 563 K Platforms: Windows XP/2000 Downloads: 18
Working with dates 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? Pop-up Excel Calendar solves all the headaches by adding a pop-up calendar to your Excel.