Chris Leong

Disoriented views from the rosy lens of an optimistic realist.
April 18, 2009

Microsoft Innovation Day @ TPM(13th May 2009)

digg_url = “http://www.chrisleong.net/index.php/2009/04/18/microsoft-innovation-day-tpm13th-may-2009/”;digg_title = “Microsoft Innovation Day @ TPM(13th May 2009)”;digg_bgcolor = “#F8F8EC”;digg_skin = “normal”;digg_url = undefined;digg_title = undefined;digg_bgcolor = undefined;digg_skin = undefined;

Microsoft is having its Innovation day @ TPM. In this event, they will be covering an overview about Windows Azure and covering security vulnerabilities of web applications.

Date: 13th May 2009

Time: 8:30am – 1:00pm

Venue: Resource Center Auditorium, TPM

 

If you are around the area, do come and checkout.

clip_image001

1 Comment
April 18, 2009

How to enter data in multiple sheet at the same time in Excel?

digg_url = “http://www.chrisleong.net/index.php/2009/04/18/how-to-enter-data-in-multiple-sheet-at-the-same-time-in-excel/”;digg_title = “How to enter data in multiple sheet at the same time in Excel?”;digg_bgcolor = “#F8F8EC”;digg_skin = “normal”;digg_url = undefined;digg_title = undefined;digg_bgcolor = undefined;digg_skin = undefined;

Here’s another tip that I found on the web. Hope its useful.

In Excel 2007, it’s possible to enter the same data into several worksheets without retyping or copying and pasting the text into each one. As an example, let’s say you want to put the same title text into different worksheets. One way to do this is to type the text in one worksheet, and then copy and paste the text into the other worksheets. If you have several worksheets, this can be very tedious.

An easier way to do this is to use the CTRL key to group worksheets. When worksheets are grouped, whatever you do to one worksheet affects all other worksheets.

  1. Start Excel. A new, blank workbook appears.
  2. Press and hold the CTRL key, and then click Sheet1, Sheet2, and Sheet3.

    This temporarily groups the worksheets. In the title bar, you should see the name of the workbook followed by the word [Group].

  3. Click in cell A1 in Sheet1, and then type:

    This data will appear in each sheet.

  4. Click Sheet2 and notice that the text you just typed in Sheet1 also appears in cell A1 of Sheet2. The text also appears in Sheet3.

    Tip   When you click another worksheet, Excel automatically ungroups the worksheets for you.

1 Comment