| Thread | Last Post | Replies |
|
| Entering left & right aligned, & centred text, into one merged cel | 04 Apr 2008 15:11 GMT | 2 |
I am using Excel 2003. I have a spreadsheet with 8 (eight) columns. I have used the header and footer, and have entered left aligned, centred, and right aligned information in both.
|
| Strange Macro Behaviour | 04 Apr 2008 14:59 GMT | 2 |
I have a workbook that has a load of macros built into it doing all sorts of things, but primarily it is concerned with producing a set of charts based on data imported from another source. There are three main macros: 1) One imports all the source data to a specific place.
|
| identify data source | 04 Apr 2008 13:51 GMT | 6 |
Hello - I have pivot tablers in Excel 2000 drawing their data from queries in Access 2000. When I need to go back to the source data I need to know the name of the query the pivot table is using. The only way I have found of
|
| sodexho direct deposit forms | 04 Apr 2008 13:32 GMT | 1 |
i need forms from sodexho for direct deposit.
|
| On-line tutorials for Excel 2007? | 04 Apr 2008 07:59 GMT | 2 |
Could anyone recommend one?
 Signature Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)
|
| Does Excel Support Drop-Down Menus to Select Information? | 04 Apr 2008 01:53 GMT | 14 |
Hello, a very basic question about Excel 2003. Does Excel have a method of letting you use a drop-down menu to select data that's already been entered in a column? I'd like to streamline my selecting a piece of information, and I
|
| Moving a part of a cell to another cell | 04 Apr 2008 00:22 GMT | 5 |
I am using Excel 2003. I copied some data from a report into excel. The record took up 2 rows. For example, record 1 is taking up cell A1 thru F1 but the date and time for the record is in cell D1 and D2. I would either like to combine the date and time into cell D1 and ...
|
| Ordinals | 03 Apr 2008 21:20 GMT | 17 |
I would like excel to automaticly generate ordinals for me, actualy autofill.. in format: 1.
|
| Date format changes | 03 Apr 2008 17:54 GMT | 5 |
Every so often the date format for all open worksheets are changed from yyyy to yy for no apparent reason. This can be resolved by closing down and re-starting Excel so it's no worse than an irritation. Does anyone know why this should happen please?
|
| Formatted numbers problem - How to get rid of those "1.00043E+11" | 03 Apr 2008 17:29 GMT | 2 |
When I open reports in excel, I often see numbers that read 1.00043E +11, apparently indicating that there is a number format problem. When I change the cell format (to text or number), I am usually able to see the full value in the cell. However, I must first physically
|
| Copying Links to Another File | 03 Apr 2008 17:22 GMT | 2 |
Need help on how to copy linked cells into another file and keep the links. I have several files which have links in them, need to combine all into one file so we can autofilter through all entries. When I copy over the data and paste, the link does not come with it. Tried
|
| Graphing Question | 03 Apr 2008 17:20 GMT | 2 |
I am trying to graph a set of data in 'XY (Scatter)' and am running into a problem I've never seen before. There are only seven values for 'X' - numbers 0 through 6. 'Y' is a set of percentages ranging from '0.00%' to '13.00%'
|
| Why do I see the formula in the cell?? | 03 Apr 2008 16:49 GMT | 2 |
I have an IF formula in a merged cell (XL 2003): =IF(SUM(AO6:AO13))=AB13,"","Error!! Daily Miles Totals Do Not Equal Daily Route Totals!!" The merged cell is formatted as Text, Word Wrap on.
|
| Graphic pasted into spreadsheet from Word doc not visible in Print View layout | 03 Apr 2008 16:34 GMT | 5 |
Gurus, Running Excel 2003. I pasted a graphic from a Word document onto an existing Excel spreadsheet, but when I go into "Print View" or actually print out the page, the graphic is not visible. What am I doing wrong?
|
| Macro for removing columns/rows, freezing panes etc? | 03 Apr 2008 12:36 GMT | 1 |
I have only been using Excel for about 4 months and in the process of learning new things. I want to make use of macros to automate the repetitive tasks I do every day, but just when I think I've mastered each one, I get error messages.
|