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  >>   Sort information according to colors in Excel A lot of information in Excel often has to be colored in different colors in order to differ and comprehend this information easily. It could be both background and letter colors. Sometimes it could be hundreds of lines and tens of columns. It would be really helpful if Excel would recognize the colors, search for them, understand the difference and sort the info according to them. --... 3 26.08.2006 08:50:06 How do I Automatically open a sheet so it shows a specific tab or. Can anyone tell me how to save an excel file so that it always opens to a specific tab and cell regardless of where the cursor was the last time the file was saved?... 3 25.08.2006 17:36:22 Record New Macro I seem to have "lost" my Stop Recording and Relative Reference icons from my Record New Macro option in Excel 2003. They normally appear after you've named your macro just before you start recording. Help me get them back please. Julie ... 4 25.08.2006 15:21:05 Accidental Deletion I accidently deleted excel off of my hard drive and would like to know how to bring it back.... 3 25.08.2006 07:51:29 Unhidding Tabs Currently in 2003, we can hide tabs en mass by grouping. But when we want to get a batch back - we have to unhide them individually, the >Format>Tabs>Unhide dialog does not allow for multiple tab selection with Ctrl or Shift. This is incredibly tedious is large workbooks. I suggestion this be modified so multiple tabs can be unhidden at one time. Just like we can do for columns ... 2 25.08.2006 01:29:02 using mail merge existing document won't format I am trying to take an excel spreadsheet and merge it into a mailing document for labels. When I get to the part where it tells me to "use an existing list" and I pull up the excel document under Browse, the document does not format correctly. It is all jumbled letters and numbers. Help!!!... 2 25.08.2006 00:49:55 What is a Multilayer Spreadsheet? Can anyone explain what this is and where I can find some information on how to setup and work with one?... 1 24.08.2006 21:26:44 .NET 2.0 COM Excel add-in stops responding when SqlConnection object is created Dear All I have encountered a problem when creating a System.Data.SqlClient.SqlConnection in my Excel add-in. I am using: - Visual Studio 2005 - Excel 2003 SP2 I created the add-in with the VS2005 Shared Add-in Wizard. I then included the required Office and Microsoft.Office.Interop.Excel assembly references. In the OnConnection method I add two buttons to the Excel menu. In the ... 1 24.08.2006 15:35:33 How can I transfer data from iSeries in MS-Excel 2003 with SP2 Hi, How can we tranfer data from IBM iSeries in MS-Excel 2003 with SP2? But I am having option of transfering data from iSeries in MS-Excel 2003 with SP1 in Menu (Data). Could anyone guide me....... Best Regards, -Sumit C... 2 24.08.2006 13:48:37 How do I change default unit of measure from cm to inches? I have just installed Office 2003 on my new computer and I forget how to change the unit of measure from cm to inches. I want to be able to set my margins unsing inches, I don't want to have to get a ruler out every time I want to change a margin! Help! -- TTFN... 5 24.08.2006 03:24:56 How do I get a post card size invoice that calculates I can not figure out how to do it....Can any one suggest a template that can help me? It has to be post card size.... 2 22.08.2006 22:21:25 how to install exel how to install exel... 2 22.08.2006 21:28:15 Contents of cell not wrapping cutting off text Have a doc with 4 columns. Columm B has alot of verbage, text set up for wrap text but it is still cutting off text at the bottom. you can see the words at the formula bar but the words are not appearing in the cell itself. Any suggestions?... 3 22.08.2006 19:42:02 Can I link spreadsheets in two SEPERATE instances of excel? I have bought a graphics card to allow myself to work with two or more screens: I would also like to open 2 or 3 instances of excel. Would I be able to link sheets as if I had them all open in the same instance of the program?... 3 22.08.2006 08:16:04 fill colours I have tried the tools options reset but my colours do not display properly... 9 22.08.2006 00:32:54 Change hh:mm to hh.mm Is there a simple way change teh hour: minute separator in time formatted cells(columns) to accept the decimal instead of the:? Data entry would be so much simpler and quicker using the decimal point. Suggestions appreciated Thanks ... 8 22.08.2006 00:03:33 selective output tabling Hi, I have an extended table; A B C D E 1 key area code present required 2 1 LGA FD J3 2 1 3 2 LGA1 G2 0 3 4 3 LGA2 X5 3 0 5 4 LGA3 I/14 1 2 6 5 GA L2 6 0 7 6 1A Z1 1 2 8 ... The formula in 'E1' is: =IF(D2>=3,0,3-D2) All other cells contain static/manually enterd data. What I need to do is create another sheet that tabulates all keys that are required and omits those... 1 21.08.2006 17:00:25 why it never prompt to save after closing Need help. My excel will not prompt me to save when i close all worksheets. It apply to all. Thanks... 2 21.08.2006 11:05:01 How do I change one page to lanscape in an Excel worksheet? We have a very large docuement and all but one page fits fine using portrait but one page is just to big and needs to be landscape but I can't figure out how to change that one page and leave the reset at portrait. Thanks so much for your help... 3 20.08.2006 03:39:01 Linking cells (VLOOUP/IF function maybe?) Hi I am trying to find a way to pull certain data off a particular sheet onto a new sheet. I don't think I need a macro and can do it through VLOOKUP or a IF function. Would be good if someone could give me some help on this. Essentially I want to pull the data in columns A, B and I into a new worksheet. But I only want to pull these cells when in column H it says 2. So i guess Im sa... 3 20.08.2006 00:15:01 How do I save personal menu bar settings when closing program I receive sheets from various users and there menu bar setting replace my settings and I would like to keep my personalised menu bar as a standard so that it will become my default menu bar on opening other users sheets and on restarting program. Is there any hot key scenarion before closing or is there a procedure in the options menu..... 1 19.08.2006 07:41:02 file open details option stopped working My file open details option no longer works. I can get icons and a list but not details with file name, date, etc.... 4 18.08.2006 20:42:41 tabbing from 1 sheet to another in the same .xls w'o clicking How can I tab from one sheet to anothe in the same document by using the keyboard - not a mouse?... 2 17.08.2006 21:38:05 I don't want to see the background page #s when a .xls is open the background page numbers that Excel automatically puts in tghe background of a spreadsheet make it hard for me to see some of my numbers. How can I make them disappear?... 3 17.08.2006 20:30:02 Print Set Up Using Columns When I select columns A through Y and use this as my Print Setup range my session of Excel becomes extreamly slow. The more colums I select the slower it operates.... 1 17.08.2006 14:57:02 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  >>