Threads Replies Last Post 38 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   "Show shortcut keys in ScreenTips" check box The "Show shortcut keys in ScreenTips" check box is missing from the Tools/Customize/Options/Other dialogue box in Excel. It's available from the other Office Pro 2003 apps. Is there something wrong with my installation ? Thanks. -Maggie... 2 04.08.2006 16:05:02 Password protection How do I password protect a document on a server so that you have to enter the password to change the document, but the document can be viewed without a password? -- Tanya508... 3 03.08.2006 20:26:02 Changing the default window colour I have changed my default window colour thru the desktop properties from white to gray, the problem is when I send an excel file to someone it shows up on their computer as grey as well and not their default white colour if I have a chart in the file. To get the file to show up white in their excel they have to delete the chart. Anyone know a fix to this problem -- Olive... 1 03.08.2006 19:00:02 Accumulate values I have column A that contains many account numbers and i have column B which is a dollar value that corresponds to each account. A B 10023 $25.00 10024 $20.00 10025 $25.00 10023 $25.00 10026 $25.00 Is it possible to assign cells in column C to sum the amounts which equal the accounts. For example account 10023 sums up to $50.00 and i would like each time the account of 100... 4 03.08.2006 17:25:48 Can you print xcel in "newspaper colmn" fashion? I have a narrow (4 columns) but long (2200 rows) spreadsheet. I am trying to print in multiple columns on one page (i.e. "newspaper colmns") before it moves to page 2, etc. I am trying to avoid having 40 pages with one narrow set of information on the page. I want it to print 2 or 3 "columns" on one page before it moves to the next page. ... 6 03.08.2006 16:35:01 error while installing Excel 2007 Beta2 I've been using Word and Outlook 2007 Beta2 since MS released it and today went to install Excel but keep getting an error. The install box keeps coming up with this dialogue box: "Setup cannot find Pro.WW\ProWW.xml. Browse to a valid installation source, and then click OK" Not knowing where that file might be I did a Search and search didn't find it so I manually looked for it and fo... 1 03.08.2006 13:54:38 Set cell to only accept 1 character I need to format several cells to only accept one character and then automatically move to the next cell. Can this be done in Excel 2003? We have to fill out a spreadsheet and several cells are one character wide but we have to hit the tab key after each character to get it to move to the next cell. This is hard when entering 20 or more of these one character cells in a row.... 2 02.08.2006 15:56:01 Re-organise columns so they appear in alphabetical order? Does anyone know how to re-organise columns in Excel so that they appear in alphabetical order from left to right... 3 02.08.2006 04:47:01 cannot get excel sheet to print landscape even when set landscape I am trying to get an excel sheet to print landscape. It is set to landscape but will not print that way ... 2 01.08.2006 23:18:39 Shifting the contents of cells Hi I am a maths teacher and I want to be able to show how the decimal system works. For example, take the number 123, I want each digit to be in its own cell and then when I multiply be ten I want the contents of each cell to shift left and add a zero., 123o, again with each digit in its own cell. I know I will haved to write some code but I need some help to get going so that I can... 2 01.08.2006 11:10:02 How many lines Does any one know what happens when you get to 65000 lines , do any other spreadsheet application do more ? ... 2 01.08.2006 03:34:44 Punctuation English/Danish How do I change the settings for language specific punctuation in a document? In Danish large numbers are written like this 3.234 whereas in English you write 3,234, the same goes for 3,5 % (DK) vs. 3.5% (ENG) Can anyone help?... 2 31.07.2006 19:48:44 how do I get the excel addin for analysis services? as per 2003 I am using the excel add-in for sql analysis services in 2003 I can see the cub formulas are part of the standard in 2007 but where is the wizard equivalent?... 1 31.07.2006 09:04:02 Adding Rows offsets to working rows across two worksheets Excel 2003 SP2 I've just setup a spreadsheet that has 2 worksheets, Sheet1 and Sheet2. I've copied/pasted some data into Sheet1. Now in Sheet2 I parse the data that's in Sheet1. Sheet1 contains multiple GROUPS of data that are 23 rows. Hence, rows A1-A23 are Group 1 and rows A24-A46 are Group 2, rows A47-A69 are Group 3, etc. I'm parsing the data in Sheet2 to be Group 1 as row 1; Gro... 4 30.07.2006 18:54:01 Accounting Format Parentheses I have Excel 2002 (XP) and want to display negative numbers in parentheses in ACCOUNTING FORMAT instead of with a minus sign. I know this is possible as a standard feature (I have done it before on a previous machine) and I think there was a KB patch for this flaw. Anyone know of where I might find the fix? ... 2 30.07.2006 14:00:07 how do I put the day into my header with the date have it change d I would like to have the day change like the date every day ex. monday 7/27/2006, tuesday 7/28/2006... 4 30.07.2006 11:59:27 Why would a shared file change row height ... 1 28.07.2006 15:17:02 can we move the sheet tabs in Excel to the top of window? I've been working on all spreadsheets in Lotus 1-2-3 with all sheet tabs at the top. Now, we are changing from Lotus to Excel worksheet and would like to see all sheet tabs at the top, instead of at the bottom. Is it possible to do so, and how? We are using Excel 2000. Thanks... 3 28.07.2006 02:01:12 My Excel stop working can any one help? All of a sudden Excell stop working now it wants me to install the instlation CD and I have had Office 2000 so long I can't find it. Can any one help?... 2 28.07.2006 00:16:24 Borders on cells included in formula while editing Until recently, whenever I edited a formula the cells involved in the equation were shown with colored borders (as well as in the cell and above). This function no longer appears to work. Did I accidently turn something off? I am running Excel 2003. It is an extremely helpful tool when reviewing large spreadsheets. Can anyone help? ... 2 27.07.2006 22:06:14 how to spell numbers in words ... 2 26.07.2006 13:18:38 Mixed Cell Formatiing I would like to have a mixed cell format in a single cell, i.e., a label followed by the results of a formula calculated in the cell. An example would be: "Avg.: " (the result from a formula calculation). How can I do this? Thanks.... 6 26.07.2006 03:41:05 Have Excel display an error rather than rounding # to fit column Excel can be misleading when it helpfully rounds your numbers to fit the existing column width. In most instances I would prefer that, for example, the "##########" indicative of insufficient column width be displayed, rather than an erroneous (rounded) number. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To... 2 25.07.2006 17:35:39 Data Validation skips rows I am using data validation to prevent duplicates in a column and the validation i am using is =COUNTIF(A:A,A1)<2 .This works on some sheets but on others, it skips every other two rows. What would cause this? ... 2 25.07.2006 08:15:02 Remove a Personal xls I created a macro which unfortunately applied to all workbooks.Each time i open a existing workbook, a personal xls open with it.I uninstalled office and reinstalled but the same results appear.What can be done?... 6 25.07.2006 02:30:57 38 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>