I have a list of instruments that I'm trying to sort in alphabetical order from left to right. The list is part of a larger database, where each row...

Can anyone please help me with some code for a macro that will achieve the following in an Excel spreadsheet: 1. Go to 'Clients' worksheet if currently on...

Hello, I have a table. I need to assign a name to each of the cells but it is extremely tedious even using the name manager. (I also have to do it multiple...

Whenever I open a workbook in Excel 2007, the page breaks on the individual worksheets do not display. I can set them to display by going to Excel...

I imported a report into excel, in the report the effective dates are yearmonthday (20090815). I would like to change these to a normal date format. I also...

I have a small spread sheet set up to keep track of a grass cutting contract. We have our area divided into sections A-G. Each section has a different dollar...

I have received an old spreadsheet built awhile ago. There is a hidden formula and I can't figure out how it gets there. Example. if I punch a number in F8...

I am new to Excel 2007 and I can find the Data Analysis - Sampling tool. I know where and how to use it in Excel 2003, but at a loss in 2007. Can anyone...

When creating a pivot table, the field list does not appear. I have tried clicking the icon but still nothing happens.

I use Excel 2007 at work and have Excel 2008 (for the Mac) at home. My plan was to be able to move Excel files back and forth between these two environments...

Wasnt sure how to word the question but here's the issue. I'm using Excel 2007. I have a pivottable (PT) with two rows in compact form (Employee Name,...

Hi- In a cell consist of this number '24110100, I did try copy and paste special trying to get rid of this apostrophe " ' " in front of number and I'm not...

Hi, I have a sheet containing a column with complete product names or numbers, like for instance: 'Dogs plastic small 5 packages' or 'BKL 55267'. In another...

I have a list of customers on Excel. I want to update this file with any new customers we add in our accounting system. I can export the data into Excel but...

Is there a method to add custom number formats as icons on the ribbon in Excel 2007? I need to create a ribbon choice for this custom number format:...

I lost the settings of my F-key shortcuts in Excel 2007 - For example, now my: F8 is "save this worksheet." - Used to be "anchor this cell to make a...

Does anyone know how to automatically enter the last save date on Excel 2007 without creating a macro?

I input a lot of data is there a program I can use that automatically alphabetize the data or arrange in sequential order.

I have a list of mobile numbers currently in 077... format and need to convert to international i.e. +44 Is there a formula i can use to do this rather than...

Hi, I would like to copy a whole column from one sheet to another. When in the source sheet new data will be entered, then automatically this new data (new...