| Thread | Last Post | Replies |
|
| ActiveCell | 13 Mar 2008 20:49 GMT | 3 |
I am trying to achieve If ActiveCell In Range ("C22:K22,C24:K24") Then but I require assistance with the correct syntax. Thanks
|
| wasy macro question | 13 Mar 2008 19:19 GMT | 6 |
I used the macro recorder to get the code to resize columns on a worksheet Cells.Select Range("A1766").Activate Cells.EntireColumn.AutoFit
|
| Excel 2007 acting weird | 13 Mar 2008 17:25 GMT | 8 |
So I go into My Documents and double click an existing Excel file to open. Seems quite normal, no? This document opens, as well as a separate file "Book1". It gets rather annoying, that I've already opened the file I want. I didn't open Excel (start w/ a blank workbook) then go ...
|
| missing menus | 13 Mar 2008 15:26 GMT | 2 |
when I open excel the only thing I can see is the title bar and the cells. all the icons and menus are missing eg file, edit, insert etc how do I get the menus back
|
| Removig Duplicates | 13 Mar 2008 15:05 GMT | 1 |
Is there anyway to remove duplicates when the first 3 words in cell are the same even though the last few words are not the same ex: O:\01-English\01-ETnc\01-R7046-1\02-PrevLessons\04-chas
|
| Possible to indent the height of a row? | 13 Mar 2008 12:57 GMT | 1 |
Is it possible to apply a standard size across all rows, so that all tops and bottoms of the rows will be a specified distance from the text (similar to an indent, but from top to bottom) Thanks.
|
| Cell colour according to date | 13 Mar 2008 12:00 GMT | 2 |
Is there a formula that would change the cell colour if a date in a cell was out of date afetr a set number of years. Example: Cell B9 contained date 140506
|
| Dividing a linear goal | 13 Mar 2008 11:46 GMT | 2 |
I am trying to chart a weight loss goal and I want to put in a starting weight and a goal weight in a sheet showing a wieght goal for each day and have excel autofill the equal divisions for the days in between. Is there a function or something that will do this? Thanks.
|
| Help with a multi if then else formula. | 13 Mar 2008 11:31 GMT | 5 |
I have the following scenario for which I would require one formula which would be in cell E25:- A numerical weight amount is input in cell A25. If the weight is between greater than 1 and less than 41 KG, the user will
|
| send mail recipient gray (inactive) | 13 Mar 2008 10:43 GMT | 1 |
I am working with excel 2007 and I added "send mail recipienton" on Quick access toolbar. and now it is gray(inactive) and I can't select it. I am using Outlook 2003. I tried this kb but it didn't work for me. My registry keys same.
|
| Hour format | 13 Mar 2008 08:19 GMT | 2 |
I'm trying to format cells in excel 2007 with the hh:mm format and keep getting a date / time show in the function line and the wrong time in the cell. e.g. format cell - time - custom - hh:mm type in 12.15 and cell shows 03.36 function line shows 12/01/1900 03:36:00AM
|
| printing complete pages | 12 Mar 2008 22:11 GMT | 4 |
When I go to print I only print one column
|
| Excel on Mac -- Where is formula bar? | 12 Mar 2008 20:39 GMT | 3 |
My friend has a Mac is now learning Excel. She has toolbars Standard and Formatting checked. The formula bar is missing from up in the menu of the toolbar functions.
|
| How to transform a cell value that as no comma like 43534 into 435,34 | 12 Mar 2008 20:36 GMT | 3 |
Hello to ALL. I would like to know what should i use as a command or formula on Excel in order to transform a cell value that as no comma like 43534 into 435,34. Is it possible to do this in Excel?
|
| Is this possible please | 12 Mar 2008 20:05 GMT | 9 |
Is this possible or am I asking too much of excel? If I have 254 working days in the year from D4 to D257 can it be done by a formula to work out the percentage automatically when a person is absent? It needs to know how many working days has passed in the year. Obviously up
|