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   File from Desktop Excel 2K on Win XP Pro. If I open Excel first and then a sheet, it works fine. If I try opening excel sheet from my desktop it takes much more longer than open excel and then opening same sheet. Any idea?... 2 03.02.2006 20:08:28 USING TEXT AND NUMBERS IN SAME CELL Hi I am trying to type in something like 21lb 8oz but also use the decimal version 21.5 in the same cell as a number,so i can use =sum. I do not need to see the number 21.5, in fact it would be prefferable not to. Can anyone help.... 4 03.02.2006 17:54:31 Can default footers be set in Excel? I want all my new worksheets to default to a footer that includes the path and file name. How can I accomplish that in Excel?... 4 03.02.2006 03:09:46 create formula. 1 field constant and another field varies by inpu. need a formula that takes the 1st number from a field that is inputted by me and multiplies it by 2nd number i input into another field and then divides by 100. I dont want extra columns to show. I want to put the number in the field and when i press "enter" key or "tab" key to move to next cell, that previous field to calculate and insert the answer into that field. example is as follow... 3 02.02.2006 23:09:27 cannot get color in cells and words I click on a cell and want to fill the cell with a color so I click on the little paint bucket on the top right but it does not fill the cell with the color. Also if I type words and want to change the color of the words it does not work after I highlighted the words and click on the A icon. Any ideas? At work I have no problem doing this. ... 2 02.02.2006 13:35:44 I need to set up a schedule in excel for home health aides Does anyone know of a template I can download? I will have more information tomorrow . Thanks... 1 02.02.2006 00:04:28 open new window default I want all files to open in new windows, not to be stacked into one window. How do I make this happen?... 3 01.02.2006 19:28:37 how do i get word 2003 to open documents in a seperate windows? how do i get word 2003 to open documents in a seperate windows? I've upgraded a desktop from 2000 to 2003, but all office apps refuse to open new/other documents into seperate windows (so no alt-tab happiness for me). Any help would be g8! Thnx Sean... 4 01.02.2006 01:58:46 UDF not returning proper value - circular reference/multi workbook Hi all, I have a data workbook (values, and matrices) and a workbook does the calculation (contains UDF). Calculation workbook with circular references is linked to Data workbook. When a value is changed in data workbook, the calculation workbook ALWAYS returns a wrong answer (although the UDF is thoroughly tested and always yields expected results). It can be corrected when th... 2 01.02.2006 00:52:14 How to activate my Microsoft 2003 system reject product key Trying to use prodct method to activate my 2003 version of microsoft and it will not work. Need assistant... 3 31.01.2006 19:48:10 how do i duplex different orientation worksheets in excell trying to duplex print a excell workbook but one page is setup portrat and the other is landscape and my xerox 230st will not print the 2 sheets duplex on the same sheet of paper help me please!!!!... 2 31.01.2006 03:07:37 old xls file conversion I have very old xls files that I would like to convert to the new workbook style with tabs. These files were created 15 years ago but I still update them every week. I converted smaller files by copying them to a new workbook, but I think there must be an easier way.... 4 31.01.2006 03:02:29 Pivot Table Layout Can I copy a Pivot Table layout from one workbook (excel file) to another? My app cretes a series of xls identical reports and I am having to setup the layout every time.... 3 30.01.2006 23:55:29 Insert current author's name in cell or footer in Excel?? I have created a spreadsheet for my department to use to list their projects for each week. Just wondering if there is an automatic way to have the various author's names inserted in the footer or in a cell without them needing to do it. Any suggestions would be appreciated...... 2 30.01.2006 16:50:40 How do I get a Quattro Pro Convertor for .wb3 in Excel 2000 Premi. I can only find a .wb1 convertor, which doesn't work.... 2 30.01.2006 04:27:04 Why can't I open excel documents? I have to click on the "New Office Document" , then open the file. I can't just click on the file and automatically open.... 3 29.01.2006 13:31:27 testing possible web interface glitch -- do not respond Please don't respond to this message; it's a test. And yes, I know about test newsgroups, but that's not what I'm testing. Really. <g> I'm testing a user's error in posting via the web interface. -- Dirk Goldgar, MS Access MVP www.datagnostics.com ... 4 27.01.2006 20:43:01 How do I get all text to show up and print all of it in cells? I am using Excel 2003. In spreadsheet, used for text only (for convenience) I cannot get the cell to show all the text that is typed. You can see it on the line at the top of the spreadsheet when you type it but it will not adjust itself to the cell. One of two things happen, 1) the text is cut off completely but show on the monitor or it runs on out of the cell. I have tried all for... 2 27.01.2006 16:12:07 copy page settings to multiple worksheets in excel? I have excel 2002. I have multiple worksheets in a workbook. I changed and reset the page setup in one sheet to have a certain size (57%), margins and page breaks so it would print OK. I wanted to group the sheets and do this to all worksheets but the page settings are not saved on the other sheets. How can I copy this format to multiple sheets and also copy this format to other workbo... 2 27.01.2006 15:28:58 Automate column selection Is it possible to set up excel so that the proper column is selected for numerical entry dependent upon a text entry in a row?... 2 27.01.2006 15:26:05 building a web site I just got back working on my website. Its taken a long time to finish but I am getting there. I got great web hosting at http://www.domainnamefree.net where I got a free .com name and a good site builder. Im going to keep working on it ill let you all know how im doing. Paul ... 1 27.01.2006 01:26:46 Why can't I use XML in the Student and Teacher Edition? Am I missing an Add-in? I can't believe I wasted my money buying this version of MS Office, when I can't even use it to complete the assignments when XML isn't available.. Any clues? Thanks, GunnyUSMCRet... 2 26.01.2006 17:00:54 How do I change print option defaults? When printing in Excel (2003, ver 11.6355.6408), I always use the Scaling option in Page Setup and set it to "Fit To: 1 page wide, x 1 page tall." Is there a way to make this the default setting for all print jobs? Glen... 4 26.01.2006 12:26:39 Moving beteween sheets using the tab button I'm using XL 2003 and i want to use the tab button to move between the different tabs/Sheets in a workbook. any idea how to set it up? thanks, Amir... 2 26.01.2006 11:49:59 HOW DO I CHANGE THE SIZE OF THE NUMBERS IN ROW LABELS? THE ROW HEIGHT SETTINGS ARE NOT UNIFORM AMONG WORKSHEETS IN MY WORKBOOK AND THE NUMBERS ARE TOO LARGE WHEN I DECREASE THE ROW HEIGHT. HOW DO I CHANGE THE FONT SIZE FOR THE ROW/COLUMN LABELS? AND WHY DOES THE ROW SIZE DIFFER BETWEEN WORKSHEETS?... 1 26.01.2006 03:12:02 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