| Thread | Last Post | Replies |
|
| Hiding standard tools. | 27 Sep 2007 07:47 GMT | 2 |
If I take out the formatting and standard tools also tabs at the bottom of the page and then save it. If I now email this to someone will their copy show the same when it is opened or will it depend on how they have `set` their excel, in other words will it reveal what I have ...
|
| not able to see the blinking cursor while editing cell | 27 Sep 2007 05:26 GMT | 2 |
For some reason when I edit a cell in excel I am not able to see the blinking cursor. The formula bar shows where the cursor is and rather than looking at the cell I am editing i have to look at the formula bar. I find it extremly distracting.
|
| Securing a worksheet vs. HTTP | 27 Sep 2007 04:13 GMT | 3 |
Suppose a worksheet is secured (user may not edit cells, select cells, format cells, etc.). If the file is served via http, it seems as if these security settings are not regarded. Is this correct, or do I make some error.
|
| Cut and Paste without taking borders | 27 Sep 2007 03:16 GMT | 6 |
This has driven me nuts for years, and it seems so basic: I have a spreadsheet with some borders around the outside of an area, and all I want to do is say move a value from the upper right corner of the area to somewhere in the middle. If I cut and paste, it not only takes the ...
|
| OFFSET Function - what is it doing? | 27 Sep 2007 00:33 GMT | 2 |
I'm trying to implement some functionality using the OFFSET function, but do not understand what the two optional variables are doing. For example, I am happy that for the range below, OFFSET(A1,1,2) will return the value "c2"
|
| hide formulas | 27 Sep 2007 00:27 GMT | 5 |
Excel 2002 SP3 Win XP HE Hi, I have a spreadsheet that has quite a few formulas that I want to
|
| Using arrows (keys) to navigate in Excel | 26 Sep 2007 22:57 GMT | 3 |
Not sure if I can do this but only way I can navigate between the boxes is if i press it with the mouse or if I use TAB and thats navigate it only to the next box (forward) if i press arrows Up,Down,Left or Right I am moving whole spreadsheet....so is there any
|
| Formula | 26 Sep 2007 22:38 GMT | 3 |
I am created a table containing weekly total of overtime for a number of employees (input table tab). I now want to create a chart (weekly overtime tab) for the weekly overtime. I want to be able to enter a date for a specific week and only create that week's chart.
|
| MAJOR PIVOT TABLE PROBLEMS | 26 Sep 2007 22:24 GMT | 1 |
Trying to make an inventory ledger that displays all products, with all their transaction no's and dates subcategorised under the products using excel pivot tables. The problem was that If i kept row fields as product, under that
|
| Assigning a macro to a button | 26 Sep 2007 21:42 GMT | 5 |
I under the impression that when I created a button on a worksheet, that a dialog box would appear asking me to choose a macro to assign to the button. This does not happen even though I have macros available in the open workbook as well as in personal.xls. How do I
|
| Need Help with a Sum of a Product of a Currency and Product | 26 Sep 2007 20:49 GMT | 1 |
Does anyone have a way to simplify this formula and make it so it automatically includes newly added rows or cells? =SUM((SUM($K$9:L9)*$H$9),(SUM($K$11:L11)*$H$11),(SUM($K$13:L13)*$H$13), (SUM($K$15:L15)*$H$15),(SUM($K$17:L17)*$H$17),(SUM($K$19:L19)*$H$19),
|
| how can I make 2007 excel look like 2003 excel? | 26 Sep 2007 18:26 GMT | 1 |
I am not convinced that the 2007 interface is better. Please tell me how to make the 2007 excel look like , act like 2003. PLEASE...........
|
| Need help modifying a macro | 26 Sep 2007 18:19 GMT | 1 |
Hi. I have a macro that works off of a master sheet and creates a new worksheet for every block of 25 records. FirstSheetname = ActiveSheet.Name Lastrow = Range(Cells(1, 1), Cells(Rows.Count, 1)).End(xlDown).Row
|
| BUG in 2007 | 26 Sep 2007 18:16 GMT | 3 |
put in 850 in a1 in b1 through b10 put in 77, 77.1, 77.2,77.3 etc in c1 put =$a$1*b1 and fill down through c10 line graph c1:c10 - it is linear
|
| Formula Question | 26 Sep 2007 17:24 GMT | 1 |
Hi all... I am trying to figure out how to build a formula in Excel. What I want to do is to be able to calculate a loan value. I know the interest rate, the # of payments and the month principle and interest payment I want to make. I
|