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  >>   Research Tool Is there a way to turn this off? Thanks! ... 1 13.09.2006 17:25:02 How do I protect selected cells on my worksheet? I have a worksheet/workbook which is used by different Cashiers to summarise their daily Bankings at the end of each. The worhsheet has columns on which data is entered and totals are calculated in one column where I have put formulae. I often have problems with some Cashiers who erroneuosly errase fumulae by touching wrong buttons. how do I protect the cells which have formulae so that ... 2 13.09.2006 11:28:43 Making a file smaller I have a spreadsheet that is 35mb in size and given the number of sheets and calculations it should not be this big. It used to have a large number of links in it that someone had put in, which I think contributed to the large size. I broke those links but the size still will not come down. Any suggestions or ideas of how I can easily compact or reduce the size of this file? Thanks i... 4 13.09.2006 08:27:46 How do i change the date formula I type in the date e.g. 1.06.06 in the cell and it automatically changes to 06.06.2001. How do i change this so is remains as 1.06.06 in the cell? any elp would be appreciated... 3 12.09.2006 22:28:37 Check Font? Any ideas on how to duplicate that rather unqiue font type that appears across the bottom of a check where a check shows the check #, ABA #, Account # etc, each category usually delimited by some unusual characters? Thanks... 3 12.09.2006 21:55:01 How do I get rid of old links in a spreadsheet? It's bugging the bejeezus ou of my users (especially the folks opening it via trans-oceanic links). There are tons of pop up messages saying Unable to open http://blahblah.bla.com/Documents/Stuff.xls. The internet site reports that the item you requested could not be found. (HTTP/1.0 404). Now obviously it's trying to pull up links that no longer exist. How can I either 1(Prefered) rem... 4 12.09.2006 21:30:36 Format Worksheets in a Workbook How do I set a global print format for many worksheets within workbook?... 2 12.09.2006 17:38:13 How do I make excell print out bigger I have a expense report that prints out too small. How do I make it print out larger ?... 2 11.09.2006 22:19:17 Exporting calculated values How do I set up an Excel worksheet to export calculated values into an Access database? Susan... 3 11.09.2006 17:27:02 How do I not print the column letters A-Z but keep the row #'s I am trying to print a chart where I want to keep the row numbers but not the column headings A-Z printed. Choosing Page setup under the Sheets tab only lists them together not as single choices. Is there a way to customize the sheet to only list the row numbers?... 2 09.09.2006 17:50:02 Excel - e-mail font I've asked this question 3 times now in the past year and every time I get a response from an "expert" who gives me a canned answer without really reading my question. Here goes again. I have Office 2000. I use Outlook not Outlook Express. I have the default font set in Excel, Word and Outlook to Century Gothic. However, when I intitiate an e-mail from inside Excel (File - Send to... 2 09.09.2006 12:51:15 How do I remove the page count on work It should be easy but I cant find it or recall how it got there.... 2 08.09.2006 22:39:05 Deleting phantom macros Hello, When opening up an excel file I get the dialogue box asking me if I want to enable or disable macros. However, when looking in tools->macros, there are no macros present. Is there somewhere else I can look for "phantom" macros, like there are with phantom links. I know I can change the security to not show me the dialogue box. I'd rather not turn it off. The issue is there do... 3 08.09.2006 10:47:27 Excel - Automate row width for merged cells with wrapped text Excel should allow a row to autimatically set the width of that row when a merged cell has wrapped text. Excel only allows the cell to automatically set the width if the wrapped text is in a single cell but not when it is in a merged cell whether it is merged side by side or top and bottom merging. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the ... 1 07.09.2006 21:23:01 Excel Question I have a spreadsheet that I am working on where I define some of the information in an area on the excel sheet (For example I have 1/2, 1, 2, 2/4, 3, 4, 4/5, 5, 5/6. These fields are used for a drop down list on the same excel sheet and allow them to pick one of these numbers within that cell. I then take the information from that cell and input it on a cartoon to display in an area on... 2 07.09.2006 20:12:02 Sort column by second word in cells First & last name are entered in the cells of column A. Anyone aware of a procedure that will sort column A by the second word in thr cells (last name)? Or perhaps, a procedure that will reverse the position of the 2 words in each cell (move last name to the first position)? Or finally, move one of the names into a second cell? (for a column with about 3,000 entries) Grasping for... 2 07.09.2006 20:07:34 Loading Data into Multiple sheets in 1 book Loading Data into Multiple sheets in 1 book Hi All I have 2 questions 1. I am trying to automatically create a workbook with a number of sheets in it with different data. I see how the command mode allows you to feed data to a (one/first) sheet (C:\Program Files\Microsoft Office\Office\excel.exe" H:\':DETAIL.XFER.SHORT.FILENAME) but how do you get data to sheets 2 3 4 etc in the workbook?... 1 07.09.2006 14:41:35 Colors as Default I have reformatted the colors in Excel 2000. I've read the messages about storing it in the Startup folder. But when I open a new workbook, it tries to save over the one in the startup! That's not what I want. I want the template with the edited colors to be my default. I want it to open as a new workbook, and I want it to save into my default directory -- Data/Spreadsheets. I a... 15 07.09.2006 13:47:08 Excel opens, but document doesn't When one of my users opens an Excel document, Excel opens up, but the document doesn't. It just sits on the grey 'background' screen. I tried logged onto his machine as admin and it works OK, so it seems to be something specific to his account. I ran detect & repair (just in case!) but this didn't make any difference. Any ideas? Cheers.... 2 07.09.2006 11:59:47 ms query file location How can you set up the search to look in CURRENT directory where the EXCEL workbook you are using is located? If you put an workbook on a shared server, the queries assocated should be located with it. The workbook should know to look there and use that. Not something maybe but probably not located somewhere on someones C drive. MS please stop forcing all files, documents, workbooks,... 1 05.09.2006 20:46:02 Gana dinero facilmente Invierte solo 7 dólares y gana ayudando.. begin 666 HAZ UN GRAN CAPITAL AYUDANDO A LOS DEMAS.....doc MT,\1X*&Q&N$`````````````````````/@`#`/[_"0`&```````````````! M````6@``````````$ ``7 ````$```#^____`````%D```#_____________ M____________________________________________________________ M____________________________________________________________ M________________________________________... 1 05.09.2006 17:50:38 How do I have "Active Worksheet" be the default for Print? Have migrated my MS Office 2000 from Win2000 to XP. Not sure why, but now every time I go to my Excel print dialog, the "Entire Workbook" radio button is set instead of "Active worksheet". How can I resolve this and have the default selection be "Active worksheet"?... 1 05.09.2006 17:32:03 how to set up spreadsheet for beginners ... 2 05.09.2006 16:49:28 Slow startup Both Excel and Word take much longer to start up, and show "running virus scan" in the lower left status bar. This has been happening for several months, possibly since I installed Norton Internet Security 2006 package. Is this a typical result of that package? Never took so long before, when I had a prior version.... 1 05.09.2006 16:03:02 How do I sum up a column hours, like 9:30am - 5:30pm, in Excel? I'm doing a timesheet for my niece and am having a problem (I'm not very skilled at Excel - yet!). She needs to write down her entries in one cell, like 9:30am-5:30pm, or 8:00pm-4:00am, with a total at the bottom of the dcolumn showing that day's total hours worked by the various employees. How do I go about it? ... 7 05.09.2006 15:37:19 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  >>