| Thread | Last Post | Replies |
|
| How do I delete words I have added to CUSTOM.DIC? | 14 Aug 2006 02:40 GMT | 4 |
Two questions:- (1) I have no problem adding words to the custom dictionary. But I don't know how to find them and delete them afterwards. I tried tools>options etc. No luck.
|
| Roster / Staff Allocation | 14 Aug 2006 02:38 GMT | 4 |
Hey All Just wondering if on ur travel's if you have come across, a template that could be used when rostering and allocating staff within either a retail (Checkout operators) or a aged care facility.
|
| Help with macro or VB to Merge Multiple Columns Of Data Im getting RSI from all the copy and pasting! | 14 Aug 2006 00:19 GMT | 5 |
I have an application that exports data as below ABSLIVE AGRDEVBACK AGRDEVWEB 26/06/06 1294 26/06/06 1436 26/06/06 399 26/06/06 1299 26/06/06 1439 26/06/06 399
|
| #DIV/0! how to stop this in blank cell | 13 Aug 2006 22:44 GMT | 8 |
How do I get #DIV/0! to stop appearing when a cell is blank. This is the formula I am using... =D15/(POWER(E15,2)/10000)
|
| how to move cursor in the formula | 13 Aug 2006 20:43 GMT | 1 |
Hi, all, The formula is much too long in the conditional formatting and only a portion of it is displayed. How to move the cursor without changing the cell references?
|
| allow me to copy and paste in a protected worksheet | 13 Aug 2006 20:11 GMT | 3 |
I have a password-protected worksheet. How could I copy and paste within the same worksheet without unprotected it? Any help will be highly appreciated! Thanks,
|
| Updateing Master File Pricing | 13 Aug 2006 18:21 GMT | 3 |
I'm starting here because I'm sure that everyone here has way more Exce experience than I could ever dream of. Here is my task.. I have a master price file which I use to update my website tha contains about 4000 products (give or take a few) and our vendor issue
|
| Consolidating multiple external pivot tables into one pivot table | 13 Aug 2006 12:51 GMT | 1 |
Here's the situation: I have 30-40 workbooks that are updated on a weekly basis (the data for sure, the filenames might also change for some of them), each includes a sheet with a pivot table (same fields and layout in each, but pulling from their own unique ranges within
|
| Preventing Info From Scrolling ... Possible ?? | 13 Aug 2006 11:44 GMT | 4 |
Hi, I'm just curious to know if it is possible to have a Text Box or other information Not Scroll (Stay Stationary) when scrolling horizontal or vertical? I do know about the Freeze Pane Feature but they are very limited to
|
| Need to value dates | 13 Aug 2006 11:18 GMT | 4 |
I do a lot of work in cleaning up mailing lists other people have generated. When I get any date column going, I usually =Value() it, to find out if any of the dates are bogus. Sometimes they are real dates, and sometimes they are "08/12/2006" and they get converted and formatted ...
|
| Hidden rarely used menu items | 13 Aug 2006 09:58 GMT | 2 |
I am not sure if this is a configurable setting, or if it is whether it is done within Excel or at a Windows level, but I want to set my Excel program so that when I click on the menu bar all items are permanently on display, where currently it hides rarely used items. I know ...
|
| XL2003 and tab colours | 13 Aug 2006 08:57 GMT | 5 |
I have started using XL2003 after some years' experience with earlier versions. On the latest version the background colour of the worksheet tabs is white in the case of selected (or grouped) sheets, but very very very light grey in the case of unselected sheets. This makes it ...
|
| Need a construction estimate template | 13 Aug 2006 08:01 GMT | 1 |
Does anyone have a construction bid template? Or a similar template I could modify? Thanks!
|
| How to diffrentiate Text & number from a single cell???? | 13 Aug 2006 05:57 GMT | 3 |
:( Hi ther guyz............i a have small problem with the execl sheets........... my problem is e.g. i have alot of cells with a number and some text in it........and they both are in one/single cell (e.g. "878 queen st" in
|
| Shortcut list by topic? | 13 Aug 2006 03:23 GMT | 1 |
I'm looking for an Excel 2003 shortcut list that is organized by topic, such as, rows, format, etc. Thanks
|