| Thread | Last Post | Replies |
|
| repeat text in same exact cells in multi worksheets | 10 Apr 2007 20:54 GMT | 2 |
I have a workbook and have 20 worksheets in the book. example of what I would like to do. on the worksheet in the same exact numbered cells I want to put the text in once and then put a forumla to make it copy the info to 2-19 pages
|
| Excel 2003 versus Excel 2007 calculation speed | 10 Apr 2007 19:07 GMT | 7 |
I'm running an interesting test on a PC of Excel 2003 and Excel 2007. I ran a Monte Carlo simulation in Excel 2003. The workbook has 50 input cells (cells where random values per distributions are input) and 200 calculation (formula) cells. So, it is basically a small workbook ...
|
| No Undo after save - am i the only one bothered by this? | 10 Apr 2007 17:22 GMT | 1 |
I have searched forums and web sites all over the internet for the answer to why excel does not allow you to undo after a save. I have built a habit over the years of hitting ctrl-s very often in whatever i am working in. for any application other than excel this isn't a
|
| % Doesn't Display Correctly | 10 Apr 2007 16:44 GMT | 1 |
This may be an easy fix, but I'm having trouble. I have a cell where I want to input a percentage. I have the cell formatted for percentage, so when I enter "15," the cell displays it as 15%. Then if I enter "20," the cell displays 200% instead of 20%. Also, if I
|
| Excel 2007 extremely slow compared to 2003. Why? | 10 Apr 2007 16:25 GMT | 1 |
To my surprize, the new version of Excel is VERY slow compared to 2003, particularly when it handles worksheets with A LOT of data and charts. I saw that Excel 2003 uses ~80 MB memory to open a certain file, while 2007 uses ~300 MB(!) to open the exactly same file. However, the ...
|
| Printing columns | 10 Apr 2007 15:53 GMT | 2 |
All, Please forgive this very simple task request. I am trying to eliminate the white space on the right side of a printed page and ultimately the total number of pages. All of that means that I would like to display and print multiple groups of columns within the same page.
|
| Excel cannot complete this task...... | 10 Apr 2007 15:46 GMT | 7 |
Hi, I am using Excel 2002 and would appreciate help on a couple of problems / issues / concerns / ...... To begin with, I created a spreadsheet with links to about 50 items in another spreadsheet (using Special Paste feature) and when I try and Save and
|
| reading outlook contact list | 10 Apr 2007 14:37 GMT | 1 |
Is there a way in Excel 2003 to read and edit the contents of an outlook .pst contact list? Thanks, Pete
|
| Delete Row 1 from every sheet in a workbook | 10 Apr 2007 11:29 GMT | 2 |
Hi I would like to loop through every sheet in a wrokbook and delete row 1 from it, I currently have the following code: Dim sht As Worksheet For Each sht In Sheets
|
| =COUNTA() with multiple look-up | 10 Apr 2007 08:12 GMT | 5 |
I would like to count the number of items that have a value "AAA" in column A and an amount >0 in column B. As I am not quite sure how to incorporate two look-ups in a counta formula I was wondering if anyone can give me the formula?
|
| import rss feed into excel ( rss --> excel ) | 10 Apr 2007 05:49 GMT | 2 |
I've been searching, but so far don't see much on how to import an rss feed, such as craigslist, into an excel spreadsheet. I'm looking for a quick and dirty, and free, solution. I don't mind if it's labor intensive. I'm not looking for a script, but but just a (free) tool.
|
| getting rid of #DIV/0! | 10 Apr 2007 02:39 GMT | 2 |
I'm receiving the subject error in my cells when referencing a cell without a number. I plan to put a number in those cells as they come to me but I don't want to see that error. I would like the cell to be either blank or zero.
|
| Is there a way to rotate a column of data into a row of data? | 10 Apr 2007 02:38 GMT | 7 |
Is there a way to rotate a column of data into a row of data, in Excell 2003? Let's say B8 - B1000, there are so many of them... I want to rotate it into a row form...
|
| calculate time on time record | 09 Apr 2007 21:16 GMT | 1 |
I'm creating a time record using Excel 2003 and need to know how to calculate to get the correct total worked for the day: IN A.M. OUT LUNCH IN LUNCH OUT P.M. TOTAL 9:00 1:00 2:00 5:00 7:00
|
| My blue title bar has been deleted, can I get it back? | 09 Apr 2007 19:49 GMT | 1 |
I have lost the title bar on top of my worksheets, is there a way to get it back, I cannot find anything in help...
|