How to Count Blank And Non-Blank Cells in MS-Excel
Figuring out the number of non-blank cells in a range is not entirely straightforward. The COUNTBLANK function returns the number of blank cells in a range, but what if you want to count the number of non-blank cells in the same range? One way is to use the COUNTA function:=COUNTA(B1:B13). The problem with this formula […]
Free Excel Spreadsheet Unlock Online Utility – Crack Open XLS Files Without A Password
You can restrict or password protect your Microsoft Excel spreadsheet documents with a password. This prevents the document from being edited or modified. If you want to crack or unlock these Excel Spreadsheets which are XLS files, you can now do it using Free Excel Spreadsheet Unlock Online Utility. This application lets you upload an […]
How to Clear or Remove Dead Recent Files in Microsoft Excel
You might require accessing certain file repeatedly, while dealing with certain projects in your everyday work. You can view a list of recent spreadsheets in the “Recent Documents” panel appearing in the “Office Button” menu list. There might be certain files which lead you to ‘Dead Links’, because you changed the file path or deleted […]
Convert PDF Documents To Excel Files Online Accurately with PDFtoExcelOnline
Here is an useful web application which can be used to convert PDF documents to Excel files online for free. It is called PDFtoExcelOnline, an online convertor which can quickly and easily create highly editable XLS files accurately. Using this you can re-use tables and spreadsheets from PDF files in Excel Files. The program supports […]
How to Display Negative Time Values in MS-Excel
While calculating difference in your worksheet, you may require subtracting two time values. If you try subtracting a time elapsed earlier from a recent time, you will not be displayed with a negative value as expected.Instead, Excel displays to you a series of hash symbols (#). This generally happens because Excel, for Windows users by […]
Use A Combo Box to Create Drop Down Lists In Excel
Combo Box is a very useful feature in MS Excel. It lets you display the result of the drop down list you made. Say you want to select a month from a drop-down list, and have the month number (as in “3” for “March”) appear in a cell. Here’s how to go about it. First, […]
How to Open An HTML Page In MS-Excel
Excel is “Web aware,” meaning that the program knows how to handle hyperlinks. You can add a hyperlink in a document, click on that link, and Excel opens your Web browser and displays the contents of that link in the browser. (You can also create a hyperlink to other Office documents, including Excel workbooks.) You […]
How to Create An Add-In From MS-Excel Workbooks
Any Excel workbook can be converted to an add-in. To create a protected add-in file, first load the workbook that will become your add-in. Start the Visual Basic Editor by choosing Macro from the Tools menu, then choosing Visual Basic Editor. At the very top of the Project window, select the bold entry that declares […]
Make your Excel Spreadsheets interactive with CX Now
Making Excel spreadsheets and documents is a boring task which involves full of graphs and charts. But one thing that lacks in them is interaction. For example if you are using spreadsheets in some presentation of yours how many of your viewers actually look at those graphs in detail? If you use CX Now, they […]
« Newer Posts