General

How do I e-mail 1 page of a multi page workbook
I have a multi page workbook and want to e-mail my managers their sheet only. How do I do this? ... 25 Mar 2010 09:09

protection
Why do all of a sudden I get a message of "this book was made exclusive by burt 3/24/10 10:26" when I try to close it, share it, highlight changes etc? I have shared and protected this book from the time I created it, but lately I get this message. ... 25 Mar 2010 09:09

borders don't appear in print preview?
Hi, I'm using Excel 2003 and I have a spreadsheet which I have set up so that 'gridlines', 'black and white' and 'draft' are unchecked. The cells where information is to be entered have black borders. When I select print preview, most of the cells are fine but there are 5 rows where the borders aren't showi... 26 Mar 2010 05:48

Validation dropdown list is not coming visible
Hi, I'm using XP and 2003. I have a problem that I have once found resolution, but now it came again and cannot remember what needs to be done. Here is the problem: There is a column where Validation is specified in right manner with error message in case of error. When selecting the cell - dropdown list is not... 25 Mar 2010 08:00

Populate cell with a value if another cell has a certain value
All, good morning. i have a issue, i need to populate cell E4 with a value CX/025966 when cell F4 has a text Bond Street. Is there a simple way of doin this? ... 25 Mar 2010 10:19

about screenupdating
Hello, I have a long code which is a kind of poker simulation that gives you simple random poker hand and calculates the odds.If I disable screenupdate some of the values are gone missing.It does not count properly.However, if I activate screenupdate, no values are gone missing. I am talking about 1 million live g... 25 Mar 2010 03:18

Want to format data
I have data in Excel that is in 2 columns as below Coloum 1 Coloum2 000199 CAON00000013 000200 CAON00000011 I wanted to create my SQL script from these columns as below Update apdoc set user1 = 'Coloum2 value' where refnbr = 'Colum1 value' As I have thousands of lines I have tried concatenate et... 25 Mar 2010 08:00

Ctrl+E to center
MS Word and PowerPoint has had the "Ctrl+E to center" function for years, and I am really hoping this will be extended to MS Excel soon. Today, typing the Ctrl+E in Excel produces no response at all, so I wonder why this feature hasn't been activated years ago. Indeed, Open Office Calc uses Ctrl+E to centre con... 25 Mar 2010 02:10

look up question
Hi , I have 2 columns - column A containes dates , coumn B contains activieties ( meetings , phone calls , emails ) .. I'd like to have a formula that returns the last date a meeting occured Thanks G ... 25 Mar 2010 01:02

Changing position of shapes in chart
How do I change to position of shapes and add effects to the organization chart? thanks, Matt ... 25 Mar 2010 09:09