Delete All Empty Rows

Select all columns containing data.

Click the Sort icon (either Ascending or Descending).

Line Break Character

Want to find a line break in Excel?

Here’s how you do it.

The Line Break character is the ASCII character 10. To find this open the find dialog box. In the find field hold down the ALT key and press 0 0 1 0.  You have to use the number pad on the keyboard. You CAN’T use the numbers at the top. If you are using a laptop there is most likely a Function key that you have to press to get the number pad. After you do this you may or may not see anything in the text box. In Excel 2007 the text cursor becomes a dot instead of a vertical bar.

If you are replacing the line break be sure to replace it with a space other wise it will connect the two lines without a space.

Search and Replace Special Characters

Add a ~(tilda) before these special characters in the search field to find or replace them from your Excel document.

~*

~~

~?

JavaScript: Check and Uncheck All Checkboxes

So you want to know how to check and uncheck all or some of the checkboxes on your web page? Let me show you how.

Let’s start with the form.


<form name="form" action="" method="">
<input type="checkbox" name="list[]" value="1">1<br>
<input type="checkbox" name="list[]" value="2">2<br>
<input type="checkbox" name="list[]" value="3">3<br>
<input type="checkbox" name="list[]" value="4">4<br>
<input type="button" name="CheckAll" value="Check All"
onClick="checkAll(document.myform.list)">
<input type="button" name="UnCheckAll" value="Uncheck All"
onClick="uncheckAll(document.myform.list)">
</form>

Here I have created a form with no action and no method for testing purposes. The name for the text boxes have the brackets after them so the results will be put into an array.

Let’s take a look at the JavaScript.