| Thread | Last Post | Replies |
|
| convert xls file to word doc | 31 Aug 2008 03:44 GMT | 1 |
Hi there, Because my excel file has a lot of formulas in it (makes file a huge size), I want to convert it to a word doc. less the formulas. When I tried to just copy and paste the sizing is all off . Tried moving margins etc but its not
|
| Generic Pivot Chart Column | 31 Aug 2008 02:25 GMT | 1 |
I have a list of data that has two columns each having a specific Month Date. What I would like to do is put these two columns into a Pivot table and get a count of how many times each month appears for each column. So I think a need a generic column for each month of the year ...
|
| a cell is set to email contents-cannot undo-changes my formatting | 31 Aug 2008 00:43 GMT | 3 |
Somehow a particular cell in Excel - cell B27 - any worksheet, even new ones - has somehow been set with a message that wants me to email the contents of the cell and it changes my formatting. the color goes to blue and the contents are underlined. One lick takes me to my email. ...
|
| Date formatiing - using code to show months | 31 Aug 2008 00:42 GMT | 3 |
I have a row of dates which start from =TODAY() and increment by 1 along the row giving a sequential row of dates. I would like to automatically format the row below the dates to show merged blocks of months for the day date row above - January, February etc
|
| Resizing File>Open box | 30 Aug 2008 23:04 GMT | 12 |
Hi, This is a really trivial question but hopefully someone can help me. Many moons ago I maximised my File>Open window so I could see all the "detailed" information. Now I do not need this window so large, but I cannot find a way to restore it back to it's original size. The ...
|
| Creating a chart template | 30 Aug 2008 21:15 GMT | 1 |
I have created a chart that I would like to use to analysis financial information. The chart is derived from an 8-column-wide table of data (with the number of rows depending on the amount of data that I wish to analyse). I would now like to be able to use this same chart for ...
|
| PLEASE HELP | 30 Aug 2008 20:47 GMT | 3 |
MY FORMULA IS =SUMIF(Y3:Y104,">=27-AUG",R3:R104)-(L106+L107) HOW CAN I USE UPDATABLE CRITERIA, INSTEAD THE ABOVE , FOR EXAMPLE C:I WHICH IS =NOW()
|
| Breaking a long column to print on one sheet | 30 Aug 2008 20:15 GMT | 1 |
I have two columns of data that I must update and sort alphabetically, then break the columns to print on one sheet instead of three pages. Is there a way to set this up to print without cutting and pasting to fit on one page?
|
| Appending data from two sheets according to like fields | 30 Aug 2008 18:28 GMT | 1 |
I have two workbooks. One is demand and one is supply, both vary in length from day to day. I want to append the supply data to the end of the demand data in a summary sheet for matching columns. Nonmatching columns have their own independent column.
|
| Automatically gray out rows when a particular field is populated | 30 Aug 2008 17:24 GMT | 4 |
I am trying to set up a spreadsheet wherein the far right column is the date of completion of a particular task. I would like to have that row be automatically grayed out when the field is populated with the date of completion (far right column).
|
| Automatically gray out a row when a particular field is populated | 30 Aug 2008 16:28 GMT | 1 |
I am trying to set up a spreadsheet in Excel 2003 wherein the far right column is the date of completion of a particular task. I would like to automatically gray out the row when the far right cell in the row is populated with the date of completion of the task.
|
| hyperlink from dropdown list | 30 Aug 2008 14:15 GMT | 6 |
hiya i have 2 dropdown lists the 2nd list determend by the first (dropdown from a dropdown) what i would like to do is hyperlink from this second list which is based on the 1st.
|
| repeating a page of formula | 30 Aug 2008 14:06 GMT | 3 |
This is the page layout for an Itininary that is 300 daily pages long each cell is repeated in an 49 row increase when the C address changes to an D Address and then 49 more and then an E Address etc etc. Hope I have explained myself well enough . Is there on formula or 2 that ...
|
| expanding columns in excel 2007 | 30 Aug 2008 13:14 GMT | 1 |
I'm opening a comma delimited file (csv) and wanted to find out if Excel 2007 had a feature that would automatically expand the columns instead of me having to click the vertical line between fields to expand the column?
|
| splitting forenames/surnames into separate columns | 30 Aug 2008 12:27 GMT | 2 |
I'm trying to split up some text strings into columns. The text is of the form "father_forename1 father_forename2 [etc.] & mother_forename1 mother_forename2 [etc.] surname" where there may be a variable number of forenames - (it's the names of the parents in a baptism record). I ...
|