Hi, I have a spreadsheet, one sheet per month (ie November, December etc), which has this formula to calculate the daily average of sales (column P, and...

what i would like to do is be able to create a "gateway" leading to a new page, or new area of the current page when you click on a certain number. is there...

I am trying to convert the format of a column of cells from mm/dd/yyyy to yyyy. I used format cells, custom, and yyyy. The cell will change to the yyyy...

but, i'm an idiot.... column "P" is sum of Columns "C-M" (and formatted for % if that makes any difference). i want column "P" text to turn red is value is...

Hi I am new here and have been snooping around some of the threads, yet not quite found the simple formula I expect to solve my problem. The closest matches...

Say I have a value eg 23 in one cell i want to use LOOKUP in col A and if it falls in that range output col b. But how do I set this range in that cell.Please...

I can no longer use the arrow buttons to move around my excel worksheets (to change the active cell). When I click on the up or down arrows the sheet itself...

I have two similarly structured XLS file. One file "A" is much longer...perhaps 2000 rows long...when saved as a htm file it is around 500KB. I take...

how do i do it.

When tracking changes in excel shared workbooks, do all users see all changes? Such as when I enter the Who, When etc.

I would like to print the file path and default location in a footer on my file but the footer does not have the icon for this command how do i get this icon ?...

Along with numbers, I have to put text into several cells, mainly astericks and some letters, but I also want to sum these cells. How do i sum the numbers...

I'm looking for a free Excel SLM template that I can use to track the purchase and installation of software within an organization.

Hi All, i have a question about finding text. if you have a list of text in a row "A, B, C, D, E, F...etc" in sperate cells, with blank cells in between,...

I am not sure if this will make sense but I am trying to have worksheets to connect. I will have 52 worksheets with week 1 and so on. And then in my...

I exported some data from Acess to Excel but my DOB field has 'YYYYMMDD and I need it to show as an age. It's storing it as text b/c of the ' in front of...

I need the best form to use with Office 2007 to inventory my store. I have some tools, lots of parts...

This is driving me nuts but I am sure it's an easy setting, I cant seem to view the top of my spreadsheet to see the excel column names ie A B C Sorry for...

How do I remove text which preceeds a number from all data cells in a columb ? (change "A134.667 " to "134.667" ????)

when i try and select a single cell on a worksheet by clicking on that cell, excell highlights four cells at one time and i can't figure out how to get rid...