Threads Replies Last Post 56 Pages: <<  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  31  32  33  34  35  >>   Date Conditional Format I need a formula or code to apply into a cell that will flag a user if a record is greater than 90 days from today. I have tried variations of IF statements using the now function but have not been successful. Any assistance would be appreciated. ... 4 9/25/2006 2:17:01 PM how do you activate the right click drop down menu in Excel? I just got a new computer at work, and the right click menu doesn't work. How do I turn that feature on again?... 3 9/25/2006 1:11:15 AM Select All missing, Ctrl-A not working (Excel 2003 SP2) The Edit menu does not contain a Select All item. Using Ctrl-A does not Select All, if there is an area to select. For Example consider range (A1:A8) with data in each cell except for A3 and A6. A1 A2 A4 A5 A7 A8 Placing the cursor on A5 and typing Ctrl-A only selects cells A4 and A5. This is on each computer running Excel 2003 SP2 that I have tested. Is Microsoft gettin... 7 9/25/2006 12:54:30 AM Customized Toolbar Deployment for Excel 2002 Hi-All of my users need to use an in-house, customized toolbar in Excel. Is there a way I can mass deploy this toolbar, complete with button names, without having to configure it at each individual workstation. Also, is there a way I can import that same toolbar into Word? Thanks... 4 9/22/2006 1:56:31 PM permanently remove gridlines in regedit for Excel 2003 How do I permanently remove gridlines? I want to do this in regedit for Excel 2003. The current posts/replies do not seem to work as I do not have an Option3. Should I create a new dword? If so what should the value(s) be? Hex or decimal? Any assistance appreciated.... 4 9/22/2006 2:21:51 AM Use the Merge & Center Button with unprotected Cells - sheet prote In Office 2003 the Merge and Center button do not function when the sheet is protected while the unprotected cells do the same behavior, but if you move or cut merged cells and paste to another unprotected location the merged cells become unmerged and the target location becomes merged on an unprotected area. This behavior is good when you need to have part of the sheet protected and par... 2 9/21/2006 11:49:40 PM Startup and template locations in Citrix TS session and local session 'Morning all, Following a take-over I'm trying to work out how to make our Word and Excel 2003 add-ins and templates work properly both in an ordinary local session of Windows 2000 Pro (whether or not connected to the network) *and* in remote sessions via Citrix terminal services. Citrix is the new element (also it's change from a Windows to a Novell network). Until now, the setup h... 3 9/21/2006 9:42:50 PM HELP! Two excel windows I recently installed Hyperion Smartview and ever since then, every time I open an excel worksheet (whether or not it is linked to smartview) an extra worksheet (book1) opens! It isn't affecting excel at all, but it is quite irritating because everytime I save the sheet I am using and close it, it asks if I want to save book1. Any ideas as to how to prevent that extra window from opening??... 5 9/21/2006 8:06:01 PM How can I turn off the clipboard icon when cut and pasting? When I cut and paste a little clipboard icon follows the pasting throughout Excel. It constantly blinks and it's there in my way. How can I turn that stupid thing off? I know I'm pasting. I don't need it to remind me! LOL Thanks in advance. Caroilin... 2 9/21/2006 4:40:02 PM Make available online notify users update Hello, I have an excel worksheet I would like to make available online. I invite users (not on my exchange network) to view/edit. All users notified when there is a change. Perhaps this can't be done and I need to go to a provider that hosts Excel in collaborative mode. thanks. Daniel ... 1 9/21/2006 10:35:51 AM Viewing separate worksheets in a workbook on 2 different monitors Is this even possible? Anyone know of how I would go about implementing this? Thanks... In the same workbook, I have 2 worksheets: worksheetA, worksheetB. I want to view worksheetA in Monitor1, view worksheetB in Monitor2. ... 2 9/21/2006 1:34:01 AM How do I activate the xls feature to combine and compare workbooks How do I activate the xls feature to combine and compare workbooks? I want to combine workbooks and be able to compare the data in each; and show changes between the books.... 2 9/20/2006 10:38:40 PM Excel Tempate Issue When Opening Existing Excel Workbook I've created an Excel template and put it into the recommended location and it works. However, when I open an existing Excel workbook from explorer, instead of just opening the workbook that I want opened, it also opens a blank workbook. I have to go close the blank workbook separately, which is a real pain. How can I keep this "extra" blank workbook from opening every time I open an e... 1 9/20/2006 3:35:02 PM how do i add cells within a cell I need to add cells within a cell and still keep the format the same... 2 9/20/2006 12:23:29 AM How do I get the tab for open workbooks to my 2nd monitor? ... 1 9/19/2006 5:10:01 PM Excel links break on network I have number of excel files with 3 to 4 links in most of the file, shared on intranet, now i am having the problem that when any user other than me access to these files through intranet the links break everytime and the information from the linked source not updated until links are updated everytime when file is open through intranet ad when any user access any excel file and save it w... 1 9/19/2006 9:30:02 AM excel link breaks on network I have number of excel files with 3 to 4 links in most of the file, shared on intranet, now i am having the problem that when any user other than me access to these files through intranet the links break everytime and the information from the linked source not updated until links are updated everytime when file is open through intranet ad when any user access any excel file and save it w... 1 9/19/2006 6:45:01 AM how do i use the trial version how can i get to the point where it ask for the product key while trying to run the trial version... 1 9/18/2006 11:21:01 PM How to change cases from small to capital in all cells? I have to change the case of all characters from small to Capital in all cells of an excel file (Excel 2003 and lower). MS Word has a command called: Change case, which changes the case of selected letters from Capital to small and vise versa. Is there any equivalent of this command in Excel? I couldn’t find it. If there is not, what is the fastest way to change all letters from small t... 4 9/18/2006 8:26:15 PM XL2003, how can I set the view to show only the cells with data In Excel 2003, how can I set the view to show only the cells with data in them and the rest of the spreadsheet be hidden or just show a blank area with no cells showing? -- S Thomas... 4 9/18/2006 3:56:05 PM How do i change the format of a 2 digit date How do i change the format of a 2 digit date in months to a four digit showing years and months? 34 = 0210 11 = 0011 45 = 0309 I have a series of months in each cell like 34. I want to create a formula where it will show 0210. Thats 2 yrs and 10months. It can be a text format cell. Thanks, ... 2 9/17/2006 8:31:24 PM upgrade to Excel 2003 - loss of text color on screen i have just upgraded my office application from Office 2000 to Office 2003. I have accessed spreadsheets created in Office 2000 in the new application but find that all the text and cell coloring that was done in the original does not show up any longer in the viewing screen but that when one views the document for printing in color all the text and cell coloration is in fact present sti... 4 9/17/2006 5:04:00 PM Ability to paste from Picture Manager to Excel Hello I have a client who wants to paste from Picture Manager to Excel (Office 2003). When we try the paste Icon is disabled in Excel. We have found a work around by using the File/send to/Microsoft Office. The icon seems to work for Word and Powerpnt. anybody know if I can make the paste icom work or give me some direction for my customer. Thanks for any help... 2 9/17/2006 3:23:01 AM Saving Excel E Mails in a Word Folder When I receive an email with an attachment in Excel – I do a “Save As” and save the excel file as an excel file in a word folder. When I click on the file which is in the folder as an Microsoft Excel Worksheet – it opens the file, but it is not readable – squares and xxx’s. How do I get an excel file that I have saved from email to a word folder to open so I can read it? HL -- HNL... 2 9/16/2006 9:23:02 AM Excel auto opens several workbooks full of Gibberish upon startup -- Please Help Hello, I am running excel 2002 on a client machine in a domain environment. When ever I open excel, it automatically opens several workbooks full of junk text, one of which looks like an old backup listing of my IE favorites. I don't know this happens, I've tried restalling the entire office suite and then running office updates again with no change. However, if I log in as a differen... 4 9/16/2006 6:57:01 AM 56 Pages: <<  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  31  32  33  34  35  >>