Monthly Archives: May 2011

Tips: How to enter the time in MS Excel as HH:MM:SS

Leave a reply

As everyone knows, we can get the time in Excel by using the Ctrl + Shift + ; keys. However, if we use these shortcut keys, we can get the time in HH:MM format. Therefore, if you wish to get the time format as HH:MM:SS (00:00:00), you can follow the following steps. While performing these steps, the main thing you’ve to note is that there are no short cut keys available to get the time format HH:MM:SS (00:00:00). However, we can create a macro and assign it to your shortcut key. You can also use the same shortcut keys that you use for getting the time.
Now, let’s check how to create a macro for setting the time.
•    First, click on Tools on the top menu to select Macro.
•    Now, select Visual Basic Editor.
•    After that, it is required to select Module from the Insert on the top menu.
•    Once you’ve performed the above steps, it is required to copy and paste the following code.

Continue reading →

Tips: How to add new and existing macros in Excel

Leave a reply

If you create a new Macro, you can choose to save it to your personal.xls file. Moreover, if you wish, you can add your existing Macros to the personal.xls file. Go through the following steps to perform both the actions.
How to add new macros
1.    It is required to point to Macro from the Tools menu.
2.    Now, select the Record New Macro option.
3.    After that, it is required to select Personal Macro Workbook in the Store Macro In list.
4.    Then, click OK to add your Macro normally.


Continue reading →

Tips: How to deploy the excel macros from a central file

Leave a reply

By default, when you create a macro for a Microsoft Excel worksheet, that macro works only on that worksheet. This behavior is okay as long the macro automates tasks that are unique to that worksheet. But have you ever found yourself recreating the same macro on more than one worksheet? If you have (and even if you haven’t), you can copy your macros to a worksheet called personal.xls. From there, your macros become available to you whenever you start Excel, and you can run them against the data on any open worksheet.
Surely, everyone knows about the Macro feature of the Microsoft Office Application. If you create a Macro for a Microsoft Excel worksheet, that will work only on that particular worksheet. This will be okay as long as the Macro automates the tasks that are unique to that particular worksheet. However, have you ever found a way to recreate the same macro on more than one worksheet? If so, you can copy your macros to a worksheet called personal .xls. Therefore, the Macros will be available to you whenever you start Excel and you will be able to run them against the data on any open worksheet. Moreover, as it is required to be careful here, it is not required to run the Macros at random and doing so will corrupt the data and cost you time and money. But if you have macros that you can use in a variety of situations, using a personal.xls file can also save your time and money.

Continue reading →