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
Microsoft Excel the best software, in my opinion, that is created by human being. In this blog, you will find related stuff with this software. I am not here to solve any problem with Excel. I am here to helping you all and my self to understand the software and gain more knowledge about it.
Subscribe to:
Post Comments (Atom)
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...
-
If you need to analyze data from a Web site, you might be in for a bunch of tedious retyping. Under the right circumstances, however, Excel ...
-
Excel provides several underline formats to give your spreadsheets a professional look and to make them easier to read at a glance. For exam...
-
I was working on my data sheet and countered with one problem I required filters in two row ranges on being specific I want the first fil...
Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging
ReplyDeleteMicrosoft Excel Training in Electronic City
https://nelsonmstips.weebly.com/blog/how-licensed-microsoft-office-enhances-your-business-operations
ReplyDelete