General

Copying from one worksheet to multiple worksheets
How do you copy from one cell in a worksheet to a similar cell in 25 other worksheets in the workbook/file? ... 13 Jan 2010 13:14

FORMAT FOR FEET AN DINCHES
Is there any way to easily format for feet and inche? ... 13 Jan 2010 14:22

formulas with <>
Hi - I am using a spreadsheet with formulas setup by someone else and the formula is reading: =if (AA110<>"",AA110,if (g110<10,G110,AA110*10)) My interpretation is that it should read: =if(AA110="",AA110 etc. (ie. if AA110 has nothing in it, make the cell blank) Or does the <> mean something else? There is ... 13 Jan 2010 13:14

Tracking history of Office files chronologically
Hey thanks, I have just by chance discovered it again under "Journal Options" and ticked off the appropriate office applications to track. Much appreciated anyhow! "Jarek Kujawa" wrote: do you mean sth. like: Go->Diary in Outlook 2003? On 17 Lis, 09:08, VinceY <Vin...(a)discussions.microsoft.c... 13 Jan 2010 12:06

cmd MAX shall help
Hi, if there are numbers in the cells, you can try following formula in M22: =MAX(F26;G34) If there is mixed content (text or numbers), following formula will help (as proposed similar shortly): =IF(F26>G34;F26;G34) Regards, Karsten CrazyConfused wrote: IF Formula 13-Jan-10 I am trying to compare t... 13 Jan 2010 12:06

Are macros inherently slow in Excel 2007
I just upgraded to office 2007. All the macros that I have been running in Excel 2003 seem to be much slower now. Even the ones that involve simple calculations and copy and paste commands. I have been hearing that there are fixes for tht but where? I have the office2007 SP2 installed but it didn't change things... 13 Jan 2010 15:29

How to Select a % of the spreadsheet
I have Excel 2000 and I need to select 60% of a spreadsheet with 4000 lines of data. What is the best way to do this? I will then choose Insert-Name-Define to save this selected 60% of the spreadsheet. Thanks ... 13 Jan 2010 10:58

View Hyperlink in another cell
I have a spreadsheet that contains a hyperlink and would like to be able to copy the hyperlink to another cell so I can pull all into access to link to other tables for mapping screens. When I look at the cell it shows: AAD: AWDU11 - Award Amount Definition When I hover the mouse over the cell it shows the hyp... 13 Jan 2010 12:06

Formatting making file size huge
I have a file with about 180k of data in I want to format the columns (about 20 columns) with background colour and borders, all the way to the bottom, but it changes the file size from 180k to 180M - is this normal? Is there a way I can have the formatting without the file-bloat? Thanks M ... 13 Jan 2010 12:06

Please Clarify
I have been trying to understand this principle but need you to clarify your instructions. Example: C1 2010 (Year) To Avg. 35 (Title) C2 36 Formula (Need 34) C3 32 Formula (Need 37) C4 34 Formula (Need 38) The formula needs to adjust calculating all the weeks p... 13 Jan 2010 09:50