Description of the undiscovered tips about Excel Wednesday, September 28, 2005 MS Office Wha..cool tips for Technical Manager (e.g using excel lots ) :) Join text in multiple columns Set the print area Exclude duplicate items in a list Multiply text values by 1 to change text to numbers Use the Text Import Wizard to change text to numbers Sort decimal numbers in an outline Use a data form to add records to a list Enter the current date or time View the arguments in a formula Enter the same text or formula in a range of cells Link a text box to data in a cell Link a picture to a cell range Troubleshoot a long formula View a graphical map of a defined name Fill blank cells in a column with contents from a previous cell Switch from a relative reference to an absolute reference Use the OFFSET function to modify data in cells that are inserted Use the Advanced Filter command Use conditional sums to total data Use conditional sums to count data Use the INDEX function and the MATCH function to look up data Drag the fill handle to create a number series Automatically fill data Use the VLOOKUP function with unsorted data Return every third number Round to the nearest penny Install and use Microsoft Excel Help Do not open and save directly from a floppy disk Use one keystroke to create a new chart or worksheet Set up multiple print areas on the same worksheet Cheers.. Suresh Behera