| Thread | Last Post | Replies |
|
| modifing the find function | 18 Mar 2008 20:00 GMT | 1 |
I would like to know how to set up a button that will open an input box and search for a particular value in only one column. This would be similar to find but with a specific range( one column) and would ask find next at the end.
|
| Protected Sheets | 18 Mar 2008 19:37 GMT | 2 |
I have protected certian cells in my sheet. The sheet that I have protected is a shared attendance sheet where people can insert comments, and numbers. Since I have protected my sheet we can insert numbers, but we can't insert any comments. How can I leave certian cells ...
|
| Excel 07 always showing formulas? | 18 Mar 2008 19:25 GMT | 6 |
I have a user using excel 07 who, all of a sudden, has spreadsheets that open with the formula values showing. She turns them off by CTRL + `, but is annoyed at having to. Any thoughts on how to turn this default back?
|
| document on excel | 18 Mar 2008 19:19 GMT | 2 |
I am trying to create a document that others can fill in without altering the original socument can someone help me please
 Signature Shawn Stalker
|
| autosum | 18 Mar 2008 19:15 GMT | 1 |
I have a very large file and want to exclude cells in a contiguous autosum. There are too many (more than 30) agruements for SUM. Is there a way to exclude cells in a contiguous autosum?
|
| how insert the return key in formulas for concatenate of text? | 18 Mar 2008 19:13 GMT | 2 |
How do I write a formula to concatenate text columns that will allow me to see different lines of combined text in excel 2003 formulas. I'm trying to use one column for a barcode software to make badges for a conferrence
|
| MS Excel | 18 Mar 2008 19:07 GMT | 2 |
Is there a way to list your spreadsheet in to alphabetical order
|
| How do I automatically add a prefix to cell value in Excel? | 18 Mar 2008 19:05 GMT | 2 |
If I have a list in which the first characters repeat, (i.e. CDAxxxx), how do I make it so that I only have to type the xxxx and the CDA is automatically prepended?
|
| Using cell data in headers | 18 Mar 2008 18:55 GMT | 1 |
Can u use cell data in headers in excel? If so how?
|
| row height | 18 Mar 2008 18:48 GMT | 1 |
I am formatting row with auto fit and text wrapping, the row is automatically increasing in height extra text. But when we change text in same row its not decrease height. I want when text is big its increase and when we change small text it decrease automatically. please help me ...
|
| formulas and functions | 18 Mar 2008 18:48 GMT | 1 |
Why do I get a value error when I try to copy an example from excel help that includes an nper function and a formula? What do I need to do to not get the value erro?
|
| Referencing Tabs | 18 Mar 2008 18:37 GMT | 3 |
Here is the formula that I have inputed; however I am still getting a #NUM! error. =INDEX(+Equity!$E:$E,$E127+($E$13*(COLUMN()-5))) I'm in the 'IRR' tab and am working in row 5, and I need to reference cells
|
| Save Changes ??? | 18 Mar 2008 18:23 GMT | 2 |
I have a workbook that I have been using for 2 years now without any issues. But now after I save changes with the Save button on the formatting toolbar and try to exit, I receive a message "Do you want to save changes you made to ???.xls". I thought that I had already saved ...
|
| how could i get a white backgroupnd? | 18 Mar 2008 18:00 GMT | 2 |
I am just trying to get a clear white background without showing the lines. Ant help??
|
| updating cell formula | 18 Mar 2008 17:40 GMT | 4 |
I have a need to define cell A1 like so : =CONCATENATE("System Name: ",D2," ",D3) but instead of a fixed D2 & D3, I would like to replace it with E2 & E3 if I click on column E, F2 & F3 if I click on column F, etc... i.e. cell value
|