How to Print Logical or Mathematical Errors of MS-Excel Cells
Sometimes cells contain logical or mathematical errors that need to be printed. How do you enable printing these errors on paper as proof? If you want the cell errors to be displayed in your printed Excel spreadsheets, you can choose to blank out all error values, or you can convert all cells with errors to […]
How to Print a Draft Copy in MS-Excel [ Save Time, Money, Ink ]
If you find yourself repeatedly printing the same Excel spreadsheet for proofing purposes, here is how you can save plenty of time and money using draft mode. In this mode by printing a draft copy of excel document, although your graphics might not look as nice and the letters and numbers not as sharp as […]
How to Generate Random Numbers in MS-Excel
If you want to generate random numbers for use in your Excel spreadsheet, the RAND function helps to generate numbers without any specifications. But what if you need to generate random numbers only within a given range? Just follow these simple steps to learn how. Click on the cell where you would like to begin […]
How to Save and Apply Filter Settings Faster in Excel
Excel has effective filter functions for evaluating table data. Separate filters can also be set for individual columns. This may be good but you have to set the criteria after each time you edit the data. Now that’s tedious! Though there is no evident way to save the filter settings, a user-defined view retains the […]
How to Convert Numbers To Text in MS-Excel [ Change Format ]
In Microsoft Excel, If you have a column of numbers and you need to convert them all to text, you would select the column, then go to Format > Cells, and on the ‘Number’ tab, change the formatting to ‘Text’. That doesn’t quite do it though, the formatted cells will still work as numbers, which […]
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 […]