Posts Tagged ‘worksheet’

Newer Entries »

Print your Recurring MS Outlook Appointments

Friday, December 11th, 2009

Wouldn’t it be nice to have a handy list of appointments that you have scheduled for recurring events? One might think that would be available in MS Outlook but alas, it is not. There is, however,  a way to get around MS Outlook’s limitation and print out a list of those recurring appointments.

You can export your calendar to MS Excel!   Once you have done that, you can then sort and filter the list and then print it.

Follow the steps below to learn how:

To export your calendar to Excel:

  1. In Outlook, click on File | Import And Export.
  2. Select Export To A File from the Choose An Action To Perform list.
  3. Click Next.
  4. Select Microsoft Excel 97 – 2003 from the Create A File Of Type list.
  5. Click Next.
  6. Click Calendar in the Select Folder To Export From list.
  7. Click Next.
  8. Click Browse and navigate to the folder where you would like to save the workbook.
  9. Name your workbook.
  10. Click OK.
  11. Click Finish.

Specify the appropriate date range for your export.

Once MS Outlook completes the export, ope the workbook and click the Calendar tab.

If there is no tab visible named Calendar, you may have to click around some to find your Calendar items.

You can use a filter to exclude all but the recurring items and then sort the filtered results to arrange them as necessary.

You can now print your filtered list!

Tags: , , , , , , , , ,
Posted in Excel 2003, Microsoft Office, Microsoft Office Excel, Microsoft Office Outlook, Office Productivity, Outlook 2003, Outlook 2007 | 1 Comment »

Create a Drop-Down List From a Range of Cells in MS Excel

Tuesday, February 10th, 2009

There are many reasons why one would want to create a drop-down list in MS Excel, but mostly I think, because it makes your data entry much easier and you can limit the entries to certain items that you can determine.

You can create a drop-down list of entries that is compiled from cells elsewhere on your worksheet and when you create the drop-down list, it will display a drop-down arrow next to that cell. When you want to select an item from that list, you can simply use the drop-down arrow and click the item that you want.

To create a drop-down list in MS Excel 2003, follow the steps below:

  • Use a single column or row without blank cells to create your valid entries for your drop-down list.

 

  • Make sure that you have sorted the list in the order in which you would like it to appear in your list.

You can use another worksheet or workbook if you like. To use a different worksheet in the same workbook:

  • Type the list on that worksheet.
  • Define a name, such as classes.
  • Select the range of cells.
  • Click the Name box at the left end of the Formula Bar.

  • Type the name for the cells.
  • Click Enter.

Pretty simple to do and it looks so very professional and is very helpful to boot!

Tags: , , , , , , , , , , , , ,
Posted in Excel 2003, Microsoft Office, Office Productivity | No Comments »

Excel 2007 – Custom Headers in Spreadsheets

Wednesday, August 6th, 2008

Adding headers to your worksheets in version 2007 of MS Excel is quite a bit different than what you are accustomed to in earlier versions.

You will no longer use a separate page to set up your headers as you did previously. MS Excel 2007 now allows you to work with your header directly in your Worksheet Layout view.

Follow along with this exercise to learn how to create your custom headers in MS Excel 2007.

Let’s create a header for your worksheet with the title “2008 Sales Forecast” in the center, with your company’s logo in the left-hand margin and the date in the right-hand margin.

Follow the steps below to learn how:

  1. Click the View tab and then click Page Layout in the Workbook Views group.
  2. Click the words Click to Add Header above row 1.
  3. Key in the text “Sales Forecast.”
  4. It is important to note that if there is an ampersand in your title (&), you must key in two of them so that Excel will recognize it as a character.
  5. Click in the space to the left of the title.
  6. In Header & Footer Design Ribbon, click Picture in the Header & Footer Elements group.
  7. Navigate to the file containing your company’s logo
  8. Highlight the logo and click Insert.
  9. Click any cell in the worksheet.
  10. Click on the logo.
  11. In Header & Footer Tools Design Ribbon, select Format Picture in the Header & Footer Elements group.
  12. Click the Down arrow of the Height box until it reaches 50%.
  13. Click OK.
  14. Click to the right of the worksheet title near the right margin.
  15. Click Current Date in the Header & Footer Elements group of the Header & Footer Tools Design tab.
  16. Click in any cell to exit.

This is a lot easier than in earlier versions!

Tags: , , , , , , , ,
Posted in Excel 2007 | No Comments »

Newer Entries »