While the new Office 2007 ribbon is neat / cute / whatever, this particular old dog is familiar with the traditional Word and Excel menus. How can I get those menus back? Is ther …

I've come across the concept of Pivot Tables, but don't really understand them. Can anyone enlighten me?

I use Pivot Tables a lot and I find myself clicking through the wizard every time i need to perform a quick pivot. Is there a shortcut to quickly create a pivot of the selected ra …

I have a column containing the full name of a person, such as John Smith. I need to split this single column into two individual columns with FirstName in one and LastName in the …

I need to send copies of calculated data to other departments on a regular basis, but I do not want them to be able to see (or change) the formulas I use to arrive at the calculate …

I have Contracts that are of varying size but I need them to be 14 characters. This is how I do it. A1=A1234567 A2=A123456789 B1=MID('00000000000000',1,14-LEN(A1)) & A1 --> …

I have an Excel sheet which comprises 1000+ records where each address occupies a single cell e.g. 21 Select Avenue, London, SW3 5PX 31 Shaftsbury Drive, Stanley Park Estate, Liver …

I have a spreadsheet with over 50 charts across multiple worksheets. Is there a quick way to manage the font sizes/colors across all of the charts without having to click on each …

I am trying to enter a column of product codes in Excel, but every code that begins with a zero is automatically converted to the number without a leading zero. For example, if I …

Here in our office we have a difficult time deciding where to go to lunch each day. I think what we really need is a "slot-machine" like random lunch generator, that will pick a r …

Is there a way to change the color of the grid lines in an Excel worksheet?

I am trying to insert a formula in column B next to a column of values in column A. Column A is around 1000 rows long, and i don't want to type the formula 1000 times. Is there a …

Excel Question: Say I'm in sheet1 working on a formula and want to include a cell from a sheet2 in that formula.... talk to me mister Miyagi

This should be a fairly simple request, but I am looking for a formula that will return the largest prime number from a column of numbers (both prime and non-prime). I am familiar …

Hi I frequently create graphs in excel 2007 for use in power point 2007 presentations. I first manipulate the chart in excel to get what I want and then cut and paste this into my …