Ðề: Find someone who can share my interest and listen to me.
You can learn English while using Excel.
To find the number of merged cells in Excel, you do the following:
Copy the column header (assuming the sheet name sheet A) and pasted into a new Sheet sdeet B (goal: find the merged cell without affecting the data sheet A).
Next you type the = sign on the empty cell of the first column of the sheet eg A2 B (from left to right), click open the sheet A, then you click on the boxes of the first column of the example A2 sheet and press ENTER to return to sheet B, click in cell A2 of sheet B and Fill to the right (to the end of the column you're looking for Merge Cells), then fill down to the last row containing data (you see sheet A contains the lines of some) Fill the sheet B you get there.
For Merge Cells Cell What you have to use Autofill to the title (menu> Data> Autofill), each column you click on the down arrow to select the number 0 and paint it a color to identify (the number 0 is the cell being Merge Cells).
Wish you successful.
---------- Post added at 10:27 ---------- Previous post was at 10:23 ----------
How to create a drop-down list in Excel 2003.
If you want to create a List (list) to select a cell type, as follows:
Step 1: First you must enter to make available a list of List (for example you have an import list in column H from H2 to H9 list)
Step 2: put the list in column H to column that you want to create a List (eg, column B), as follows: select the area to create a List (eg B2: B100, do not choose the subject line), from the menu click choose Data, Validation selected .. do Data Validation window appears, select the Settings tab, click Allow in the frame on the arrow will drop down a list we select list, click on Souce frame finished in column H mouse click select all region from H2: H9, then press the OK button. Try clicking on any one cell in region B2: B100 you will see the down arrow and select a name that will automatically enter into the cell you selected.
I wish you successful.
