Carol's Corner Office

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)

There may be occasions when you want to omit a column or row of data from a printed copy of your spreadsheet, but still have the rest of your spreadsheet in your favorite format. Follow the steps below to learn how to hide a row or column: Select ... the column or row you would like to hide. Click Format | Column | Hide. To hide a row, click Format | Row | Hide. Follow the steps below to unhide rows or columns: Select the columns or rows you on either side of the hidden column. Click on Format | Column | Unhide to unhide the column. To unhide a row, click on Format | Row | Unhide. The column or ... (view more)

To ensure that you print only the area of your spreadsheet that is necessary, use the Set Print Area in MS Excel. Follow the instructions below to learn how: Click and drag to select the region of the spreadsheet that you would like to print. Click ... File | Print Area | Set Print Area. The Print Area has now been set. To clear the Print area: Click File | Print Area | Clear Print Area. This should clear the Print Area and reset MS Excel back to its default print settings. When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include ... (view more)

Because I love saving time and keystrokes, below you will find some very nice quick keys to use in MS PowerPoint: Create a new presentation -- Ctrl + N To open an existing presentation -- Ctrl + O Close your presentation -- Ctrl + W Save your ... presentation -- Ctrl + S Close the PowerPoint -- Alt + F4 F3 will start your presentation from the instant slide: Ctrl + Q will close all slide show windows Ctrl + Alt + Shift + P will pause Ctrl + Alt + Shift + R will resume your pause Ctrl + Alt + Shift + Left allows you go backward through your presentation Ctrl + Alt + Left will take you to your last ... (view more)

When you use the Caption feature in MS Word, a label and number can be assigned to each figure in your document. By default, MS Word assigns each figure a number beginning with number 1 and so on. However, if you do not want to use this number ... format for the figures, you have the option to change it. Follow the steps below to change the number format for a caption: Launch MS Word. Select the caption you want to change. Click Insert | Reference | Caption. From the Caption dialog box, click the Numbering button. Use the drop-down arrow beside Format, and select the number format you would like ... (view more)

As all my subscribers and readers know, I am all about saving time and keystrokes. With that in mind, check out the quick keys in MS Access below: To bring database window to the front -- F11 To cycle between open windows -- CTRL + F6 To restore the ... selected minimized window when all windows are minimized -- ENTER To open a new database -- CTRL + N To open an existing database -- CTRL + O To close MS Access -- ALT + F4 I think you will find these quick keys invaluable, just like me! When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that ... (view more)

The default behavior of the Enter key in MS Excel drives some folks crazy. When you click on Enter, some people would prefer that the cursor move to the next cell on the right, while others prefer the cursor move downward. Fortunately, MS Excel can ... accommodate these preferences and more. To change the way MS Excel reacts after you click Enter, follow the steps below: Click on Tools | Options. Click on the Edit tab. Click the Move Selection After Enter check box to activate the direction drop-down list. In the drop-down list, select from the following options: Down Right Up Left If you prefer ... (view more)

You can add the CTRL + ALT + - shortcut to your command to your Work menu. Follow the steps below to learn how: Click on Tools | Customize. Click on the Commands tab. Under Categories, on the left, select All Commands. Select ToolsCustomize | ... RemoveRemoveMenuShortcut from the right side. Drag the selection to your Work menu. Even if you have already put documents on your Work menu, you will not see them listed. Release the mouse when you have the command where you would like it. If you would like to shorten the command, you can right-click it and rename it. If you type an ampersand ( ... (view more)

The work menu has now been incorporated into the Most Recently Used Files list in MS Word 2007. That list allows you to "pin" documents so they do not become scrolled off the list. In theory, the list can now hold fifty documents, but because the ... list does not scroll, the total number you can have on your list is really dependent upon your screen resolution. When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today! (view more)

MS Excel formats date and time values in a way that is meaningful to us, such as 12/01/08; December 1, 2008, 2:15 p.m., 12/01/08, 14:15, etc. With just a quick glance, we know precisely what the date and time string represents, but internally MS ... Excel uses a serial value, not the formatted value that we see. When working with time and date values, it can be very beneficial to know the serial value and Excel makes it easy for us to have a quick look and see. Follow the steps below to learn how: Enter some date and time values: Click CTRL + ; to enter the current date. Click CTRL + Shift + ; to ... (view more)