| Thread | Last Post | Replies |
|
| More Than 65,530 Rows | 30 Jun 2008 23:24 GMT | 3 |
I need to download some Data that contains more than 65,530 Rows. Is there a way to do this??? Increase the number of rows or have the data entered on more that one worksheet???
|
| Removing "Sum of" from pivot tables | 30 Jun 2008 20:31 GMT | 8 |
In 2003, we had a formatting option that would globally remove “Sum Of” from the pivot table values. I like that feature. However, I can’t seem to find the same thing in 2007. I can manually change them, but that’s no fun, especially if I have a bunch of values.
|
| How do I change the automatic colors in Excel | 28 Jun 2008 01:59 GMT | 2 |
One of our workstations automatic colors is set to blue instead of black. I have tried all I can find; if anyone knows of a way to change the default in Excel 2003 please let me know.
|
| How can I set back to default install settings | 28 Jun 2008 01:54 GMT | 2 |
Made some changes in options and want to know if there is a way to revert back to the default settings I had after the initial install.
|
| Import data from a table | 25 Jun 2008 21:53 GMT | 1 |
I tried to retreive the data from the table but I got an error. Please let me know the mistake in my formular. The table is (B2:F5): 0-30 days 31-37 38-44 45-51 days $0-$10,000 225 345 465 585
|
| What function to use? Data Validation or IF | 25 Jun 2008 08:10 GMT | 1 |
I am trying to set up a spreadsheet that allows you to type text in cell A1 and it will automatically enter a dollar amount into cell B1. The text in A1 could be a number of options so a drop down box would be good to select from but then how will this be able to place the ...
|
| set formula to display a data from a 5 columns table | 25 Jun 2008 01:23 GMT | 3 |
I have a table from A1 - E5: 0-10 day 11-20 day 21-30 day 31-40 day $1 - $1,000 15 20 25 30 $1,001-$2,000 35 40 45 50
|
| How do I get my Pointer to go to cell A1 when I press Home? | 24 Jun 2008 15:53 GMT | 1 |
I have a new version of Excel, and when I hit Home, the pointer only goes to Column A, and I want it to go to A1. How do I adjust the settings to make it do this automatically?
|
| Exchequer plugins | 24 Jun 2008 09:24 GMT | 2 |
We use an Accounting Package in our company called "Exchequer" and there are several OLE plugin ins that link to excel to enable us to pull information in. We have just upgraded to Excel 2007 and the plugins work fine but they take forever to load up each time you load excel. ...
|
| Annual gifts received report setup | 24 Jun 2008 02:15 GMT | 1 |
I'm new at both Excel and my position as church treasurer. Need to set up records for weekly gifts from congregation for YE tax purposes. I want these in order, both alphabetical and date. Simple. I sure need help. It's already mid year!
|
| seeking template to track tokens played in arcade game and payout | 23 Jun 2008 11:29 GMT | 3 |
Hi. Please help! Am trying to find a template (Excel?) that would keep track of the number of tokens played and the number of tickets given out for winners. Want to have begin and end counter and percentage of wins. Please help
|
| Can we arrange the sheet tabs in the form of two or more rows ? | 21 Jun 2008 12:22 GMT | 1 |
I have excessive number of sheets resulting in a situation that the tabs do not fit in a single row. Hence, I need to scroll them by clicking the arrow on the left hand side. Can we arrange these tabs in the form of two or more rows that can be seen at the same time without any ...
|
| How to open Excel 2003 in separate Windows for multiple monitors | 19 Jun 2008 17:24 GMT | 3 |
I use two monitors for my laptop. If I launch two instances of Excel, I can drag one instance to the other monitor and work in two spreadsheets maximized at one time. My coworker's Excel, on the other hand, opens one instance of Excel, and all spreadsheets open in the same ...
|
| show menu | 19 Jun 2008 16:01 GMT | 2 |
My Excel (2007) does not show any menu tabs (File, Edit, View, etc.) All I can do is use keyboad commands and whatever is available from a right click menu. Please help.
|
| Cannot bold, italicize or underline text - Excel hangs | 19 Jun 2008 10:43 GMT | 3 |
MS Office 2003, Windows XP Home This just started happening today...until now Excel has worked fine. If I try to bold, underline or italicize text the program hangs. I have uninstalled and reinstalled Office, done the updates. Very
|