First  |  Prev |  Next  |  Last
Pages: 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148
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
First  |  Prev |  Next  |  Last
Pages: 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148