Threads Replies Last Post 38 Pages: <<  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38   track Health insurance deductible Need good template to track accumulating expenses needed to meet Health (Medical) Insurance Deductibles... 1 12.02.2006 15:43:27 How to avoid opening an empty workbook every time I open a file? How to avoid opening an empty workbook every time I open an existing EXCEL file?... 3 12.02.2006 11:55:26 easy way to create attandence sheet by excel I would like to create an attandence record sheet & time-in time-out sheet of 8 employees. I would like to know the simple way (by MS Acess or any other source) in excel to create it. Can anyone advise pls?... 2 12.02.2006 11:22:27 Stop excel from dropping the 0 in the beginning of a number? I do a lot of spreadsheet with number that start with one or more zeros. Not matter how many times I change the cel format to "text" so that the zeros are not dropped, I find that as I go down the sheet, they are dropped and I have to re-format the cels to "text" and replace the zeros. How can I stop the program from dropping the initial zeros? ... 12 12.02.2006 01:38:48 Modify width I want to see if I can modify the default width when I open all excel documents. Instead of say 8.43 in the first column width have it be like 9.5 And that setting on all files that I open. Is that possible? pjkwong@hotmail.com Thanks... 5 10.02.2006 15:37:30 excel does not open files on double click I have a user and when he double clicks an excel file, excel opens but the file does not open. To open a file, he has to open it from inside excel by going to file then open. So for files sent over mail he has to copy them to his desktop then open excel and then open the file. He is using excel 2000. What could be the problem and how can we resolve it? ... 2 10.02.2006 15:15:00 How can I prevent the reviewing toolbar from reappearing? I am using Excel in MS Office Professional 2003. If I remove the reviewing toolbar from my list of active toolbars it automatically reappears the next time I start Excel. How can I prevent this? ... 2 10.02.2006 12:35:58 How do I get an excel spreadsheet on the web to hold the changes . I can not get the database chose to highlight in front page.... 1 10.02.2006 02:05:27 Preserving customization My OS is Win XP Home and I use MS Office 2002. Specifically I use Excel and have generated custom toolbars and several macros. I am faced with the likelihood of having to make a clean "original" installation of MS Office and clearly don't want to lose my customization. I know that for Word, If I save Normal.dot and reinstate it with the new installation it gives back 99% of my customizati... 2 09.02.2006 09:52:29 How do I track vacation days on Excel? I want to create a calendar in Excel to track my vacation, personal and sick days? How do I do this?... 2 08.02.2006 21:58:33 How do I change the number of characters per cell? If pasting longer texts into cells, part of them gets lost. Use the Alt+Enter for every cell could be the solution, but really painstaking one. Is there any way how to cancel this limitation or how to increase the default number of characters for all files? ... 5 08.02.2006 20:40:51 Excel spreadsheet setup Can someone help me with this problem? Assume I have a row of cells named B1 and B2. Today I want the value in B1 to be the product of A1 times A2. Tomorrow, I will create another row of cells named C1 and C2. I will change the value of A1 and I want the value in C1 to be the product of the new A1 times A2. I do not want the old value in B1 to change from what it is today. Can you help ... 9 08.02.2006 20:30:30 Screen colour In Word it is possible to choose an option for a blue screen for people who find the normal screen hard on their eyes. I have looked for this option in Excel but can't find it. Does anyone know if it can be done (without simply colouring the background and creating a template). Thanks for your help Aehan... 3 07.02.2006 14:20:27 format time in 12hr mode without showing AM/PM Is there a way to format a cell with a generic 12 hour time setup without showing AM/PM next to the time entered? I need to enter scheduling information ranging from 8am to 1am without the cell noting AM/PM using 12 hour rather than 24 hour.... 2 07.02.2006 00:12:05 How do I my find pass word in excel -- Al shepard ... 1 06.02.2006 21:32:10 Problem with exporting xls sheels to txt files separated by tabs Hello, I have a problem with exporting Excel sheets to txt files separated by tabs that I can't find any solutions for. The problem is with fields containing quotation marks or apostrophes (every other fields are fine). To explain the situation I'll give you my own example: Field name in Excel (before export): R.E.M. - "Stand" - 7" (PROMO) Field name in text file (after export from... 3 06.02.2006 12:11:27 replace 'alt + enter' key by single 'enter' I have to enter a lot of data in cells that need to break the line and I need every time to use "alt + Enter". I would like to be able to swap the "Enter" and the "Alt+Enter" functionality, ie, exchange the key strokes but keep the functionality Thanks for the tip Gerson ... 4 06.02.2006 03:00:28 What happened to Excel? I use Excel every week to type up business documents, but today something went wrong. I clicked on the icon and a box popped up that said "Please wait while Windows configures Microsoft Office XP Small Business." Then it asks me to insert my Office CD. I've looked all over for my CD and I cannot find it anywhere, but I need to use Excel or I'm in big trouble. Does anybody know why ... 2 05.02.2006 13:49:32 Excel should have keyboard shortcuts for paste value/format Excel should have keyboard shortcuts for paste value and paste format I probably use those features more than anything else. maybe set it to cntrl+ w or something. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the ... 3 05.02.2006 02:32:09 Need help with creating a Range Name syntax This lets a user select which columns to sort by: A sort range is predefined. Row 1 is blank Now the user selects the columns to sort by: Within row 1, the user types a "1" in the column that s/he wants to sort by, a "2" in the second column to sort by, etc. My code is supposed to scan across row 1, locate the values "1" and "2", and plug them into the Sort Range value by creating R... 2 04.02.2006 20:22:17 how to do variance in canteen business may i know how to create a variance in canteen business in a day using microsoft excel. ... 1 04.02.2006 20:07:04 Stop Excel from dropping the 0 in the beginning of a number I found this same question on a Jan. 27 post, but my response there was too late so I am posting my experience again. The fix did not work for me.... This is exactly the problem I have in trying to save ISBN numbers which often begin with a zero. I have tried all three methods you have suggested. Once the text in the column appears correct, I save it in the xls format, and can open it in e... 3 04.02.2006 19:12:49 (.)(.) Hot... Call +8613352960090 Free! Multi-lingual! ... 1 04.02.2006 04:09:11 (.)(.) Hot... Call +8613352960090 Free! Multi-lingual! ... 1 04.02.2006 04:09:10 Installing Excell Feature Problem A few days ago I had to enable an add-in in my Excel program, specifically the Analysis Tool pack. Ever since then, every time I start Excel, I get a pop-up message which is titled "Installing components for Microsoft Excel" and I have to wait till it goes through the process of "Installing: Microsoft Excel Feature". I have tried unselecting the Analyis Tool Pack and also ran a "repair" of... 2 03.02.2006 20:32:30 38 Pages: <<  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38