Excel Issue

[justdream]

Friends,

how to create this Excel issue:
In the attached pic., you could see that the first row (coumn headers) are fixed whatever I page down.....so it helps me a lot to read the header and data to know which column ot belongs to

so now, how to create it?

[mayank_shah]

Dear Friend,

Just Select Cell - row = 2, Column = 1

then go to windows -> Freeze pens

or Alt + W + F

Mayank Shah

[plannerguy]

selsct the option "window" right to "Data", in that there is option "freeze pane"select that.

it will freeze from the row which u have selected .so that u could keep heading constant, and below ares scrolable


regards
Plannerguy

[mbouchamekh]

select the first row, select data from menu and "filter".

very easy
br

[justdream]

Thanks all, do you know how to get unlimited version of ASAP tool

[TEMS]

Friends,

how to create this Excel issue:
In the attached pic., you could see that the first row (coumn headers) are fixed whatever I page down.....so it helps me a lot to read the header and data to know which column ot belongs to

so now, how to create it?

thank you very much

[justdream]

Friends, another issue please

I'm trying to insert new line in me excel which contains cells with conditional formatting but I receive this message:

how to solve this silly issue
Thanks
Hint: I'm using MS Excel 2007, and I think by 99% that the original Excel file was created by MS Excel 2003 :-( kindly don't tell me to go to MS Excel 2003

[justdream]

Million thanks to
Ctrl + 6


I'm so happy

[justdream]

Friends, I want to draw a chart representing the KPI of the network for the one month duration
but the problem is that I want to have one chart 'graph' while the first two weeks with different line color than the last two weeks as we have made important action in between

so, how to do that

[justdream]

Experts, another issue please

I want to calculate the average excluding the highest maximum and lowest minimum value

is there one excel function that can do that?