Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ranebow
  • Content: Threads
  • Order by date
  1. ranebow

    Multiple calendars in one

    I'm using Outlook 2002. There are three computers on a home network. Two of the 3 computers will be used by individuals...the 3rd is in the kitchen. Would like to have a "combined" calendar in the kitchen with appointments regarding the family...birthdays, anniversaries, etc. If I put...
  2. ranebow

    Change size of cell in WORD table

    I'm really new to tables in WORD. I usually try to do things in Excel, but want to create a new form. I have 7 rows of a 5 across table. Under that I have 1 row with 6 across. Unfortunatley one of the lines on the left side of my cell on the single row lines up with one of the lines of the...
  3. ranebow

    Column widths on Excel chart

    I've created a chart that will have 4 columns (one column per manager) per each week of March, April & May. I've added the first manager and everything looks great. When I add the second manager my columns get very skinny! Any way to make them wider? There is a lot of space between the...
  4. ranebow

    Adding Time fields in Excel

    Trying to add cells in an Excel spreadsheet that are formated by HH:MM:SS. When totaling I get strange results. When going over 24 hours I'd like it to display Days:HH:MM:SS. Is this possible?
  5. ranebow

    Excel Window

    There is a person in the office that has 3 worksheets open in minimize mode. When she restores one of them you can no longer see the title bar for that specific worksheet. It's like it's been drug off the "gray" area of the Excel screen. How do we get it back?
  6. ranebow

    Excel Styles

    If I create a new style in Excel (Format, Style) can I save it somehow to use in other workbooks also? I'm using Excel 2000. Thanks!
  7. ranebow

    Outlook VCard

    I've added a new card in my contacts in Outlook with all my information. Then I go into Tools/Options/Mail Format/Signature Picker and select that card in the VCard option. When I look at Properties I see all the information I entered. But when I send a message the only thing that shows up on...
  8. ranebow

    VLOOKUP question

    I have employee initials in spreadsheet "A". In spreadsheet "B" I have initials and names. I'm going to do a VLOOKUP from "A" to "B" to put the names in spreadsheet "A". Now comes the problem. Spreadsheet "B" contains ALL employees....including new hires. When doing the VLOOKUP is there...
  9. ranebow

    Outlook question on Attendee Status

    I'm a delegate on another person's calendar. She has asked me to send a list of invitees to a meeting and whether they accepted & declined to another person. Is there a way to do a "copy/paste" from the "Show Attendee Status" display? Or is there another way so I don't have to key all...
  10. ranebow

    Outlook attendees accepting/declining

    I'm a delegate on another person's calendar. She has asked me to send a list of invitees to a meeting and whether they accepted & declined to another person. Is there a way to do a "copy/paste" from the "Show Attendee Status" display? Or is there another way so I don't have to key all...
  11. ranebow

    Update bitmap in Excel automatically?

    I have a bitmap file that I want to change in Paint. What I want is to link it to an excel file and have it update when I change it in Paint. To further explain: I have a US map in paint that I want to color with the states when certain things happen in that state. As I color them, I want it...
  12. ranebow

    Open TXT file in Excel via hyperlink

    I posted this earlier and had something misleading in the subject line. In Excel, I've done a hyperlink to a TXT file that is downloaded via another software package. Is there any way to force the link to open the TXT file via Excel instead of Notepad?
  13. ranebow

    Word hyperlink in Excel

    In Excel, I've done a hyperlink to a TXT file that is downloaded via another software package. Is there any way to force the link to open the TXT file via Excel instead of Notepad?
  14. ranebow

    Inserting chart into another workbook

    I have two different workbooks (Detail and Consolidated). In the detail one I have a chart that is created from many sheets within this workbook. I'd like to pull a chart (that is on a sheet by itself) and put a smaller version of it on the Consolidated sheet. When the detail one is updated...
  15. ranebow

    Return zeros instead of #N/A on VLOOKUP

    Is there a way to return either blanks or zeros on a VLOOKUP when you don't get a hit? I'm doing a lookup from a "chart of accounts total sheet" to each month's expenses. If I don't get a hit I don't want to see the #N/A on my sheet. The #N/A also gives me problems when trying to total that...
  16. ranebow

    Custom list in Excel

    I'm trying to create a custom list with military time (0700 0730 0800 0830 etc). When I create the list it looks ok but will not populate. If I put the letter "A" before 0700 it works fine. Is there a way to create a numeric list?
  17. ranebow

    Constant footer in Excel

    In WORD you can change the "NORMAL" document to put the file name in the footer of EVERY Word document you create. Is there a way to customize the footer on ALL Excel sheets the same way? I want my worksheet name, date & time to appear on each workbook I create or update.
  18. ranebow

    Insert line in Excel

    I have a 2 page workbook. First sheet should ALWAYS pick up cells from line 3 of second worksheet. Problem is....each week I insert a line BEFORE line 3 and enter current week info. When I do this the formula on the first sheet updates to line 4! HELP!
  19. ranebow

    Extend rows in Excel

    I have a dump from a main frame into a spreadsheet. If I select all the records I want it creates more rows that what Excel can handle. Is there any way to "Extend" the number of rows in a spreadsheet?
  20. ranebow

    Outlook message time

    If a message is being sent from a different time zone...when I receive the message will it have MY current time or the SENDER'S time. Currently I've received a message from a time zone that is 2 hours behind. I sent original message at 10:00 a.m. Response came back at 12:10 & I replied at...

Part and Inventory Search

Back
Top