General

Excel columns are now numbered instead of lettered
For MS Excel 2007 versions go to: Excel Options > Formulas > Working with formulas > Uncheck R1C1 reference style. "Dave Peterson" wrote: Excel picks up this setting from the first workbook opened in that session. If you happen to open a workbook that was saved in R1C1 reference style as the first ... 21 Apr 2010 19:51

Disable Email as Attachment
Is it possible to disable the Send to function in Excel 2003 & 2007? Is it possible to prevent a workbook from being attached to an email - using Excel 2003/2007 & Outlook -- PaulaK ... 21 Apr 2010 18:48

Access denied when running Excel from DOS prompt with runas comman
Hi I executed the following command from the DOS prompt: runas /user:mypc.domain\dummyuser2 "C:\Documents and Settings\All Users\Start Menu\Programs\Microsoft Office\Excel.exe" I got the following prompt: Enter the password for mypc.domain\dummyuser2: After entering the password, I got the following mess... 22 Apr 2010 14:31

LAST, FIRST to First Last
I have data in LAST, FIRST and used this formula... =TRIM(MID(A2,FIND(",",A2)+1,99))&" "&LEFT(A2,FIND(",",A2)-1) Is there a way to change it from all caps to just capitalized names. Ex. currently - DOE, JOHN change to - John Doe ... 21 Apr 2010 22:57

Sort by column, not range
I'm trying to set up a macro that can be used from multiple workbooks with the same columns but different worksheet names. The number of rows will also vary. How can I reference the column rather than the range? I want it to sort by the Customer column which is the column header for column A. Below is my cu... 21 Apr 2010 22:57

Totaling cells from separate worksheets to master form
If I have 2 separate worksheets with individual cell values and want the total to show the sum of obth cells, how do I do it? Nelson ... 21 Apr 2010 20:53

How to total a column of cells without using Autosum
Help me remember please. I used to be able to quickly total a rance of cells by simply highlighting them. The total would then appear in the fx box. I can't seem to remember how do do this. I'm using Excell in Office 2003. Thanks ... 21 Apr 2010 18:48

Spreadsheet filename no longer appears in title bar
Spreadsheet filename no longer appears in the title bar of the spreadsheet window. What do I need to do to get the spreadsheet filename to appear? Thanks -- Jim R ... 21 Apr 2010 16:44

Change Header on Multiple Sheets without Changing Other Formatting
Hello I have a file with sheets that have the same header. Each tab has specific page setup formatting that I need to keep intact. I tried highlighting all tabs and changing the header via page setup but the other page setup formatting changed to the formatting of the first sheet. Is there a way to add ... 21 Apr 2010 20:53

how can I change MMDDYY to YYYYMMDD?
The formula =MID(C7,5,2) & LEFT(C7,2) & MID(C7,3,2) gets me to YYMMDD. I can't figure out how to get the year in full (YYYY). ... 21 Apr 2010 18:48