| Thread | Last Post | Replies |
|
| Printing sizes all wrong | 17 Apr 2007 19:16 GMT | 1 |
If I create a rectangle 5cm high by 13.5cm wide and print it it comes out 14.2cm wide and 4.7cm high. Two 13.5cm wide rectangles should fit on a landscape page but they overflow onto a second page.
|
| How to organise expenses divided between two payers | 17 Apr 2007 19:11 GMT | 2 |
I have a boat which is jointly owned between myself and one other . Under this arrangement all expenses involved in running and maintaining the boat are to shared equally between us. As I am retired and my co-owner is employed , most of these expenses
|
| Page Break - Unable to adjust | 17 Apr 2007 18:45 GMT | 3 |
Not sure what's going on.. but I cannot adjust my page breaks in any of my workbooks.. I don't get the double-headed arrow to press and drag.. any suggestions??
|
| Diable task pane on startup | 17 Apr 2007 18:19 GMT | 2 |
I have searched the posts to this group and have found postings on how to keep the task pane open on start up. I would like to STOP the task pane from opening when I create a new workbook from an open workbook. I find it very annoying to have to go through the extra steps when I
|
| Automating the copying of a line | 17 Apr 2007 17:48 GMT | 2 |
Can anyone suggest the best approach to add a new line of to a specific point (specifically in the position of the next blank cell in a particular column). The line would be a copy of one of the previous ones without any of the inputted data but keeping all the formula on the line.
|
| Formulas Not Recalculating Automatically | 17 Apr 2007 17:31 GMT | 1 |
Some of the formulas in my Excel 2003 spreadsheet are not recalculating automatically. The spreadsheet contains a number of simple multiplication formulas, such as =E82*D82 . Using this example, when I change the value in cell E82, the value of the formula does not update ...
|
| conditional formulas in Excel | 17 Apr 2007 17:21 GMT | 5 |
I am looking to do some formulas in excel. I have some check boxes. With named cells. and these check boxes have true/false values. but I would like to use conditional formulas with these.
|
| navigating with the tab key | 17 Apr 2007 17:18 GMT | 1 |
How do I get the cursor to move to the next cell after pressing the tab key. In my case after entering data in one cell and pressing the tab key to move to the adjacent cell, the tab key takes me to the next page, causing me to navigate backwards. Is there a remedy to this, how ...
|
| Comma format | 17 Apr 2007 17:05 GMT | 1 |
How do I set the default comma format to show negative number as within paranthesis. say -1234.567 as (1,234.57) Can anyone help please ?
|
| difference in months | 17 Apr 2007 16:43 GMT | 2 |
I have 2 dates and i want to calculate the difference in months not years Any help will be appreciated Thanks Londoner
|
| End-User License Agreement keeps coming up | 17 Apr 2007 16:41 GMT | 3 |
Am using Vista and recently installed Office Basic Edition 2003 that I had purchased for an earlier machine that has bit the dust. Why is it that whenever I open Excel the End-User License Agreement comes up and I have to accept to continue. I should only have to do this once but ...
|
| Need help with conditions Liz | 17 Apr 2007 16:36 GMT | 2 |
I've a question........... If A1 = 2/17/2007 B1 = 2/22/2007 I've cell C1 with a formula to calculate the difference between those dates
|
| Excel 2007 encryption | 17 Apr 2007 15:29 GMT | 1 |
This is a repost. I am not a hacker (take that as you wish), I am a trainer who is trying to provide accurate information to business end users so that they can make reasonable decisions. Your insights will be appreciated.
|
| sorting date of birth list | 17 Apr 2007 13:22 GMT | 3 |
how can i sort the list in format dd/mm/yyyy to keep the ones born before 1946 only?
|
| Display current sheet name being processed in macro | 17 Apr 2007 13:18 GMT | 5 |
I have the following macro that will protect each sheet in a workbook. For n = 1 To Sheets.Count 'Sheets(n).Protect Password:="&PasswordEntered" Title = "Protecting sheet"
|