| Thread | Last Post | Replies |
|
| How do I change my text direction to vertical on EXcell? | 01 Jun 2005 21:47 GMT | 2 |
How do I change my text direction to vertical on EXcell?
|
| Huge sheet for no reason | 01 Jun 2005 21:28 GMT | 2 |
I have a worksheet with about 200 rows and 60 columns in one sheet and about half that in another sheet. The size of the file has become about 25MB!! It had some word emebeded object (logos) which I deleted and the size only
|
| Chart column widths | 01 Jun 2005 21:23 GMT | 1 |
I have a series of data with two values per date and I want to plot this as Clustered columns. If I leave out the dates for the X-axis, the columns are nice & clear, wide enough to see well, but the weeks are just numbered.
|
| Running Average | 01 Jun 2005 21:13 GMT | 5 |
Hello People, I have a worksheet set up with weather data for May 2005 and it is setup like this: A is the date, B is the high temp, C is the low temp; D is the average temp
|
| Import large text file | 01 Jun 2005 21:08 GMT | 6 |
Which options do I have to import a text file to Excel, with more than 200.000 records. Thanks Luis
|
| how to print a receipt | 01 Jun 2005 20:58 GMT | 1 |
I have a list of payments and dates and need to print a receipt for each individual row of cells from A4 to A14 and it needs to include the information that is contained in columns A to E
|
| How to remove built-in headers from Excel workbook | 01 Jun 2005 20:57 GMT | 1 |
Excel has a list of built-in headers and footers that you can choose from. During the use of Excel new headers you create are added to the list for future use. This list can contain delicate information you not always want to share with others (e.g. "20% discount scenario").
|
| Finding similar data or numbers in two columns | 01 Jun 2005 20:41 GMT | 1 |
I am dealing with a lot of data in spreadsheet. I need a macro program so that i can find whether there are similar data or numbers in two colums in the same worksheet. e.g.
|
| smooth scrolling lag | 01 Jun 2005 20:18 GMT | 3 |
I have searched high and low for this. It is actually an issue that affects Excel, Word, even Notepad. Pulling down on the vertical scroll bar - the bar lags behind the mouse at some slow acceleration. When the mouse stops the scroll bar eventually
|
| How to create a formula for a specific pattern | 01 Jun 2005 18:01 GMT | 1 |
I'm trying to do the following but don't know if it is possible. I want to generate a formula such that when I do a Fill-Down it will automatically generate the following: Basically, it will group 1,2 and print it out twice and then it will increment and 3,4 and print it out
|
| Conditional Formatting with 3 options | 01 Jun 2005 17:19 GMT | 3 |
Hi, i would like to know if anyone has successfully created conditional format with 3 options whereby 3 colours are displaye depending on the cell/formula result contents. I would say i have ver strong excel skills and although i could easily program this in VBA th
|
| hyperlink inside a comment? | 01 Jun 2005 17:12 GMT | 1 |
Can I put a link to another file on the network in a comment in eXcel 2003? I am new. Thanks to all. ck
|
| removing spaces | 01 Jun 2005 16:50 GMT | 4 |
I need to remove the space from the text within a cell. The column is about 9500 rows long so do I use the find and replace tool.
|
| Best Book for an Investment Banker to Learn Excel | 01 Jun 2005 15:00 GMT | 1 |
I'm going to be starting my career shortly as an i-banker (~in a month) and, as much as it pains me to say, I definetly don't feel as though my knowledge of Excel is where it should/needs to be. What are some good books for someone who is relatively unfamiliar with
|
| Help with referencing please | 01 Jun 2005 14:44 GMT | 2 |
I'm working on a spreadsheet which has calculations in one sheet whic depend on values on another. I'm pretty sure the references are right as everything was working fine earlier - when I changed the values i one sheet the other sheet updated automatcially. However, now when
|