Archive for the ‘Excel 2010’ Category

Change Cell Patterns in MS Excel

Thursday, February 2nd, 2012

MS Excel will allow you to change the background patterns used in your cells.  There could be any number of reasons why you may want to do this, but luckily it is very easy to accomplish.

Follow the steps below to learn how:

version 2003:

  1. Select the cells whose patterns you would like to change.
  2. Select Cells from the Format menu to discplay the dialog box.
  3. Be certain the Patterns tab has been selected.

  1. Use the Pattern drop-down list to select one of the patterns available to you.
  2. Click on OK.

Versions 2007, 2010:

  1. Select the cells whose patterns you would like to change.
  2. Click on the Home tab of your Ribbon.
  3. In the Cells group, click the Format tool and then click Format Cells to display the dialog box.

  1. Be certain the Fill tab has been selected.
  2. Use the Pattern Color drop-down list to select the color of your choice for your background.
  3. Use the Pattern Style drop-down list to select the pattern of your choice.
  4. Click on OK.

Cool stuff:  Because any pattern you select appears in the background of your cell, that means that it appears behind any information in that cell. So, if you combine patterns and pattern colors along with other formatting options, you can be very creative with special effects!

Move Drawing Objects in MS Excel

Friday, January 27th, 2012

There are, as you know, many different methods to create objects using the drawing tools in MS Excel. But suppose you would like to change the position of your objects – how do you do that?

Follow the steps below to learn how:

  1. Using your mouse, point to the shape you woudl like to move and click on it to select it. Excel will place small squares or circles around the shape. These are called handles.
  2. Using your mouse, point to the object and your mouse pointer should turn into a four-headed arrow.
  3. Click and hold down your mouse button.
  4. Drag the object to the position of your choice.
  5. Relase your mouse button.

Update Links in your Excel Worksheets

Monday, January 23rd, 2012

Many, many times foks have linked information in their MS Excel worksheets and that information is updated every time you open your workbook.

There may though, come a time when you have a need to update your links manually – do you know how??

Follow the steps below:

  1. Display the Edit Links dialog box. In versions 2007-2010, click the Office button and Prepare | Edit Links to Files.
  2. In earlier versions, click Edit | Links.
  3. Select the link you would like to update.
  4. Click Update Now or Update Values (depending on your version).
  5. Click OK.