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 :confused:
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
:D

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 :confused:

[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?

[wnsworld]

Downl load Excel Function Dictionary from below link, and find ur sutable function..

http://www.finetopix.com/showthread.php?p=68687#post68687

[justdream]

Experts,
do you know how to combine two different chart types in one chart window

I have chart with numbers (total attempts) to be bar chart
and one with percentage (Percentage of the success) to be line chart

I want to draw both in just one chart

Your fast advice will be highly appreictaed :hug:

[paboya]

plz type at cell
=average(
"then select all cell that u want to calculate"
then ENTER

=average(XX;XX)

[justdream]

Mates,

I know how to draw a primary and secondary Y-axis on charts but how to draw Tertiary Y Axis on the same chart :confused:

do you know :hug:

[justdream]

experts, any help
I got tired from searching and reading about Tertiary Y Axis
up to now, no success

[justdream]

Friends,
I would like to compare two excel sheets to each other to know the difference in the database of my network from date to date
but It have to be smart as rows order in both excel files are not identicals

Please help :hug:

[paboya]

u can try this function
=exact(text1,text2)

It will compare the both txt
if they r same ===> TRUE
and if different ===> FALSE

[justdream]

no, I would like to do it for big amount of data
and it has to be smart to search for the text2 by itself (like vlookup)

[paboya]

can u attach the sample or save in 4shared.com
i will do the best that i can...

Or if u interest u can try read this book

[justdream]

Freinds, are you expert in Pivot chart?
I would like to know auto-way to drag multiple items to pivot window and let them be Sum instead of count

Do you know, how? it will save my day :hug:

[plannerguy]

Seems you should go for a mcaro....


regards
Plannerguy

[justdream]

is it the only available solutions?
Thanks anyway,,

[justdream]

Dear,
Please teach me how to do the following two points:

1- having red label like that one in the below pic when I put my cursor upon it, shows me some helpful comments

2- creating drop-down list for all cells in the column and fill it with different options like that one in the below pic.

[student21]

dude,

u got serious issues with Excel...
get a (e)book and read/exercise...
it hasn't anything to do with "Network Planning" or "Mapping & Tools"...
please change location of the post


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?

[justdream]

I know but we need these skills in our daily tasks, believe me

[justdream]

ok experts, do you know how to color each specific number of rows with different colors like coloring each 5 rows with different color ,etc (not for all the sheet just for one column) and only in case of data exist 'blank cells to be ignored' and without taking column header in consideration !!

If you know, please share I've spent 2 days but didn't find what I need...


I'm searching for auto way to do that whatever I've 8 rows or 400 may be Macro with loop..