alt

I know that a lot of you know many keyboard shortcuts that you use all the time in MS Excel, but I have a couple to share with you in this article that I don't think that most of you are aware of, and ones which I find to be absolutely helpful and ... real time savers. I think you will agree with me. Follow the steps below: To insert an autosum, click ALT + = To resize the Excel formula bar, click CTRL + SHIFT +U (2007 only) To Allow for the selection of a named style by typing the first few letters of the style name click ALT + ' In 2007 bring up the style details box CTRL + Y Repeat last action ... (view more)

A reader recently wrote to ask "Once a table of contents has been created, can you change the page numbers appearing on the right side of the TO?" I am assuming that the reader is talking about an automatically generated Table of Contents (TOC). And ... if that is the case, the answer is yes, absolutely! The caveat is that you have to know how to create an automatically generated TOC in order to update it when you add more text. You can generate a table of contents using Word's built-in styles, such as Heading 1, 2, and 3, or by creating and using your own custom styles. If you have a document ... (view more)

I am sure that a lot of my readers have no idea what the lowly F4 key will do for them in MS Outlook. So I feel the need to educate you as to what this little key can actually do for you. I think you will see that it is quite a little performer! Try ... the two features below and you will become a believer:CTRL + F4 will close a file. ALT + F4 will close the program. Perhaps some of you have, in the past, tried CTRL + F4 when you h ad an email or appointment open and alas and alack -- nothing happened. In MS Outlook, you use ALT + F4 to close a currently open item. It will not close the entire ... (view more)

Many times, in an office setting, you have an Excel spreadsheet that has to be sent to different departments on a weekly basis. Even if you have a distribution list setup in MS Outlook, it still takes some time to setup your e-mail and proof it ... before sending it out. Why not let MS Excel do it for you? Follow the steps below to lighten your workload: Launch MS Excel if it is not already open. Open the workbook containing the report you want to send. Click ALT + F11. The Visual Basic Editor will open. In the Project-VBA Project pane, double-click ThisWorkbook. Go to Insert | Procedure. Click ... (view more)