| Thread | Last Post | Replies |
|
| Shapes and Arrows Moving | 20 Aug 2008 01:04 GMT | 1 |
After I add a shape or arrow in the work sheet, it is in a different position when printed. Why?
|
| Changing Length of Cell Contents | 20 Aug 2008 00:41 GMT | 6 |
The maximum Limit for the length of a Cell is 32767 characters is there any way to change that limit for a specific Cell.
|
| how do I find 2nd highest MAX in a row | 20 Aug 2008 00:16 GMT | 4 |
I need the forumla to find the 2nd highest Max in a row. example: High OOC CRUISE Talent High Photo Max 1 Max2 SUPREME 0 0 0 0 0 0
|
| Automatically changing my numerical entry- when I don't want it to | 19 Aug 2008 23:42 GMT | 2 |
When I enter a number excel is multiplying it by 100. I've tried messing with Format, Cells, Number but that doesn't help. I've also tried tools, options, edit and unchecking the fixed decimal places... Help please!
|
| Deleting Duplicate records | 19 Aug 2008 23:38 GMT | 1 |
To whomever, I have followed the suggested format for finding/deleting duplicates by highlghting all columns, some columns, then choosing filter/advanced, and unique records/in place, etc., but nothing changes.
|
| How do I add a scroll bar from tool box into an Excel document | 19 Aug 2008 23:35 GMT | 3 |
I am creating a document with a timeline and want to be able to use a scroll bar along the dates. I have seen these used in Gantt charts. I have found the option by right clicking on the tool bars and then selecting control toolbox. A tool bar comes up with the option to ...
|
| Merging WorkBooks Not Working | 19 Aug 2008 23:30 GMT | 1 |
I want to merge two workbooks (more later) so that duplicate entries will be eliminated. (Copy/paste does not fit my need.) When I try to do this, it says that both workbooks must be shared and the tracking history must be the same. I made both workbooks "shared" and checked ...
|
| Excel 03' -- Printing to exclude autoshapes? | 19 Aug 2008 23:25 GMT | 3 |
I have a 1 page sheet that was created as a FORM, I've added 2 "autoshapes" on the page that are assigned to macro used to send the sheet as an email upon click. How can I print this page but NOT have the shapes print out?
|
| how to open a workbook per active window | 19 Aug 2008 23:13 GMT | 1 |
I have an issue with all the workbooks that I open, they all put in one active window, please show me the easy way to solve this problem. thanks!
|
| #DIV/0! | 19 Aug 2008 22:46 GMT | 3 |
I know #DIV/0! is a common error but I can't seem to make my formula work with the ISERROR statement. My formula is returning a 0/0 value =IF(I26,(G26+H26))/(I26-F26)
|
| .XLB files and network | 19 Aug 2008 22:33 GMT | 2 |
I have an excel document with a custom toolbar (visual Basic, WordArt, ...). I put this document in a common network folder to share it with my friends. I want to activate my custom toolbar when my friends open my document. But only this document. If i copy my .XLB file on the ...
|
| Subtotals | 19 Aug 2008 22:29 GMT | 4 |
How can I automatically (not manually) highlight or shade all subtotal rows?
|
| Formulas | 19 Aug 2008 22:23 GMT | 2 |
Hi there...I just attempted to update my budget on an excel file and none of the formulas are working. It's almost as if I locked up the file from calculating. I have Excel 2003. Does anyone know where I went wrong? This has never happened before. Thanks!
|
| Sumif Formula - Won't Recognize Dates | 19 Aug 2008 22:21 GMT | 3 |
I am trying to use a sumif and countif formula in conjuction with dates but Excel (2003) will only recognize my formulas when I hard-code the date as opposed to linking to a cell that contains the date. For some reason, when I put the formula pointing to a cell (containing a ...
|
| Conditional Formatting various colums at once | 19 Aug 2008 22:12 GMT | 3 |
Hi, I would like to add a Conditional Formatting to various colums at once. Example if A1>B1 make cells C1, D1 and F1 red, Please advise
|