Somehow, I've changed a setting in Excel so that when I enter a number (say, 5) into any cell on a blank worksheet (thus, the cell is formatted as general) and...

Is there a way to allow other users to make changes to a worksheet while preventing them from deleting it?

I've tried repairing, uninstalling & reinstalling excel but I can no longer edit comments in one of my Excel spreadsheets. Each time I hover over a cell with a...

I developed a new excel worksheet for real estate users and want to sell it online. How do I compile the file for distribution..? Any help would be greatly...

Dave, it appears that when I reply to your posts that my email gets bumped and I get that mail deilivery subsytem message. Here were what came when I entered...

Hi, I am typing a spreadsheet- simple basic one- I have the names of employees with their wages--- I have typed a persons name Marc- but when I hit enter it...

Can someone help an old dummy please? How can I set all the lines(rows) and or columns to the same height for rows and width for columns. I have been dragging...

Hi, I have a data validation formula that works fine when figures in multiples 84 are entered into the cell and if not gives an error. But I need to rewrite it...

hi i have created a validation list with more then 500 name, but when i try to find a particual name i have to go through all of them . is it possblie to write...

This is my first post here...I hope that i've chosen the right category.... My problem is similiar to other people's when it comes to consolidating ranges with...

I am trying to make a macro where it is connected to a listbox. I have a problem of if a blank cell of the listbox is hit by accident it comes up with the...

What is the formula for period to period percentage change at...

I have the following data in a worksheet Important note: it is in pairs, that is columns A,B is pair 1, C,D is pair 2, E,F is pair 3. i want to sort it WITHIN...

I have several columns with 7pmM Jack or simialr enteries. How do I get a sum of all Jack names in each column-- probably need an If statement -which one, What...

This is showing how much of a novice I am, but I'm learning. I need to change this formula so that it not only shows the message if multiples of 84 is not...

I wish to delete 3 characters in each cell of a row. A macro qould be much faster but how i do it?

I am trying to format numbers as a four digit number. If I format the cell with numbers, no decimal places, no separator, the last two numbers don't...

I have a rota worksheet that contains columns for start & finish times each weekday and a final column that adds the total hours worked. I would like to be...

I am re-posting this one 'cause I couln't make the procedure provide for it's solution work. I In a worksheet I am createing there is colum titled "Date...

Hi, The fraction is 1/X +1. The x is the number that appears in column A. The problem I have is the number will be different for each row, so I can't...