| Thread | Last Post | Replies |
|
| Lookup? or What?? | 27 Apr 2008 12:44 GMT | 2 |
I have this table in a spreadsheet. a b c d e f g 1 1 2 3 4 5 6 2 A Z U P K F A
|
| How to write a function formula | 27 Apr 2008 10:59 GMT | 1 |
I need a formula that satisfies the following: From an excel spreadsheet I have a colum that contains the ages of different residences. The ages are 1) New (less than a year) 2) The rest has a range from 1 to 100 years. I want to call this new column "Age". The column "K"
|
| CONDITIONAL FORMATTING OR AN 'IF' STATEMENT? | 27 Apr 2008 08:19 GMT | 3 |
I have a spreadsheet with the following columns: Col A – Date completed Col B – Status Col c – Scheduled start Date
|
| Setting print area | 27 Apr 2008 08:10 GMT | 1 |
I have a worksheet that would normally print on several pages. I have set the print area by selecting what I want to print, and selected "fit to 1 page wide by 1 page tall" on the print options. When it prints on 1 page, the font sizes are extremely small. I have
|
| summary page of many worksheets | 27 Apr 2008 03:26 GMT | 1 |
How can I summarize the input values of one cell in many worksheets, other than referencing them individually. I.e. A summary page listing the values in all worksheet cell h8, for example.
|
| Templates for Authors - Do Any Exist? | 27 Apr 2008 03:01 GMT | 1 |
I am looking for template to run accounts etc as a sole operator/business as an author, but cannot locate any. I would very much appreciate a point in the right dircetion for any packages, templates that may exist.
|
| column headers changed from letters to numbers, how do I change ba | 27 Apr 2008 02:58 GMT | 1 |
I'm using Excel 2007 and the column reference headers have change to numbers. Both rows and columns are numbers. I don't know how this happen. How do I change it back so that column references are letters?
|
| different footers on each page | 27 Apr 2008 02:48 GMT | 6 |
How can I enter different footers on each page in a workbook without all pages having the same footer?
|
| How do I improve the 2007 Excel performance. | 26 Apr 2008 18:43 GMT | 1 |
After loading Office Professional 2007 on my computer, opening an excel spreadsheet takes a very long time. Is there anything I can do to improve the performance.
|
| Using a conditional function to sum the difference between two col | 26 Apr 2008 18:35 GMT | 3 |
Using a conditional function to sum the difference between two columns. Column C has Issue dates Column D has Due dates (ALWAYS later than Issue Dates C) Task is to sum the difference between columns D and C but skip those rows
|
| Formatting Cells For Invoice Number Format | 26 Apr 2008 17:50 GMT | 4 |
Hello I Am Trying To Complete A Spreadsheet For Work And One Collum Is For Invoice Numbers In The Following Format 000/111-2222. Letters sometimes apear as well as numbers so is there a way of formatting the collum so that the / and - do not need to be typed. Hope this makes ...
|
| Face ID | 26 Apr 2008 17:31 GMT | 2 |
Is there a way to create a new FACE ID picture than the ones that are already listed?
|
| Year Function | 26 Apr 2008 17:02 GMT | 3 |
I have dates in one column. The year of the date shows in another column. How do I get the year to show as two digit (08 etc). Thanks
|
| Automatic alerts in excel | 26 Apr 2008 16:57 GMT | 3 |
I am trying to create a data base for training. I would like to place a date for which some one attended a course in cell C3 and then when a refresher is required the date of for which the qualfication is due to expire will appear in cell F3. however I would like the cell to ...
|
| What makes a Large File in Excel? | 26 Apr 2008 16:55 GMT | 3 |
I was working on a file for a friend and when I was finished, the file size was about 1k. When she did the process, it was over 35k and even had one file over 128k. I was impressed by the size and I watched her do the process from scrach, it was 35k again. We are working on ...
|