Threads Replies Last Post 38 Pages: <<  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  31  32  >>   Making a column or cell required I posted this a few days ago and got some good responses, but nothing that's actually accomplishing what I had hoped (maybe it really just can't be done) The specifics are: Creating an NPO reimbursement form where, in order for the form to be valid, the employee needs to enter a project code into a column entitled '"Project" The goal is to make it so that if this column is not filled in... 2 27.04.2006 00:56:22 one step update we have a invoice spreadsheet which gets firgures fron a another spreadsheet & makes invoice for ex: invoice column 1= Quantity invoice column 2= Descriptition invoice column 3= Price invoice column 4= Total Field 1= Name Field 2= Add Field 3= City in the other spreadsheet we have columns with all description of these column , we like to be able to pick row 36 from other ... 1 26.04.2006 19:08:02 Insert Multiple rows I want to have a macro or shortcut which i can use to insert rows to spreadsheet, so if i run the macro it will ask how many rows i want to isert and at between which rows then add that no of rows and alter formulae to include new rows... 2 26.04.2006 18:44:45 Problem with Pasting Data I am having a problem with copying and pasting Data into excel from a certain webpage. The problem is that it takes too long for the data to get pasted into the excel sheet. The problem suspected is that there are some images very very smal which have links embedded into them and excel takes tool ong for pasting the links.....is there any way to make it faster coz i dont need the link... 1 26.04.2006 17:18:01 Spreadsheet shortcuts not working We have shortcuts to spreadsheets setup but when we click on them excel comes up but the spreadsheet does not load and there are no error messages. We redid the shortcuts and if we follow the path in the shortcut the spreadsheet opens. But when the speadsheet opens it gives errors that it can not find other spreadsheets that seem to fragments of the spread sheet name. For example if I op... 3 26.04.2006 12:57:02 Excel view won't hold Hi I set up a Excel with a certain view, when I close it and open another spreadsheet the view is lost. How can I get Excel to keep my configured view on whatever spreadsheet I open. Thanks ... 3 26.04.2006 12:20:37 Margins How do I change the margins ... 2 25.04.2006 22:01:49 Collate check box in the Print Dialog Box Does anyone know what the registry key is to uncheck the Collate check box in the Print Dialog Box. KB Article listed below explains the problem of "Separate jobs ar sent when you print multiple copies of excel. This only works until you close out of excel and open it back up again. I would like to find a permanent fix to this problem. http://support.microsoft.com/kb/211474/en-us Tha... 1 25.04.2006 21:55:02 How do I make a particular column required in Excel? Our NPO is creating a reimbursement chart in Excel. We're trying to make it so that if employees do not fill in one particular column entitled "Projects," they will get an error or will be unable to have a final sum filled in. Is there any way I can make this particular column required so that if it is not filled in, the chart will not complete properly? Thank you in advance for any ... 3 25.04.2006 10:56:01 Make Money From Google Google AdSense is a fast and easy way for website publishers of all sizes to display relevant, unobtrusive Google ads on their website's content pages and earn money AdSense for search results pages use Google's search to provide relevant results, and the search results pages are customizable to fit with your site's theme https://www.google.com/adsense/?ai=BRRgZ9XRNRM... 1 25.04.2006 06:35:23 How do I set up a protection - IRM on my Excel workbook? I wish to find out the way to setup the Information Right Management (IRM) in my excel workbook. Any advice pls. Thks.... 2 24.04.2006 17:37:34 Display Problems in Excel 2000 I have a user that is trying to open an Excel file. Not a big file, mostly text that has been highlighted with different colors. When she tries to open the file, the screen stays blank. You can use the Go To to get to a cell and the information will display in the formula bar but not the body of the Excel screen. Any clue what could be causing this problem? Thanks!... 1 24.04.2006 15:26:02 square cells I want to change the grid into a pattern of square cells. I want the hight and width to be equal. Can this be done? The reason is that I want to use the grid as a background for simple drawings of products. Is there perhaps a better way to do this in an office-program?... 4 24.04.2006 08:58:01 How do I set my printer to show macros when I print a worksheet? I am trying to print out a copy of the worksheet I have created using Microsoft Excel with Microsoft Office Proffesional edition. When I print the page the macro buttons do not show but the rest of sheet does. How can I make it so the macro buttons show also?... 3 23.04.2006 18:20:02 Button Help Why cannot i put a button on the sheet I want to? I can do it on a blank sheet or even other sheets in the same workbook. As far as I know there are no differences with the two sheets. The forms toolbar cursor changes to a small thin cross on both sheets but will not generate a box on the sheet I want to put it on. Is there perhaps a setting I need to adjust?? cheers nobby PS its... 3 22.04.2006 08:33:19 column headings on page bottom I would like to print my worksheets so that the column letters appear on the top of the page and again on the bottom of my page so when I am viewing a hard copy I know what data belongs in the specific lettered column. I have looked in footers and print options. Can this be done? I appreciate any help!... 3 22.04.2006 02:13:58 Workbook Set-Up Questions Hi, I need some ideas on the best way to set up an Excel workbook for the following scenario: I receive a .csv file weekly that contains 20 colleague names (this number fluctuates weekly) with 30 data points that need to be tracked. The file contains my colleagues' names as a "row label" in column A (beginning in cell A:2) and each of the 30 data points as column labels (beginning i... 1 22.04.2006 01:03:01 Unrecognized format Using 2000 I send 4 query results to Excel using the TransferDatasheet command Export to Excel 8-10 to a predefined excel spreadsheet. After I run it once, if I try to rerun it with new data, I receive a mesage that the spreadsheet is in an unrecognized format. If I send it to another user who has the exact same version of Access and Excel, she gets the error the first time.... 1 21.04.2006 16:27:02 Menu Bar In attempting to prevent automatic recalculation in Excel, I went to Tools, Customize and the Tools optiion disappeared from the menu. How can I restore it?... 5 21.04.2006 14:03:02 Why is Excel now opening a blank workbook? Just recently Excel is now opening a blank workbook - either when I open Excel using the Excel icon, or when I try to open an existing file - what gives?... 1 20.04.2006 19:27:02 I have a question I hope this is not a repost... I have a Excel Workbook with four tabs. Now I want to get information from 1-3 (totals) tabs and place that information into some cells on tab 4. I don't want to cut and paste, I would like it to be a =sum or something like that. Can this be done? Thank you Devon... 3 20.04.2006 18:53:02 Find & Replace Option in Excel 2003 In Excel 2003, you can find data "within sheet" or "within workbook" when you press Ctrl-F, then "Options" button. How can I made "within workbook" the default setting? Maybe a registry key?... 1 20.04.2006 16:44:02 i am unable to add, delete or modify in excel or word. i am unable to add, delete or modify in excel or word. Even the function toolbar is inactive. Pls advise what is the problem?... 2 20.04.2006 16:36:59 hOW TO ELIMINATE COL. ABC ROW AND ROW NUMBERS IN EXCEL SHEET I want to print an Excel Sheet where the Top row with the Columns are A, B, C, etc and also eliminate the Row Numbers on the Right -- Please, I haven't done it in so long I don't remember and can't find it in my help or in my book. Thanks... 4 20.04.2006 15:47:02 how do I set the status bar to count results from filter? How do I set the satus bar to count the results from the filter. It just says ready and when you filter it then says filter mode.... 2 20.04.2006 10:49:49 38 Pages: <<  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  31  32  >>