The A-Z, Z-A buttons are a very useful feature, that I use to sort columns within blocks of data without having to go through the data sort menu. I have a...

does anyone have a calculation for shares for heirs at law? for instance, mrs smith dies, mr smith dies. no will. four children, one deceased with three...

I am familiar with the Macro tool. Where I fall down is when I attempt to have it go to a cell that changes from sheet to sheet. As an example, I want it to...

When excel opens, it has a default font, no background color and black font color... Than you have to change the font, color or cell size, etc... is there a...

I did a save as in excel with a workbook. I highlighted the pages of the workbook and did save as. When I went back into the workbook to do my work, the...

I have created a form in Excel to use in court documents. The number of printed pages varies, depending on how much information is entered into the form. I...

Hi There, We have a problem where I work where we regularly use an Excel spreadsheet but sometimes someone will leave it open on their computer and no-one...

Hi, I have a row with no.'s , and I need to add a number to the whole row. Is there a formula to do it in one go, or do I need to change each cell in the...

I just performed the "Text to Columns" function in Excel and it didn't do exactly what I was hoping for. I have a spreadsheet with 1300 addresses in the...

Is there any way to have a drop-down menu within a cell so that I don't = have=20 to paste form buttons for each line? I'm building a spreadsheet to track...

I'm trying to delete data I don't need but I need to keep all Row data in sync while I sort any of the column data. What would I need to do to get this...

I have a simple function to subtotal a long column. The function is =SUBTOTAL(9,P7:P850) some of the cells in the column have values but don't add to...

I know that you can place the name of the file (&) into the header and footer of a worksheet. But is it possible to do the same into a cell? If so, how would...

Hi all, Mr. Newbie here, How does one format the cell so that when text is entered it does not flow across the worksheet or resize the cell? I would prefer to...

I want to protect a sertain range of titles and leave the remaining worksheet open for data entry. Everytime I try to do this protection it requires the entire...

I am having a wierdproblem with TextToColumns. I am splitting a column into two with delimeter as space. I have two excel files, one is the subset of the...

When I open Excel, any file I have worked on recently, whether word processing, Acrobat, jpg, whatever, opens as a spreadsheet full of something similar to...

A3 is the result of A1/21 I want to bracket the number in A4 In MSWorks I would type the statement ="" In excel I get in some cells I'd like it to read...

if the active cell has the first 7 characters = "example", I want it to return a value in another cell. ie, "example 7", "example fourty nine" and "example...

I am writing a code where if the first 7 characters in an active cell are, for example, "example" it will return a value. so... "example 7", "example fourty...