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

Remove Non Printable Items from Text

To Remove None Printable items from the cell containing text we just have to use a simple formula

=Clean(Cell number)

For Example In cell A1 you have text with some unwanted marks ahead of it just put a formula in Cell B1 =clean(A1) now you will see there are no non printable items are there they are gone now copy this and use past special and past value option your text is there without not printable items

Regards
Hemant