Home     About Us     RSSRSS

Archives: Ms Office 2010

How to secure a workbook with a password

December 28, 2011 by @HKw@! | No Comments | Filed in Excel, Ms Office, Ms Office 2010

Password protecting your Excel Worksheet can prevent others open your works with your permission. To allow only authorized users to view or modify your data, you can help secure your entire workbook file with a password.

To do it, just follow below steps:-

  • Open your Excel workbook, on the File menu, click Save As.
(more…)

How to Split Text into Multiple Columns in Excel 2010

November 9, 2011 by @HKw@! | 2 Comments | Filed in Ms Office, Ms Office 2010

I found a very useful feature in Excel that allows you to split your data in one column into multiple columns based on a simple condition. This useful feature is ‘text to columns’ which is a option under the Data menu that allows information in a cell or range of cells to be split into columns.

Below is a simple tutorial to show you how to use this useful Excel feature.

Example:

I have a product list that represents product model and serial number. How do I split the product number (Sample A) into two separate columns (Sample B) by using excel? (more…)

Tags: , , ,

How to Create a Dropdown List in Microsoft Excel 2010

August 1, 2011 by @HKw@! | No Comments | Filed in Ms Office, Ms Office 2010

A dropdown list enable user to enter the data in more efficient way and standardized.

User is allowed to select the data from the list and to make the data easier to maintain.

To create the list for the drop down ,enter the data in a single column cells (more…)

Tags: ,