Home     About Us     RSSRSS

Archives: Ms Office

Excel: The Formula Doesn’t Update in the Column

March 21, 2013 by @HKw@! | No Comments | Filed in Excel, Ms Office

Excel2010I have encounter a problem where I have input the figure and using the same formula, but it doesn’t update the correct result even though I have clicked on the ‘Refresh’ button.

Normally, this problem is caused by the Calculation setting for Microsoft Excel.

To update the correct result with formula, please follow the steps as below: (more…)

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: , , ,