| Thread | Last Post | Replies |
|
| How to print gridlines biger | 31 Jan 2006 23:39 GMT | 1 |
How to print gridlines biger
|
| keyboard shortcut between worksheets? | 31 Jan 2006 23:39 GMT | 9 |
Can anyone tell me of a keyboard shortcut that would alternate me through the worksheets in an Excel workbook similar to the way ALT+TAB moves me through running applications? Thank you.
|
| Excel conversion | 31 Jan 2006 23:34 GMT | 1 |
I have managed to copy and send my contact list for another email account into Outlook. Now I am having trouble getting them into my address book. When I try to send new email, it will not complete the name and I searched for my .pab and it appears I have none. I am using XP with ...
|
| Hide "Save" and "Save as..." menu | 31 Jan 2006 23:28 GMT | 1 |
I would like to know if is possible to hide the "Save" and "Save as..." option menus in the "File" menu and how do that. Thank in advance. Rui
|
| Calculating Row/Column Headers in PivotTable | 31 Jan 2006 22:32 GMT | 4 |
I have a table of data, the first two columns of which are Date and Transaction Amount. What I'm trying to do is put together a table that will summarize total transactions by month/year. My goal is to have 1 through 12 (months) as the column headers, and have the years be the
|
| changing text case | 31 Jan 2006 22:31 GMT | 8 |
Is there a way to change the text case in Excel? Ex. from all caps to Sentence case, etc.
|
| Find/Search in Formulas - won't find phrase after copying/renaming sheet/book | 31 Jan 2006 22:22 GMT | 1 |
I have two workbooks - one with data downloaded from an external source into a sheet for each of the 12 months - another with sheets that refer to that data and perform calulations, etc. for each month. I need to create two new sheets to use in 2006 instead of 2005, so I want to
|
| how do i set up book keeping accounts? | 31 Jan 2006 21:50 GMT | 1 |
can u tell me how i can do accounts on computer with microsoft excel.
|
| Confusion...(conditional formatting) | 31 Jan 2006 21:37 GMT | 4 |
Thanks to all that replied to my post!! I was looking to make F2 field a required field, i.e <red> If E2 = "yes" then make F2 a required field. I am going to email this spreadsheet to users, if the user select "yes
|
| Excel Column Sum | 31 Jan 2006 21:31 GMT | 2 |
I get a different answer to a column of numbers (only 6) when I manually add them together as compared to doing a formula (=C6+C7+C8). Why?
|
| Get "current weight" when the column is not known? | 31 Jan 2006 20:00 GMT | 5 |
I have a spreadsheet with dates across the top and a daily weight entered under the appropriate date. I'd like to have a cell near the top of my spreadsheet that shows the beginning weight minus the most recent weight. How can I tell it to grab
|
| Linking with other programme | 31 Jan 2006 19:16 GMT | 1 |
Is it possible to link excle xp to link with accounting software tally54. it it is then how it is. Please give me total procedure. Rao Ratan Singh
|
| Linking to non-adjacent cells | 31 Jan 2006 18:55 GMT | 5 |
I have 2 workbooks. In Column A of workbook Source, I have the number 1 through 20 starting in A1. In the second workbook, Summary, I wan to link to every third row in Source (for simplicity, these will b located starting in B1 going down). So in the end, Summary will loo
|
| Creating ODBC link within SELECT statement | 31 Jan 2006 18:54 GMT | 1 |
Is this possible. To explain myself, here is my situation. I created an Excel Spreadsheet that uses an ODBC link to a SQL database. In order for anyone to use this file on their PC, that same ODBC link must be setup. Is their some code I can use within a Select Statement that ...
|
| #REF Error... | 31 Jan 2006 18:39 GMT | 4 |
Is there a formula that will return a value of "0" if referencing a cell that has "#Ref" in it? In other words something like ISNA for #Ref. I have several tables that are linked to a summary page. The tables pull from an SQL back
|