Automatically numbering rows without error

A simple solution to numbering a row even if we delete or add a rows in between the serial numbers.

Formula for numbering the row is “=Row()”

What this formula do Row formula allow us to know the row no. in which we are working.

The question raise how we can use this formula for no the rows?

Answer is simple if you had start the counting from row no 10 then the formula will be “=Row()-9” than the cell will reflect value 1.

Use and enjoy working.

Select/Replace/Find Similar Format Cells

Some times people need to select similar format cells for analysis purpose or for editing the cells Now the question raise "How they can do this?" there is a simple process to this in excel same is defined here below. 1. Press "Ctrl + F" 2. Press "Options>>" 3. Click the arrow to the right of “Format” button (located at the right of the “Find what:” text box) 4. Select “Choose Format From Cell” (you can do it manually by using “Format” option instead) 5. Select the cell with the target format to select. The format is previewed at the right of “Find what:” text box 6. Press “Find All”. All the cells with the selected format are shown in the pane 7. Pick cells individually or press CTRL to select more than one to do the required action: replace, find, etc

one more important thing any one has to keep in mind while doing this is for using the find and replace command you have to select "clear find format".

Hope this tip will help you out some what.

By Numbers Excel 2003 v/s 2007