General

Creating a HyperLink
Greetings ! I put my name in Call A8 = "Robin Clay" In B8 I put the formula "=LEFT(A8,FIND(" ",A8)-1) & "." & TRIM(RIGHT(A8,LEN(A8)-FIND(" ",A8)+1)) &"@xxxxxx.co.uk" And Voila ! There is my e-mail address ! But how can I make that into a HyperLink, so that when clicked on it will generate an e-mail a... 7 Jul 2008 08:23

How do I use conditional formatting for an entire column?
Hi, I have the same problem. When you paste you cannot decide with $ if change automatic or not the row number. Nothing to do with excel 2007. Some one has resolved the problem? Thanks "spai461" wrote: I'm new to Excel 2007. Trying to apply conditional formatting based on a formula to a whole column. ... 7 Jul 2008 07:22

Mouse movement in EXCEL
I have a new computer with Vista Business and Office 2007, and a basic optical mouse. The behaviour of the pointer/cursor in EXCEL is driving me mad - I have to point slightly above, and sometimes to the side, of where I want to be - e.g. to alter the height or a row, I need to point halfway up the row above bef... 7 Jul 2008 07:22

Freeze Panes in 2007
Hi I am using Excel 2007 and cannot find where Freeze Panes has gone. Can anyone help? Many thanks -- Kind regards Ann Shaw ... 7 Jul 2008 12:30

conditional formatting to group rows with repeating entries
I've got a big list of records which I would like to group into visible sections by colour according to a field, i.e. all rows with the same value in that field show in yellow, the next "group" showing without a background colour, then the next group in yellow again and so on- basically, a variation on the alte... 7 Jul 2008 09:24

Input selection choices
Hi I want to invite a user to choose one of three options i.e., 1. Make an Interest Calculation; 2. Make a Payment; or 3. Add a Debit I was rather hoping that a message box-like approach could be taken but it seems there is no easy way to change the Yes/No/Cancel buttons in such a three-choice box. Once a... 7 Jul 2008 23:48

Excel no longer marks selected cells by highlighting them in blue
Excel 2007 usually marks selected cells or ranges by highlighting them in a shade of blue, but somehow this has been turnoff (automatically?). Anyway to make it show the selected cells again? ... 7 Jul 2008 08:23

Counting Dates
I need to count days between 2 dates in 2 cells. Like B:2-B:1. In case B2 is empty i need that to be counted as on today-system date. Can you help on that? ... 7 Jul 2008 06:20

Data exported from Lotus approach to excel how do I show it in a u
friendly manner. Basically my problem is that I have a Lotus Approach database from which data has been extracted in an Excel format, I now need to be able to interogate this data displaying a one record to the screen perhaps using a form connected to the database? Help. -- martin h ... 7 Jul 2008 05:19

namebox
hi all dears How can i delete or edit names in the namebox. thanks ... 7 Jul 2008 06:20