Home     About Us     RSSRSS

Archives: Excel

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.

Excel Tutorial: How do I round up the number with multiple decimal point

October 20, 2011 by @HKw@! | No Comments | Filed in Excel, Ms Office

In Excel, there are two method to round up the value into decimal point.

1st Method :

  • Highlight the cell that you need to round up.
  • Right click on the mouse and choose ‘Format Cells’.


Tags: , ,