Search results

How do I select data based on a number range in a column. As shown in the uploaded file, I want people to type the time range(red color) in the 2 cells shaded blue. And excel will calculate the averages for the variables shown in green (Actual RMR, R, Vo2 and so forth) for example, the Actual...

How do I Freeze the top row in a share point excel document? Thank you! Anoop

I made a report in word that enables me to pull values from excel to the word doc. I used paste -special-unformatted link. I have like 10 tabs in excel. And depending on the age, the data is stored on different tabs ( 45-50, 50-55). How do I get the same cell data into the linked word doc, but...

I have a 5-6 tables in one worksheet. Is there anyway to make these drops downs? So that when I click the subheading the corresponding table just drops down. I know you can do with grouping, but was looking at much more user friendly way where you just click the sub heading.

Hello, I have a lot of tables that I have copied to excel. I have used another formuale to reference these values in the tables. Does anyone know how to have the actual values show up in my new formulae than the cell references (like B6 or C8)? I just want to save time by not retyping each...

How do you highlight the coloumn when the date is Today in the top date row. This is for a daily task list. This way I can see what day is today. I can highlight the cell when the date is today with conditional formatting. But cannot get the column of the cell to highlight.