General
in [Excel]
|
DROP DOWN LIST WHEN SPREAD SHEET OPENS Hi I have a spreadsheet that when you open it a drop down list shows a choice of names to choose from that each relate to an individual sheet. How do I access this drop down list to edit the names? Thanks ... 13 May 2010 21:36
Hyperlink to folder on Save Hi I'm losing the link to my folder when I save my worksheet having set it up a hyperlink. I've tried switiching off 'update links on Save' in the Web Options which seems to work OK but when anyone else opens the file form another network PC, the link is lost again when they save the document. Is there anywa... 12 May 2010 08:03
CONDITIONAL FORMATTING- EXCEL If COLUMN Z is more than 36... then i want it to highlight the entire row. I have 70 rows, all with different numbers in that are already all working, however, if the number gets above 36 in the Z COLUMN, i want it to highligh the ENTIRE row. How do I get it to do this please guys? ... 12 May 2010 09:09
EXCEL (IF) COLUMN E has a range from 1-5, COLUMN F I want to show a number depending on COLUMN E. E.g. if e1=1 then f1=12, if e2=4 then f1=57. I want the F COLUMN to depend on the E COLUMN. But I am not sure how to do this. The IF function doesnt work because I want there to be 5 conditions. Basically.... 1= one number... 12 May 2010 09:09
excel versions Hi I am currently running excel 2003 version 11.8220.8221, i have some issues and know that version 11.8320.8221 resolves this problem, How do i upgrade to the later version? Thanks rw ... 13 May 2010 06:07
want excel 2007 to stop calculating processors Hi There I am running excel 2007. I have a sheet with 167000 lines in it, and have to use vlookup to match fields from other files. Once i made a change, the program start with "Calculating: (Processor) which is taking up to an hour to complete. How can i remove that calculating Regards Johann Terblanche... 12 May 2010 05:54
view cell fill colour on screen I have filled a cell with colour but cannot see it on the screen. However I can see it in print preview. The same goes for changing the colours of the words I type ... 12 May 2010 15:53
Link Pivot Tables on one filter I have several pivot tables all on one worksheet and on the same tab. I have successfully used the below vba code to get the first pivot table to update based on a non-pivot table cell value. How do I apply the same code to all of the other pivot tables on the tab? I am brand new to vba, so I'm not sure how to do a... 12 May 2010 04:49
Number of the day of the year I need a formula that will look at a date and tell me what number day it is in that year. eg 31/1/2007 would show as 31. 1/3/2008 is 61. It is sort of like a julian date but without the year part of the number. Thanks ... 12 May 2010 04:49 |