General

Exel only prints to a file
I have the same issue that just appeared (had been working fine) -- running Windows 7 and MS Office XP Professional... Definitely interested in hearing any solutions anyone has... "Spotta" wrote: Running Windows 7, with MS Office 2003 SP3. Excel will only print to file, and not to my printer (Canon M... 8 Mar 2010 02:07

Convert font to lower case
This actually is very easy way to do it. Thanks Mike, it really made my work easier "Mike" wrote: I dump the data into Word. Then select all text and click on Format - Change Case. Then I dump it back to excel. "Teri" wrote: I have a large spreadsheet which I am using as merge data for a... 8 Mar 2010 01:03

Can a Excell File be converted to Access
I have a Excell program that I would like to load on Sharepoint. I would like users to be able to log on via the Internet... enter infomation into the Excell worksheets...then be able to save this information for themselves...log in the next day and continue working the spreadsheet. I want other users to be... 7 Mar 2010 23:58

sort data
is there any way to sort my data in excel from IP address Username 10.10.10.1 A 10.10.10.1 B 10.10.10.1 C 10.10.9.2 D 10.10.9.3 E 10.10.9.3 F ... 8 Mar 2010 03:11

Need Help!!
I am trying to, I guess, Link worksheets? (I am an Access user, I do not know Excel very well) So please excuse me!! Anyway, I have a master sheet with a list of employees names. Then each employee has their own sheet, to track training. I want to be able to click on their name on the master sheet and it take ... 7 Mar 2010 19:36

Two Condition Vlookup
I have two worksheets that contain similar information. What I need is a formula that will lookup the Value of column A in worksheet one, but also there's a second condition that I want it to meet which is in column B. So basically if these two conditions are met then I want to see the result from using workshe... 7 Mar 2010 19:36

How do I control the light/dark variations Excel 2007 color theme?
Hello! I'm converting Excel chart templates from 2003 to 2007. The problem: the company has 12 distinct colors it uses for its charts. Now, 6 of the 12 colors are lighter versions of the others, BUT none of the automatically generated lighter colors match. Is there ANY WAY to control how the lighter colo... 7 Mar 2010 17:23

Conditional Formating based on Date
I would like to change the cell color based on date. For example if date is today or less color should be red, if date is upto 10 days from today the color should be yellow. I used following: Condition 1: =A1<=today() RED Condition 2: =A1-today()<10 YELLOW it worked ok if I have date in the cell. If the ... 7 Mar 2010 23:58

How do I merge two cells without deleting data from the cell?
wow! many thanks... it worked perfectly fine and solved my problem. Best Regards, Wahaj "Batmans_Wife" wrote: I'm highlighting two cells in the same row, hitting format cells, alignment, merge cells and I'm getting the error message, "The selection contains multiple data values. Merging into one cell... 3 Apr 2010 17:03

Creating a form in Excel
I have set up a form for my fellow workers to use and to enter their inspection data into certain cells of the form which later I will be linking to go into a summary report workbook. I'd like to make sure (possibly protect cells?) that they can only enter their data into certain cells, not be able to edit/cha... 6 Mar 2010 22:50