General

Autofit Row Height
I cannot seem to get the row height to autofit the contents. I have Excel 2007 and followed the instructions from the help menu.... In Microsoft Office Excel 2007, click the Home tab, click Format in the Cells group, and then click AutoFit Row Height. But it does not work and the row height reverts to its de... 1 Jun 2010 19:45

And in case I don't see you,good afternoon,good evening,and good n
Well thanks for all the help and assistance over the year(s) group (seriously), you saved my butt more then a few times. That said I finally got my data all transferred to MySql and will not be looking back. As some of you may know/remember I've had serious issues with Excel and find it to be highly flawed in... 1 Jun 2010 06:29

Mnthly auto ,shift schedule for multi employee
I am incharge of multi employee and need to schedule monthly shift duty as: Weekday (Monday to friday)-1730-2300 weekend ( saturday-sunday and public holiday) two shift 0830-1530 1st shift 1530-2300 2nd shift.This schedule I need to plan every month and must be equal to every employee. Please advise so that it f... 31 May 2010 11:58

how to turn off standard toolbar, formatting... Microsoft Excel 20
Hello, I would like to know how to turn off standard toolbar, formatting toolbar and the drawing toolbar? I am using Microsoft Excel 2007. Thanks in advance. ... 31 May 2010 14:11

Simply Array Formula?
I have a column of numbers. Looking for an array formula that will identify and highlite the "highest" three values. Does such an animal exist? ... 31 May 2010 14:11

Exporting the values to excel error
Hi All, I am trying to exporting the values as '10-02' and '10-03' from my developed application (developed in .Net). These values are stored as 02-Oct and 3-Oct respectively. Can anyone throw some light on this? Thanks, Karthik ... 31 May 2010 08:41

Input box to find date
Hi, As part of my macro, how can I make an input box (or whatever box) to pop up and ask the user to input a date - e.g. 25/06/2097? On clicking OK, it then goes and locate the date in the spreadsheet. Thanks for your help. Tom ... 31 May 2010 20:47

Final attempt save as binary question
This is about my fifth attempt since March, so far without eliciting a single reply (last attempt seems to have disappeared into the ether): Re Excel 2007 "Save as binary". Its supposed to save space and be quicker. So why isn't it the default method? Is there a downside? For example, will macros no longer wor... 1 Jun 2010 03:16

How to clear up useless content within worksheet?
When I copy and paste the whole worksheet for editing, and delete some useless content, but I find out the file size of worksheet is almost the same, I am delete half of useless content already, so the file size should be reduced, does anyone have any suggestions on how to clear up hidden useless content to red... 31 May 2010 00:06

Showing a cell reference in a popup
HI I'm trying to show a selected cell reference in a popup , rather than the cell content. This is my code : Dim lrow As Long With ActiveSheet lrow = Range("A" & Rows.Count).End(xlUp).Row End With Dim r1 As Range, r2 As Range Set r1 = Application.InputBox(prompt:="Enter address of... 30 May 2010 21:57