Does anyone know a shortcut for copying a formula with relative references as a formula with absolute references without having to put in all those little...

Hello! Is there a way to adjust the rows and columns on a workbook and have these changes apply to all workbooks? Thanks in advance! Stephanie

I am trying to write a spread sheet that will convert say 9-5 or 2-10, convert these to hours and add them up at the end of the row. Repeat the same for other...

I am after some assistance and hope someone can help. I know how to produce a drop-down list for entering data in a single cell, but I don't know how to apply...

Hi Maybe you deliver some additional info for us: How much employees? Payment shedule (weekly, monthly, ...)? Is payrate fixed for payment period, or can be...

I continue to receive the error message "To many different cell formats". This will not allow me to change the aligment, decimal points, borders, colors...

I've added a checkbox to a spreadsheet, using the Form toolbar. Two questions: 1) I'd like to make it bigger (the box and the font of the accompanying text). ...

I was trying to use COUNTIF to see if a value in a cell was also in a range of cells, but the range is non-contiguous. For good reason, the range is sorted in...

Does anyone know if there is a formula for displaying the current time? I know =TODAY() exists for displaying the date and also =NOW() for displaying both the...

I'm having problems retrieving stock quotes. I'm following the directions (typing symbol in cell in all caps, then clicking outside the cell), but only...

I have a spreadsheet with a number of columns (Product, Stage, Campaign, Batch, Page, Operation, Operator, Detail and Category). The spreadsheet is used to...

You can do a sum over sheets the same way you do a sum on=20 one sheet. On your New Sheet =3DJanuary!A2+February!A2... etc, where A2 is the cell with=20 the...

What does the function or symbol ^ mean?

Hello from Steved How would one go about writing a formula to search for 2.0 (Which is distance)I have over 1,000 places in my worksheet. below is one sample...

How do I set a formula to convert feet and inches to inches? Ex. 10'9.25" to 129.25"

I am getting a value by using a vlookup. what do I need to do to get the address of the cell that I found with vlookup? thanks

Hi All, Is there an option available in the analysis toolpak to do 2-Way ANOVA with replication (with unequal number of replicates in each group). I am using...

Even though we have Office set to Canadian $ currency - when we go to format cells - we get English pound sign currency. We can change the cells to $, but...

my excel sheet is a huge one and I have a column that has a disply of the hyperlink of all the cells I mean any cell linked with a path by hyperlink to the...

I'm trying to import info. from an Access table into an excell spreadsheet and when I try to finish the Query Wizard and error message comes up saying 'Syntax...