This free microsoft excel tips no 7 is telling to make your sheet tabs to be colourfull. It may can make your worksheet show more gorgeous and simpler to switch to another sheet


Here is the step to do this

1. Right click on the choosed sheet.
2. Click Tab Colour
3. Select your preffered colour
4. Done

May this tips can be useful for you.

{ 0 comments }

This free microsoft excel tips no 8 is telling to Protect Your Excel File with Your Own Password. It will be useful to increase protection of our file from unauthorized people to open it.

To place password in your file, do the following step :
1. When you save document click Tools
2. Click General Option
3. General Option Windows appear, fill your password to open or your password to modify. You can fill both password.
4. Clik OK, and retype your password to ensure you place the right password.
5. Click OK, and Your File now has been protected by your own password.

May it can be useful for you

{ 0 comments }

Excel Tips No 9 : Create Data Validation

June 28, 2011

This free microsoft excel tips no 9 is telling to Make Data Validation. Sometimes we need someone that filled our data inquiry, limited in a given number range value. It is very vital to make a standard value in the questionnaires to get valid analytical result. Here the step to do this1. Select cell that [...]

Read the full article →

Excel Tips No 10 : Include Print Date when You Print Report Automatically

June 25, 2011

This free microsoft excel tips no 10 is telling to Include Print Date when You Print Report Automatically. Sometimes,it is vital to place print date in your report to know when the report is printed. You can place it on report header or footer. This tips tell ho to write print date automatically. Its simple, [...]

Read the full article →

Excel Tips No 11 : More Easy in Moving Your Data

June 21, 2011

This free microsoft excel tips no 11 is telling to go data in your speadsheet more simple. Sometime we need to go a table to another area in our sheet. The common step is using cut and paste cell to other area. This tips tell how to get the same result in the more simple [...]

Read the full article →

Excel Tips No 12 : More Easy in CopyingYour Data

June 17, 2011

This free microsoft excel tips no 11 is telling to copy data in your speadsheet more simple. Sometime we need to copy a table to another area in our sheet. The common step is using cupy and paste cell to other area. This tips tell how to get the same result in the more simple [...]

Read the full article →

Excel Tips No 12 : More Easy in CopyingYour Data

June 17, 2011

This free microsoft excel tips no 11 is telling to copy data in your speadsheet more simple. Sometime we need to copy a table to another area in our sheet. The common step is using cupy and paste cell to other area. This tips tell how to get the same result in the more simple [...]

Read the full article →

Excel Tips No 12 : More Easy in CopyingYour Data

June 17, 2011

This free microsoft excel tips no 11 is telling to copy data in your speadsheet more simple. Sometime we need to copy a table to another area in our sheet. The common step is using cupy and paste cell to other area. This tips tell how to get the same result in the more simple [...]

Read the full article →

Excel Tips No 13 : Easy to Adjust Coloum Width

June 14, 2011

This free microsoft excel tips no 13 is telling to adjust Column Width in your microsoft excel spreadsheet more simple. The common way to set column width is by select Option Home - Format - Column Width (Excel 2007) or Format - Column Width (excel 2003). Here is the simple way to Adjust colum width [...]

Read the full article →

Excel Tips No 14 : Simple way to Create & Copy a Worksheet.

June 10, 2011

This free microsoft excel tips no 14 is telling a Simple way to Make & Copy Your Worksheet. The Common way to to this is make a worksheet and then copy all data from the ancient worksheet to the new worksheet. Here is the way to do this in more simple step: 1. Pointing your [...]

Read the full article →