| Thread | Last Post | Replies |
|
| Multiple lines in a cell | 21 Apr 2008 22:45 GMT | 2 |
In Excel 2007, how do you put multiple lines in a cell? I have some text that I want to paste in a cell that span muliple lines or type them in. But when I do, it goes to the next cell. If pasting, it puts them in the cells below. One cell per line.
|
| Help with lookup formula | 21 Apr 2008 22:38 GMT | 1 |
If one of the countries in a named list "OECS" is found in H10, lookup the relavant worksheet and return a rate based on the currecy in AG10. If H10 contains a different country (e.g. Canada) lookup the relavant worksheet and return a rate also based on the currency and so on. ...
|
| Checkboxes appearing backwards | 21 Apr 2008 22:31 GMT | 1 |
We have several older Excel files that when opened in Excel 2003 and 2007 the checkboxes are displayed backwards. When printed they are backwards as well. When the checkbox is clicked on, it flips around, but when the control loses focus it reverts to being backwards. What ...
|
| Date Formatting in Excel Urgent | 21 Apr 2008 22:23 GMT | 1 |
I have a dates in excel that show as dd/mm/yyyy. However, when you click on the cell it shows format mm/dd/yyyy. Can someone advise how this can be achieved for the rest of the spreadsheet without retyping? what is the formula used? I tried rightclicking on the cell but the format ...
|
| Change the color of Filter Arrows in Excel to BRIGHT RED | 21 Apr 2008 22:22 GMT | 6 |
I suggest that Miscrosoft changes the color of the Filter Drop Down List Arrows to Bright Red, when the column is filtered. Trying to distiguish the non-filtered columns (black arrows) from the filtered columns (currently dark blue) is almost impossible.
|
| automatical cell size adjusting | 21 Apr 2008 22:13 GMT | 4 |
Hi I've been using excel for a while now, and something that would be really nice is to have cells resize themselves when word wrap is active, so that you can just type away and be sure that the cell will stretch himself to display
|
| Finding Data in a worksheet | 21 Apr 2008 22:12 GMT | 1 |
After deleting a blank cell that kept me from highlighting a specific column, I am no longer able to do a find in an excel worksheet. After talking to a few people about this issue, I realize that other people have had similar experiences with excel and have not found a solution. ...
|
| Excel 2007 Problem with SUMIF | 21 Apr 2008 22:11 GMT | 2 |
In a worksheet I have one tab that contains detail information. I filter the detail information twice and create a new worksheet a copy-paste the 2 different sorts. Then I return to the original worksheet, to a different tab, and insert a SUMIF that references the newly created ...
|
| Excel problem, Enter key | 21 Apr 2008 22:04 GMT | 4 |
when I type something into a cell generally when I press enter key it will move down to the next cell, somehow this has stopped working I'm sure I press something accidently could somone help ?
|
| Name worksheet tab after cell data | 21 Apr 2008 22:01 GMT | 1 |
I am working on a new spreadsheet for work. I want to be able to have the worksheet tabs rename themelves after data is entered in a particular cell eg ("G9"). Also I would like this to work on all worksheets created in the workbook so if I add more sheets to the book I will
|
| Option Buttons in a Form | 21 Apr 2008 21:58 GMT | 7 |
I am a beginner in Excel, so don't get mad if my questions are rather basic. I've searched through previous posts, but I haven't been able to find answers to these questions. I'm trying to create a form in Excel with 42 yes/no questions. I used pairs
|
| Comments Without Indicators; Displayed when Cells are Clicked | 21 Apr 2008 21:47 GMT | 2 |
I am interested in creating comments that do not have indicators, and that appear when the cell is clicked. These comments can be moved around, but cannot actually be edited by someone using the worksheet. I've noticed this in a spreadsheet that I have that needs to be edited. I
|
| How do I keep fill color constant when cut & copying text? | 21 Apr 2008 21:31 GMT | 4 |
This is for a basic Excell spreadsheet with columns and rows. I've used white & yellow as the row fill colors for clarity when viewing the spreadsheet. When the information in a yellow cell is cut (or copied) and then pasted
|
| incremented numbering | 21 Apr 2008 21:24 GMT | 4 |
i need a little more detail on how to do this... 1. what is a general module in your workbook? 2. Copy/paste this Function into a single cell or? 3. Select second sheet then SHIFT + Click on last sheet to group these
|
| Excel 2007 strange behavior on two computer | 21 Apr 2008 21:21 GMT | 1 |
We have moved our users to Office 2007 and we have two users who have this issue. When opening an excel file, the file does not open. Excel will seem to open but instead of seeing the spreadsheet you see a pale blue screen and the ribbon is grayed out. If you click on the ...
|