| Thread | Last Post | Replies |
|
| How to expand the formula bar when excel opens | 18 Mar 2008 17:34 GMT | 9 |
I would like to expand(maximize) the formula bar everytime excel starts. I would guess that I need to use a macro to do this. My question is how do I tell my personal workbook to automatically run this macro?
|
| link work books | 18 Mar 2008 17:28 GMT | 1 |
Not sure if this is possible. Have a main file called Sales, would like to have a separate file for location 30 that pulls in every row (and it's respective columns) where the location = 30 from the main file called Sales.
|
| Reference every 13th cell from another tab. | 18 Mar 2008 16:57 GMT | 6 |
Is there a formula that will reference a cell in a seperate tab for every 13th cell. For example: In cell R7 it looks at cell =+Equity!E166. Cell S7 needs to be 13 rows below =+Equity!E166...
|
| Printing multiple sheets in Excel | 18 Mar 2008 16:42 GMT | 1 |
When printing mutiple selected sheets in Excel, though the total no of pages in footer changes, but the individual page no. does not increse say 1,2,3,4 etc., it remains for example 1/4, 2/4, 1/4, 1/4 where there are three sheets , first one containing two pages and the other two ...
|
| how do I turn on the tabs? | 18 Mar 2008 16:39 GMT | 4 |
I have two spreadsheets where the tabs have disappeared. I looked in the Excel Opions/Advanced/Display options for this workbook and the tabs diplay is checked... But they are not there... I'm worried that I accidentally deleted the tabs,
|
| Make left-to-right default direction | 18 Mar 2008 16:37 GMT | 1 |
Excel 2007 always creates new workbooks with the columns going from right-to-left. Each time, I must go to Page Layout and unselect the Right-to-Left option. How do I make left-to-right the direction of new worksheets by default?
|
| Help-urgent | 18 Mar 2008 16:13 GMT | 2 |
on a worksheet, when I press right arrow, instead moving to next column, it jumps to the last column in the worksheet. How to rectify it
|
| Cell formula | 18 Mar 2008 16:13 GMT | 3 |
I have a simple formula C9 = C10. When I insert a new row which makes C10 C11 I want the formula to still look at C10. Currently when I add a new row the formula changes. Any help is appreciated
|
| Corrupt Cells? | 18 Mar 2008 16:04 GMT | 5 |
I receive a monthly spreadsheet from another department that I re-sort by product numbers using a custom sort list. Recently one of the product numbers was not being recognized so it would be pushed to the end of the list every time. It also was not recognized when
|
| Merge field coming up 0 | 18 Mar 2008 15:36 GMT | 1 |
I have an Excell file that I am merging into labels. The field that is coming up zero has Zip Codes in it. Some of them are merging ok, but more than half are coming up zero. I have tried changing the data type, and that is not helping. What is wrong?
|
| Excel disapeared! | 18 Mar 2008 15:25 GMT | 2 |
I am new to this forum, I am trying to solve a recent problem with Excel on Microsoft Office Professional Edition 2003. This was pre installed on my computer when I purchased it. Word is working fine.
|
| Combining Text and Dollar Value | 18 Mar 2008 15:20 GMT | 3 |
I’m trying to calculate some data in a cell that contains text and dollar values. I’ve put together an auction spread sheet for my fantasy baseball league and I’m trying to keep track of players and their dollar values in the same cell. So one cell may contain “Jeter, 15” ...
|
| Nesting COUNTIF | 18 Mar 2008 15:17 GMT | 3 |
In Excel 2003, is there a way to combine the functions COUNTIF(A1:A10,"Joe") and COUNTIF(B1:B10,">5")? In other words, the array in Cols A and B has scores from 0 to 10 for multiple trials by Joe, Bill, and Jane; I want a count of all of Joe's scores that are over 5.
|
| Microsoft Excel doubts | 18 Mar 2008 14:58 GMT | 2 |
we have uploaded some excel files in shared folder of file-print server, some users have read only permission, some have write and some have full permission in a group. my question is If one user modifies the file, all the other user of that group should get some alert or
|
| microsoft works spreadsheet | 18 Mar 2008 14:54 GMT | 1 |
i posted an earlier comment for help stating it was an excel spreadsheet i have now looked into it and its a microsoft works spreadsheet i need the width of the spreadsheet to print on one page. how do you do this please.
|