Interesting CTRL commands

1 Comment

CTRL+Q quits your application!

CTRL+W closes your file and will prompt you to save your file if necessary.

CTRL+SHIFT+C copies the format of the text (click in the text)

CTRL+SHIFT+V is the format painter (click in the text)

EXCEL: Convert Function

1 Comment

Excel includes the CONVERT function as part of its Analysis ToolPak add-in. The Analysis ToolPak is included with Excel, and it’s a breeze to install.

To install the Analysis ToolPak add-in:

  1. Choose Tools | Add-ins from the menu bar. (In 2007, click on the Office button and choose Excel Options, then click on Add-Ins, then click Go. In 2010, select the File tab and choose Options, then click on Add-Ins, then click Go.)
  2. In the Add-ins dialog box, select the check box next to Analysis ToolPak in the list box and click OK.

To convert miles to kilometers:

  1. Select cell E5 and type =CONVERT(.
  2. Click the Paste Function button to access the Function Arguments window.
  3. Select cell D5, which holds the value you wish to convert, so the cell reference appears in the Number text box.
  4. Press [Tab] and enter mi in the From_Unit text box.
  5. Press [Tab], enter km in the To_Unit text box, and click OK.
  6. Select cell E5 and drag its fill handle down to cell E9 to apply the formula to the other cells.
  7. Select the range E5:E9 and click the Decrease Decimal button on the Formatting toolbar until the values display in tenths of a kilometer.

The CONVERT function also converts units of measurement for mass, pressure, liquid, and many others. For a complete list, along with the unit abbreviations accepted by the function, type CONVERT in Excel’s Help window.

Once you create a worksheet based on our example, you can use the CONVERT function to instantly perform the conversions from miles to kilometers.

POWERPOINT, WORD & EXCEL: Screen Clipping Saves the Day

2 Comments

Screenshot feature in 2010 allows you to instantly copy an image from any open program.  There are two ways you can use Screenshot. The first option allows you to choose one of the opened program and insert the entire screen image (this is exactly like a Print Screen). The second option allows you to go directly into the opened program that you came from and clip a portion of that screen.

Screenshot is more efficient than Cropping since cropping keeps the entire image in the application even though you hid parts of it.  Also, if you want to save that portion as a .jpeg file, unfotunatley, the ENTIRE image is saved.

To capture a screenshot as a Print Screen:

  1. Make sure you have one or more program(s) opened.
  2. Go to the Insert tab.
  3. Click on the Screenshot icon under the Illustration group.
  4. Click on one of the thumbnails that represent the opened files. (Tip: Hover your mouse pointer over a thumbnail to see the filename and application of the potential screenshot.
  5. The screen image is now inserted into the application that you are working on.

To clip a portion of the opened program.

  1. Click on the opened program and then immediately go back into the application you are working on.
  2. Go to the Insert tab.
  3. Click on the Screenshot icon under the Illustration group.
  4. Click on Screen Clipping.
  5. This action will place you immediately into the application that you came from.
  6. WAIT for the screen to go WHITE.
  7. A crosshatch will appear. Click and drag and select the portion of the screen you ONLY want.
  8. The selected item is now inserted into the application that you are working on.

 

EXCEL: Using HyperLinks Instead of Custom Views to Help Navigate the User

Leave a comment

Prior to Excel 2007, you were able to create custom views and place the Custom View icon on the menu bar and a down arrow appeared to the right of the icon.  This allowed users to select the view that wascreated for their particular viewing.  It was a quick way to navigate to a particular part of the spreadsheet.  Unfortunately, this method is no longer available.  Instead, you create the views as before but to go to one of the views, you now click on the View tab, select Custom Views, choose a View, and then click on Show.

This method has too many steps; therefore, I created hyperlinks to do the same job but on with one click. Here are the steps:

  1. Name the highlighted range that you want the user to go to.
  2. In an empty sheet, I call it the “Menu”sheet.  Design it in order to direct the user to go to a range on found in another sheet or to a specific sheet.
  3. Choose Insert and select the Hyperlink option (or Control+K) to open the Insert Hyperlink dialog box.
  4. Click the Place In This Document icon on the left.
  5. You can Choose three ways:
    1. choose the range name under the Define Names
    2. choose a sheet name
    3. choose a sheet name with a specific cell location
  6. Click OK to create the hyperlink.

WORD: Balancing Row and Column Sizes Quickly

Leave a comment

Designing and formating is fun when working with tables in Word.  In order to balance your table’s appearance, click anywhere in the table and then select the rows or columns you want to adjust.

  • Select the Layout tab from the Table Tool Ribbon
  • Choose Distribute Rows or Distribute Columns in the Cell Size group. These commands uniformly distribute the sizes of the selected rows or columns without affecting the size of the table itself.

 OR

  • Select the Layout tab from the Table Tool Ribbon
  • Choose AutoFit command
  • Choose AutoFit Contents

EXCEL: Turn Off the Annoying Formula ToolTip

1 Comment

In Excel, when you begin to type a formula, the Formula AuotComplete appears and once you enter the opening parenthesis, the arguments for that function appear below the Formula bar or active cell. Some feel that the Formula AutoComplete is more annoying and distracting. To disable the Formula AutoComplete and still view Excel’s helpful tip when needed, do the following two steps.

Turn off the Formula AutoComplete:

  1. Launch Excel and choose File, Options and click on Formulas
  2. Check of Formula AutoComplete.

To insert the function arguments right in the cell or formula bar:

  1. Enter the function in a cell, along with its opening parenthesis—i.e., =SUM(.
  2. Press [Ctrl][Shift]A to enter the arguments right within the active cell (or the Formula bar if you’re working directly in the Formula bar).
  3. Replace each argument with your relevant data or cell reference.

EXCEL: Start Up XL File Automatically

Leave a comment

  • Did you know that you can have an Excel file that you use everyday to open up automatically?

The first method:

  • Copy the Excel file from your library.
  • Go to Start and right-click on Startup.
  • Paste  the excel file in the Startup folder.
  • Everytime you start your system, this file will automatically startup.

If you only need to start up one file ONLY then simply:

  • Go to Excel.
  • Choose File, Options, then Advanced
  • Scroll down until you see the General section.
  • Enter the folder path in the At Startup, Open All Files In text box.
  • Click OK.

Older Entries

Follow

Get every new post delivered to your Inbox.

Join 454 other followers