| Thread | Last Post | Replies |
|
| Disappearing Excel document | 22 May 2007 16:02 GMT | 2 |
I created quotations using an Excel template - no problem. However, some my saved quotations have now 'disappeared'off screen! All I can get is the grey Excel blank background. There are no scroll bars available so I cannot scroll to find it. The document is still 'there' because ...
|
| Excel 2007 Large Format Printing Issue | 22 May 2007 16:01 GMT | 1 |
I have a worksheet that contains a single graph that I am trying to print on to a paper size of 24"x36". When I go to print preview, the graph does not show up and wont print if I try and to just print it; but if I make the paper size 18"x24" the graph shows up in print preview. ...
|
| Cell color change does not display. | 22 May 2007 15:58 GMT | 2 |
I am using Excel 2003, and when I change the color of a cell, the color on the screen never changes. I can open the print preview and see the color change here. Any Ideas?
|
| Inserting Page Breaks | 22 May 2007 15:57 GMT | 3 |
I'd like to know if there's an easy way to insert page breaks into my spreadsheet. I have a list in column B. Some of the items in the colums a listed more than once. I've sorted the list in ascending order and now I'd like to insert a page break between each individual item. ...
|
| Formula and go to next line | 22 May 2007 15:41 GMT | 8 |
Hello this is my formula =Title&" "&Name&CHAR(10)&Address1&IF(Address2=0,"",CHAR(10)&Address2) I want the title and name on one line and on the next line address 1 then address 2 on the next line, if any. this formula shows everything is on ONE
|
| How to filter the date? | 22 May 2007 15:33 GMT | 2 |
Does anyone have any suggestions on how to filter the date in following example? There is a list of date in cell A1:A10, which is always later than / equal to today,
|
| When refreshing pivot tables my pivot table chart type changes | 22 May 2007 14:57 GMT | 1 |
I created a whole heap of Pivot table charts. I also selected a default chart type to use whereby Excel automatically used my default chart type every time I created a new chart for pivot tables. Unfortunately when I press the refresh button for my pivot table reports Excel ...
|
| date not recognized | 22 May 2007 14:57 GMT | 8 |
I copy a word form (cntrl A then cntrl C), which contains a date in the document, and paste (CNTL V) into an excel worksheet. In an another worksheet within that same file I have set a formula which will tell me what day of the week that date is. But it comes back with a ...
|
| reference question | 22 May 2007 14:23 GMT | 3 |
i want to be able to flip between two worksheets based on a common field. I.e.one sheet will have the acronym meaning and another will have a description. i want to be able to switch between the two. i have discovered that a hyperlink will do this, but if i then insert a row it ...
|
| Cell formated as text changes when copied | 22 May 2007 13:15 GMT | 5 |
Spreadsheet with 10 rows (all formated as text) and 1 column. I enter the string: Usages in 1900 - 1905 in the top row. I select the top row and catch the sqaure at the lower right corner and "copy" the text to the next 9 rows. The text in the second line is now "Usages in 1900 - ...
|
| How do I set up batch jobs to run spreadsheets over night? | 22 May 2007 13:15 GMT | 1 |
I am looking at setting up batch jobs to run some spreadsheets out of hours, is it possible? if so how?
|
| Two Bugs in Excel 2003 With Hyperlinks to Files | 22 May 2007 13:13 GMT | 2 |
Bug 1: I add a hyperlink to a share folder located at z:\someuser\projects\project1 into a workbook cell. Excel accepts this, and pressing the hyperlink Explorer opens and shows the target folder. So far so good. Now save the spreadsheet, exit Excel, and re-enter. Now
|
| Exporting a worksheet with blank/empty cells | 22 May 2007 13:12 GMT | 2 |
I have a worksheet with 10,000 rows and 10 columns. In one of those columns about 25% of the cells are empty. When I export the worksheet in a tab delimited file those blank cells are simply omitted, so in those cases the output record only has nine fields.
|
| replacing comma with another symbol | 22 May 2007 12:59 GMT | 2 |
Hi I have a column of figures like 21,95 15,50 26,45
|
| Is Data Needed After Pivot Table is Created? | 22 May 2007 12:57 GMT | 1 |
I've noticed that the original data for a pivot table can be deleted and the pivot table is maintained, including drill-down capability. Is the original data needed for anything (other than a refresh, if you want to change the data) once the pivot table has been created?
|