| Thread | Last Post | Replies |
|
| How do I change the color for highlighting cells | 24 Oct 2007 14:53 GMT | 1 |
I am relatively new to Excel and have just started using Excel 2007. The color used when highlighting a cell is a very faint grey and hard to see. I was wondering if there was a way to change it
|
| Conditional validation | 24 Oct 2007 14:45 GMT | 14 |
I need to validate data being entered in row T according to the entry in the same row in column S, i.e. if S1=1 then T1 must be 1, 2 or 3 if S1=2 then T1 must be 2, 3, 4 or 5
|
| Open/Save screen settings | 24 Oct 2007 14:39 GMT | 1 |
Hi, When I try to SAVE or OPEN the file, the screen is always default in "LIST VIEW". How can I change the default in DETAIL VIEW? Thanks,
|
| Is there a way to separate into own cells? | 24 Oct 2007 14:24 GMT | 4 |
I have xxx-xxx-xxxx(followed by a /) FirstName LastName xx-xxxx all in the same cell (ie: 865-356-8434/Curtis Gogel 01-AUDT) but would like to have : 8653568434(no dashes)|Gogel, Curtis|01-AUDT. Is it possible to "tweak" the excel cell info from ONE cell into three,
|
| Excel not showing colours untill printed or print preview | 24 Oct 2007 14:11 GMT | 1 |
I have a user that for some reason cant see any colours or Shading in cells untill she prints the file or clicks print preview? im not very explarance with excel so any help would be welcome, Regards
|
| How can I graph an equation instead of points? | 24 Oct 2007 13:59 GMT | 3 |
Instead of plotting points on a graph, I would like to graph an equation in the form of y = mx + b. How should I put this into a chart?
|
| Remote Desktop with Excel | 24 Oct 2007 13:22 GMT | 2 |
When I connect to a remote desktop, it causes problems with my Excel 2007 (on my "main" computer, not the connected to one). All of the icons in the ribbon get "grayed out" and I need to mouse over them to refresh. I can also drag a window over them to get them to redraw.
|
| Excel from the Command Line | 24 Oct 2007 12:00 GMT | 1 |
Can Excel be controlled programmatically? I need to have Excel read a data file, create a chart and save it as a picture (gif, pdf). Can I do this from the command line or using a batch file?
|
| More validadtion problems! | 24 Oct 2007 10:43 GMT | 50 |
I have a worksheet that will be used for simple data entry of name, address, etc etc. - 1 column per field. One of the columns is for National Insurance number, and one is for postcode (UK), and I am struggling to get the validation for either of these.
|
| Character sizes | 24 Oct 2007 09:51 GMT | 1 |
Will someone please enlighten me on how to reduce/change the size of typed characters on worksheets and the worksheets themselves as well, in OS Win.XPPro Office 2003. Currently a CD with worksheet files presents me with two different types of
|
| Insert Picture | 24 Oct 2007 07:08 GMT | 6 |
I am using the following Macro to insert a picture into a protected sheet Sub testme() Dim myPictName As Variant Dim myPict As Picture
|
| Offset question | 24 Oct 2007 07:01 GMT | 1 |
I need a formula in cell C4 which will place the value of cell D4 in cell B4. Cell B4 can contain no formula
|
| Export | 24 Oct 2007 06:59 GMT | 1 |
I have a 2k line excel doc witht he following A1 Item 339393 no longer in stock - Tuesday, September 11, 2007 I need to separate the data into 2 cells
|
| "Conditional" formatting by Cell selected | 24 Oct 2007 06:13 GMT | 1 |
I'll try to explain my problem. In column A i can have 5 different numbers: 1,2,3,4 and 5. So the value of any cell in column A (except for rows 1,2,3,4,5 - they are heading rows ) can be 1 to 5. Row 1,2,3,4 and 5 are heading rows.
|
| formula to update todays date in excell automatically daily | 23 Oct 2007 22:49 GMT | 1 |
formula to update todays date in excell automatically daily
|