ive set up a spreadsheet to calculate my income per week. I now would like to make my tax and national insurance boxes to be calculated automatically. meaning...

I am trying to set up a spreadsheet with driving test results including one column to say pass one to say fail and calculate the percentage of each on a...

Example given of a variable length (library) list, but which may actually be 1000 long. How can I transpose the data into a Table in either Excel or...

How do i Attach th text box on the right hand side corner of the sheet and hide it their and when i take mouse their it comes out.

HI IF I HAVE A FORMULA IN A1 CELL OF SHEET1 I.E "=SUM(SHEET2!B3:B40)", HOW CAN I GO TO THAT RANGE WITH OUT USING SHEET TAB WITH THE MOUSE OR alt+page...

Can the left - center - right sections be removed to make just one area right across the page ? sidcliffe

is there any options or macros avialable for creating multiple y axis in the xy chart. my application is that i want plot a graph for various values at a time...

How would I insert in my input box of data validation the values of cells D6 and F4 basically if the user clicks on a cell F6 I want it to reference f4 and...

emailing files from excel, the files will not go until I open up MS Outlook. Only then will the file go. I have waited for 30 minutes and more and the file...

Hi, I have a column of numbers and I want to substract a certain value from every cell in that column and create a new column with new set of numbers. How do...

I would like to be able to enter a number in the first cell and have it populate a table - 6 columns by 30 rows - incrementing each cell by one. For ex, if I...

Mike, Caution: the techinque I'm going to share can have unintended consequences. Let me explain. If you hold the Ctrl key down and select the tabs of the...

Hi, can you tell me how to get statistics on five different colums of numbers: specifically, how to get means and st. errors of every row in five...

I have made several extensive macros in Excel to speed up my work but after a couple of days they are no longer avaiable. How can I save these for more than a...

BlankAnd as a second thought. In my A column I need to set it out like this HH:MM (AM/PM) with *no* date, just the time. How could i achieve this? Sorry for my...

This may have been covered before - and apologies if so - but I can't change the default row height from 12.75 to 15.00 each time I open excel 2003. I have...

looking for a form to track individual credit card purchases from the statement and in various categories.

I have a spreadsheet that lists all customer orders for the year - each order is a row. I need to count the number of orders per customer per month. I'm...

Hi everyone, ('scuse my English please I'm still learning) I'm not too good at Excel and I'm working on our mock assignment at the moment, what I wanted to...

With my issue of Excell 2007 I cannot make the unhide column work. I can hide columns but cannot reverse and unhide them,either by going to thr formate...