I have a large spread sheet that I like to sort alot of different ways using the sort buttons on the tool bar. I know how to use the Data - Sort function and...

Greetings, I have a list that has over 3800 names in it. I am trying to use Auto Filter to go though the list an remove duplicate entries (The list started...

Hi all When I enter 6.30 in a cell to indicate 6.30am the display has changed to 7.12am? I have gone to the format time menu and keep changing it to the...

Everytime I enter a date in a cell, Excel thinks it is 2001. How to I get the default date to think it is 2005?

Hello - I am using Excel 2003 and when I drag data to fill in a series etc., there is an automatic box that pops up (auto fill) when I am finished dragging. ...

The intention of my macro is to put all the wb's sheet names into a named range as per the code below. Then, use the named range as the list in a "data...

Everytime I open an excel document it states that the document should be opened as read only unless you need to save changes to it. Then it ask if I want to...

Hello everyone, someone has messed up with my excel sheet, when I want to print on an A4 size paper A4 size is divided into 5 parts by dashed line breaks...

I sent a copy of an Excel spreadsheet to my supervisor using "Send To Mail Recipient (as Attachment)." Now I have this annoying toolbar with the "To..."...

Okay...I have a ridiculous question...what are the auditing features in Microsoft Excel 2003. I am looking over a training course survey and "auditing...

I'm using excel for years but today I was shocked. almost died. While summarizing a column of numbers, the summary was incorrect. I suspected that few cells...

I'm looking for an easier way to conduct a gap analysis between two lists in Excel 2007. My company has a tool that sends out documents to clients based on...

I have a column of cells which all contain the same formula: eg. =C20-(C20/1.175) As this is a currency cell, even if there is calculation can be done on...

I have two spreadsheets. the first has a list of account numbers, for example 10 20 30 The second has a list of acount numbers and an amount, for example

I want to create a command button in a worksheet that will hide/unhide each alternate column from J - AG as well as row 4. Being new to VBA I've no idea how...

I often find that with a cell set to "wrap text" the cell opens up an additional line before a charater of inserted text is actually placed on (wrapped to) the...

I use Excel 2000. I pulled a number with 5 decimal places into a contract, reducing it to 3 decimal places. I then use that number in a formula to figure a...

Hi, I have three cells. The first is loan amount, one is % and one is Dollars. I'd like to be able to enter the second (i.e. "3%") and have it multiply...

Good Morning Group, I am a Commercial Real Estate Broker and I have several databases with building tenant and owner information that I need to make mailing...

After some help with Conditional Formatting. As an example I have the following data in cells B1 & B2; Cell B1 "Project 1 - Testing" Cell B2 "Project 2 - Not...