How to Merge Sheets from multiple Excel Files into one .xls file
First open a blank workbook (let suppose name is TEMP) then open the excel file whose sheet you want to merge in to one file (let suppose name is XYZ). Then from the bottom of workbook select the sheet you want to merge (let suppose name is SHEET1) right click in to sheet name and select the option MOVE OR COPY. A new little window will appear from the “To Book” option select the workbook in which you want to merge (i.e. TEMP) then tick on “Create a copy” option. Then click OK.
REPEAT THIS EXERCISE FOR ALL THE SHEET.
Advanced Excel
I am Herewith posting Advanced Excel details.
Click Here To Download Ready Reckoner for Microsoft Excel 2003
Convert Num to Word
Dear All,
Please find the attachment.
1. Save as “Microsoft Office Excel Add In” file.
2. Open Excel > Tools > Add Ins..
3. Click on “Num To Word” Press Ok.
4. Now you can use this function from: Excel > Insert > Function > User Defined.
Note: This function will not work in other PCs where it is not installed.
Excel – Create a Summary
This example demonstrates how to create a summary sheet of data from a number of sheets. Relevant data should be in the same position on each sheet.
Link in to Excel Sheet
Please see attached Excel file in which I mentioned how to give link to other sheets.
Excel Amazing Traffic Light Formatting
Here is another way to highlight data status using traffic lighting.
This technique also uses conditional formatting as its basis, but unlike the previous traffic lighting example.
A traffic light image is overlaid on top of conditionally formatted cells to give an immediately familiar visual effect.
Categories: Uncategorized Tags: Excel, Formatting