I’ve read a few posts on here and I think I’m pretty clear on determining which cells are locked for editing and which are unlocked for editing when a...

In 2003, my comments automatically identified me by either my name or ID#. We have upgraded to 2007 and now my comments don't do that. Is there an option...

How do you email a single worksheet out of a workbook with multiple sheets. I have not been able to figure this out. I am looking for an easy way rather than...

I know this has been beat to death but I just cant seem to figure it out. This is what I want to do =IF(94D897,,) I have tried the conditional formatting...

On Windows 7 Pro, Excel 2007 sp2: Repeatable on my machine: Enter something in cells A1:A3. Tab to D1. Enter something in D1, press Enter. Cell A2...

Hi, Say you have a range named "ABC" in Name Box. How do you delete it? Thanks, Mike

HI, I want to do a data import into a system I have a column of apostrophe(s) folowed my numbers i.e A 1 '2 2 '3 3 '5

If I enter the following date on today (Nov 30, 2009) 2/15 the date that is entered is 2/15/2009. Is there anyway to get Excel to default to entering...

Here's the scenario: A B C D 1 Blue Blue John 2 Yellow Black Mary 3 Black Yellow Carol 4 Yellow Terri 5 Black Joe 6 Blue Tracy

I was wondering if its possible/how to export an excel file to txt format and make sure that the first column in excel will start be from column 1-10 on a txt...

I have to enter a 14 digit licence number in a field this is a mix of numbers and leters. can some one please give me a formula that i can use in conditional...

I've got 4 digit text nums in A1 down In B1 down, I would like to list the corresponding number of permutations, eg: 7777 1 1777 4 0044 6 ...

I need a way where I can control a macro to control some scroll bar. I'll have about 10 - 15 scroll bar. There will be a main scroll bar. When I move the...

I have sage integrated reporting and excel installed, trying to get the Sage toolbar ont excel thanks

We have a master data file that about 50 other related spreadsheets have formula links to. Permission to this master file has now been restricted for many...

Probably I changed something but now each time I save a w/s it is saving as a Backup with a file extension of .xlk instead of .xlsm. Also from a remote...

I have the option selected to show both row and column grand totals. The column totals are showing but the row totals are not. I've tried unchecking and...

I can format shapes with RGB ActiveSheet.Shapes("Test").Fill.ForeColor.RGB = RGB(128, 128, 128) Is there a way to format a shape using themecolors in the...

In Excel2003, is there a way to change what magnification viewing amounts are in the dropdown box? For example, in my dropdown box , I show 200%, 100%, 75%,...