| Thread | Last Post | Replies |
|
| Gray Screen when opening Desktop | 22 May 2008 17:49 GMT | 4 |
Excel 2002 SP3, Windows XP The user has a couple dozen Excel files residing on his desktop. If he double clicks on any of them from the desktop, they open with a gray screen. The Window menu is deactivated except for Hide. I hide then unhide but still
|
| How to Format a Nested Function (Bold) | 22 May 2008 17:45 GMT | 2 |
Is there a way to bold a nested function? I.E. I have the fuction like below: ="Emerging Markets"& " "&TEXT(BL962,"###.##") Which ends up being: Emerging
|
| Sequential dates across worksheets | 22 May 2008 17:34 GMT | 4 |
Hi chaps I want to create a workbook with, say, 52 worksheets, one for each week. I would like the days of the week, in date format across the top of each work sheet, but I want the first sheet to be 1/1/08,2/1/08 etc, with the second
|
| =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE.... max. limit 8 :( | 22 May 2008 17:33 GMT | 6 |
I'm having a problem while using excel 2002. I have an estimated amount of 3500 cells containing text. I also have 450 words and for all of them I have abbreviations. What is the easiest way for me to manipulate those 3500
|
| I want to print 1 page. Excel makes it 236 pages? | 22 May 2008 16:57 GMT | 1 |
For some reason, sometimes Excel takes a 1 page document and turns it into a 200+ page document. These are documents previously created. I open it, hit print (or print preview) and Excel prints of previews hundreds of pages for a single page document. Each page is usually 1-4 ...
|
| Macro Button | 22 May 2008 16:54 GMT | 2 |
I apologize for this stupid question, but a long time ago I created a macro button to which I can assign macros for execution. Whenever I need a new one, I copy the old one. But I'm trying to tell someone else how to create it - and I forgot. I tried to use the control toolbox ...
|
| EXCEL 2007 Menus | 22 May 2008 16:39 GMT | 1 |
Is there any way to make EXCEL 2007 show menus comparable to those in EXCEL 2003? Marvin Buzz
|
| formula or filters | 22 May 2008 16:29 GMT | 3 |
Hello there, I have a table looking like this: Branch Date Sales ... Covent 28 5555 .... Leeds 28 354 ......
|
| secondary axis problem | 22 May 2008 16:05 GMT | 3 |
I'm trying to add a secondary axis in Excel 2007 and am following the help steps. Only when I get to the part about clicking on "Secondary Axis" under "Plot Series On" in the "Format Data Series" window, there is no "Plot Series On" area. Why is help telling me to do something ...
|
| how do you change the paragraph spacing in excel 2007 | 22 May 2008 16:03 GMT | 1 |
One I have types into a call and selected word wrap, the spacing between the lines is too large. Does anyone know how it can be reduced?
|
| Button to produce Popup | 22 May 2008 15:59 GMT | 1 |
I’m trying to create a button in Excel 2007 that if clicked, will brin a popup with a description. I’m creating storyboards for my programmers. So the buttons are no live. But to make my storyboards explain exactly what I want it to do
|
| dropdown list | 22 May 2008 15:48 GMT | 3 |
In "A1" i've got dropdown list witch is reading items from range "M1:M3000" I got also some data in range "N1:N3000" And now what I need to do is display in "B1" data from "N"
|
| How to print multiple pages per sheet | 22 May 2008 15:46 GMT | 3 |
Office 2003 on Windows XP. In Word, you have the option to print multiple pages per sheet. In Excel, this option is not on the print dialog. However, if you go to print properties, layout, the option is there.
|
| How to delete names on worksheet? | 22 May 2008 15:38 GMT | 9 |
I have many names inherited from copying worksheet from external files, the file now contains hundreds of names that is giving me some problems. Apart from deleting one at a time using 'Insert'-'Name'-'Define', wonder anybody know how I can delete all the names completely.
|
| excel | 22 May 2008 15:28 GMT | 4 |
Hello i have aspread sheet which contains two columns example amount code 100 bb01 200 cc02
|