You may want to get regular information from Web pages. You can paste into worksheets or you can get Excel to query a web page.
Go to the menu Data => Import External Data => New Web Query

The dialog box is a web browser. Type or paste your source webpage in the address box. Once the page has loaded look for the . If the page is structured well you should see you data with an arrow next to it. Click the arrow to select the data. Then Select Import. Select the position to download and press OK.

You can choose to import the formats and the full html of you need them.

This is great for bringing sports tables and scores into Excel. It looks like you are working on a spreadsheet while you are watching the score. Under the options you can set the table to refresh at intervals.

Fill down can be done in a number of ways

Here is my way

1. Select the cell(s) that contain the formula to be filled down (copied)
2. Use the scrollbars to move to the last cell;
3. Hold down the SHIFT key and click the last cell you want to fill. This selects all cells from the first to the last cell;
4. Press CTRL+D. This copies the formula from the first cell(s) to all the selected cells.

Concatenating Cells is essentially joining the contents of two or more cells together.
Try this,
Enter your first name in cell A1
Enter your surname in cell B1
in cell C1 enter the following formula:
=A1&" "&B1

This is actually three pieces of text when you include the ” “.