| Thread | Last Post | Replies |
|
| QAT (Quick Access Toolbar) - How to make it bigger or expand it to show a more complete document location? | 12 Jul 2007 22:20 GMT | 9 |
I have added the 'document location' to my QAT, but it is so short (narrow) that hardly anything shows up. How do you expand the QAT itself or the 'Document Location' to make it wider and show more of the full path / URL?
|
| Border lines too thick ! | 12 Jul 2007 21:49 GMT | 3 |
Excel 2007 only appears to have a limited number of border lines. The problem is that we are choosing the thinest line in the dialog and it prints horendously thick for what we need. The printer is capable of printing very thin 600 DPI hairlines, but Excel prints the lines much ...
|
| working excel automatically | 12 Jul 2007 20:46 GMT | 2 |
how can u get excel to automatically find a balance by adding or subtracting with two numbers?
|
| Get the Intersection range | 12 Jul 2007 18:32 GMT | 2 |
I have two excel range objects. I want to know whether these are intersected or not. If they are intersected then i need the intersected range or the starting cell and ending cell of intersected range. Can any one help me?
|
| cell won't accept formula | 12 Jul 2007 17:25 GMT | 7 |
I have spreadsheet that contains a few cells that won't accept formulas. Numbers and text can be hard-keyed, but that's it. I've tried to change the format from number to accounting, to general, etc., no luck. Any thoughts?
|
| use a button to open a text box | 12 Jul 2007 16:50 GMT | 1 |
Im using Excel 2007 and what I want to do is this. I want to create a button on my worksheet so when the work sheet is active, i can press thiss button and a text box will open where i enter a number. This number will then be stored somewhere (untill the button is used again and ...
|
| Macro Button Menu | 12 Jul 2007 16:43 GMT | 9 |
I have created a macro button menu to access 21 of my workbooks. I did this so my wife could access the workbooks easily. I would like to lock the view that shows on the screen so it will not scroll if someone uses the scroll button on the mouse.
|
| Moving Data on opening Excel | 12 Jul 2007 16:43 GMT | 3 |
Hi there- trying to create a spreadsheet to track drug prices for prescribing use. I am using 2 columns- one to be blank to enter the currents day's prices, and another one to show the previous day's prices.
|
| Running list - statement entries | 12 Jul 2007 16:28 GMT | 1 |
Ok, I'm a fairly new user and want to have entries from a form that has combo boxes for customer numbers, transaction types, dates - so someone can do data entry when a charge or payment comes through. What I need is for the information from that form to go to individual ...
|
| Validation list in a conditional formula | 12 Jul 2007 16:18 GMT | 2 |
I would like to include a validation list (drop down choices) in a conditional formula in Excel. Something along the lines of =IF(A4="RAIN",$B$11,IF(A4="TEMPERATURE",$D$11,""))
|
| Menu bars missing, help please. | 12 Jul 2007 15:12 GMT | 8 |
Hi, guys, All the menu bar disappeared in my Excel after I launch it. Anyone knows how to make it back? Thanks a lot.
|
| extract string | 12 Jul 2007 13:56 GMT | 3 |
I've been trying to find out how to extract a string from I got an area specification e.g."10.00X20.00" that I wanna split in two cells. One cell should reflect the string before the X w/o the decimal
|
| subtotals | 12 Jul 2007 13:33 GMT | 5 |
I have a list of dollar amounts corresponding with days in the months. I am trying to create a subtotal for each month and not each day of the month. When I do subtotal I get a subtotal for each day of the month. How do I get a total just for the month?
|
| SeriesCollection.(X)Values: locale settings specific? | 12 Jul 2007 12:52 GMT | 4 |
I am using VBA to make some hard coded charts: [..] .SeriesCollection.NewSeries .SeriesCollection(i).Name = "MyName"
|
| date format | 12 Jul 2007 11:46 GMT | 1 |
04/11/05 is 2005/11/04 but Excel thinks it's 2004/11/05. I have many this kind of date need to be correct. Anyone knows how to do it in the simplest way? Thank you very much.
|