Matching the case in excel cell
Last answer on Aug 28, 2009 10:10:33 am BST Ashish, on May 1, 2009 7:32:45 am BSTBest answers for « Matching the case in excel cell » in :
Excel tips : How to insert date In an Excel cell Show Excel tips : How to insert date In an Excel cell
Below are some tips on how to insert date and time in an excel cell for a specific purpose:-
To insert current date, press “CTRL”+ “;” in the chosen cell.
To insert current...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel
Below is a tips of how to connect an Access database (MDB) in an application excel
Add reference
Microsoft DAO object librairy X.X
In a general module (eg Module1) paste the code below...
Inserting an animated gif in Excel ShowInserting an animated gif in Excel
To insert an animated gif image in an Excel spreadsheet, you must insert the image into a control.
To insert the control, go to the View menu/Toolbars/Control Toolbox
Activate the first button Design...
Colouring cells on conditions ShowColouring cells on conditions
There are many pratical functions under Excel which is not commonly used.
Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
Download Ms Word Excel Cracker ShowMs Word Excel Craker allows recover lost or forgotten passwords for .xls and .doc reated with Microsoft Office 97, 2000, 2003, XP or other word and excel compatible programs.
This application will be necessary in case you should have received an...
Worksheet - Cells ShowThe Concept of a Cell
A "cell" is the intersection between a line
(horizontal) and a column (vertical) on a worksheet. Thus, the name of
the line combined with the name of the column gives the cell's
coordinates (the term address is sometimes also...
Spreadsheets - Cell Selection ShowCell Selection
Spreadsheets are powerful tools for working with
data. However, to work with data, it is necessary to have tools to
rapidly choose the required cells.
Line Selection
An entire line can be chosen by clicking directly on the line...
You can do this by either of two ways:
|

