Hi Friends,

After a long break, I again started to work on this blog with new time-saving techniques and tricks for making the day to day working on the most useful software as per my understanding of Microsoft Excel.

Expecting the same response from all of you.

Thanks
Hemant

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

Download link for "21 Underground Excel Tips"

Hi all,

find the link of a good book for learning macros in Excel
http://www.4shared.com/office/bPq8kwot/21-underground-excel-tips-vol-.html
Regards

Microsoft Excel Bible 2007

Dear All

Here is the link to download Microsoft Excel 2007 Bible

http://www.4shared.com/office/bPq8kwot/21-underground-excel-tips-vol-.html

Regards
Hemant Koranne

Just past your name on single click

Here is the macro
Process is to use this is open your excel file click alt+F11 it will open one more window click on insert module & past this code in that module window. Replace your name with your own name
press save now close this window.
Sub yourname()
'
' yourname Macro
'
' Keyboard Shortcut: Ctrl+Shift+N
'
Application.WindowState = xlMinimized
Application.WindowState = xlNormal
ActiveCell.FormulaR1C1 = "yourname"
With Selection
.HorizontalAlignment = xlCenter
End With

ActiveCell.Offset(1, 0).Range("A1").Select
End Sub


Now just press Ctrl+Shift+N and see the magic.

Enjoy
Hemant