| Thread | Last Post | Replies |
|
| Can anyone help me as i have never used excel before | 01 Oct 2007 22:06 GMT | 7 |
I am new to windows excel and i am typing in column 'A' the following; 08 001 08 002 08 003
|
| How do I subtract one column from another? | 01 Oct 2007 22:02 GMT | 4 |
I am trying to subtract columns in excel to get a third column with totals automatically without having to subtract each row individually. please help!!!
|
| Unable to Change Value After Entry in Protected Cell | 01 Oct 2007 21:34 GMT | 1 |
So here is the scenario. I have marked cell B10 as unprotected. I then proceed to protect the worksheet. As expected, when I try to type text into any other cell I cannot, when I try to type info into B10 I can, that's all good. The problem is when I try to EDIT the value I already
|
| Sorry but i am stuck again | 01 Oct 2007 20:46 GMT | 5 |
Now that john has told me what to do and it has worked for me and saved so much time, please forgive me but i have 2 questions if nobody minds ? 1. I have some gaps. ie; 149 08 100
|
| Combining Wroksheets | 01 Oct 2007 18:13 GMT | 2 |
Does anybody knows if it is possible to combine several worksheets in a workbook into a single workbook? Thanks !!
|
| Toolbar | 01 Oct 2007 18:01 GMT | 2 |
How do I get rid of Icons? I have two I would like to get rid of as they are merely a nuisance for me. Euro Conversion and Euro currency sign. I do not think I will ever need them, at least for now. Thanks
|
| Adjusting lookup range | 01 Oct 2007 17:20 GMT | 2 |
Hello - I am using a lookup function e.g lookup(a1, b1:c55) - but I would like to be able to ajust the range of the lookup vector based on values in other cells. E.g. I would like to be able to type 3 and 21 into cells M1 and N1 and make
|
| Trying to add a formula | 01 Oct 2007 17:17 GMT | 1 |
As part of my macro i have this block of data where i need to insert 3 lines whenever the contents of column B changes. I have tried various formats of inserting a calculation, all to no avail, where i have the string of question marks. Basically i want to insert a formula that
|
| How do I print | 01 Oct 2007 16:44 GMT | 2 |
I use Excel for a grocery shopping list. it's now expanded to about 80 items. I'd like to be able to read the list, but it's so long now that the type is about 3 point. What I'd like to do is print the list in 2 columns, and if it ever gets to this
|
| Display workaround | 01 Oct 2007 16:17 GMT | 3 |
If you want it to display the value correctly you can raise it to the third power, then by the one third power. i.e. =((850*77.1)^3)^(1/3) and it will display 65535.
|
| Inserting picture without loss of information | 01 Oct 2007 15:46 GMT | 4 |
I'm attempting to insert some cropped sections of very high resolution (3000x2000) bitmaps into Excel. The problem is when I insert the cropped images there is some processing done on the image before it is displayed. This processing blurs some of the pixels.
|
| Excel printing | 01 Oct 2007 14:49 GMT | 3 |
In printing in Excel the "Print What" defaults to "Active Sheets". It used to default to "Selection". Any suggestions as to how I can get the default back to how it was? Michael
|
| "That name is not valid" error | 01 Oct 2007 14:21 GMT | 2 |
I'm trying to use a macro ran from a button press to set the cell name (label) for a set of cells. This used to work before but now I'm getting "That name is not valid" Googling it I don't find anything that really applies to me. The name
|
| VBA code does not work when file open directly in browser | 01 Oct 2007 12:44 GMT | 1 |
We are having one Excel file which contain macros. The user has two options to download this report output file, they can download and save to harddisk OR open report into browser directly by using Open command. On the sheet, we gave sort order functionality. The sort
|
| character spacing Excel 2003 | 01 Oct 2007 12:11 GMT | 3 |
How does one get all numbers in a column to have set spacing instead of proportional spacing? I remember setting proportional or fixed back in the days of DOS, and haven't used it since and I'm unable to find it in Microsofts online help for either Excel or Word (2003).
|