Make a compressed folder in Windows XP

Sending a large number of files as an attachment to an email could be a tedious process. There is a chance you may miss one file.

An easy solution is to group all the files in a compressed folder/zipped folder. This way, sending multiple files would be a very easy job.

But how do you compress a group of files in Windows XP?

Compressing a file, a group of files or a folder in Windows XP is an easy three step process.

Step 1

- Open Windows Explorer

- Go to the folder of the files you wish to compress.

- Select the files to be compressed.

Step 2

- On the menu bar, click the File menu.

Step 3

- Point the mouse pointer to Send to (another drop down menu opens), then point to Compressed (Zipped) Folder.

That's it! Your files are now group in one compressed folder which can be easily sent as attachment to emails.

Make Default Sheet in Excel

There are times when you want a certain sheet in Excel to open up everytime you want to open excel.

Well, you're problem is solved my friend with a few codings, you can make a certain sheet your default sheet.

Just follow this simple steps:

1. Right click the tab of the sheet you wish to be your default sheet.

(Image when tab is right clicked)

2. Click/Choose View Code

3. Visual Basic for Application will now be displayed on screen.

4. Double click "ThisWorkbook"

5. Code Editor Window opens

6. In between Private Sub Workbook_Open() and End Sub, enter the following code:

Sheets("nameofmysheet").Activate

Where "nameofmysheet" is the name of the sheet/tab you wish to be displayed first. By

default, the sheet/tab is named "Sheet1".

That's all for making a certain sheet your default sheet in MS Excel.

Hope this helps folks,

Till next tutorial.

See you then...