Freeze Multiple Rows

[Kekareno]

Hello all

I need your help guys,

I was working on a project and using an excel sheet but i stopped in the point...((freezing Multiple Rows O.o ))!!! i remember i have seen one before and i asked all people around me and they couldn't help >.< !!!

Please could anyone help me with this issue and i will give a kiss ( if she is a girl :p ) or shake ( if he is a guy ^_^ )

Best Regards to all,

[oeldere]

excel 2003 => view => freeze panes.

[Kekareno]

excel 2003 => view => freeze panes.

Oeldere Thank u so much for ur fast reply..but this one doesn't help me with the Multiple rows...it freezes only 1 Row

[oeldere]

No it does not, try it again.

You can also select multiply row (on the top of your sheet).

[Kekareno]

No it does not, try it again.

You can also select multiply row (on the top of your sheet).

Oeldere i'm sorry it doesn't work as i said...the only thing i can do is freezing only ONE ROW OR ONE COLUMN OR BOTH ( ROW&COLUMN) and what i want to do is freezing 2 or 3 or 6 Rows.

[oeldere]

6 rows are frozen (see the attached file).

[Kekareno]

Please take a look at the attached file i tried my best to explain what i want i feel somehow you will block me after that lool

[oeldere]

Maybe like this?

See the attached file.

[newdoverman]

It is difficult to know exactly what you are after here. In this example, Freeze Panes has been applied at row 62 just under the last formatted area. In addition, using DATA VALIDATION I applied rules that eliminate the ability to edit the contents of the cells in A1, A14, A26, A38, and A50. The contents however can be deleted.

If you didn't have data grouped, you could protect the worksheet and prevent the deletion of rows and columns. Protect worksheets however don't allow access to grouped data when the group is collapsed.

[Kekareno]

Thank you guys i REALLY Appreciate ur help all ...i know the problem i can't explain what EXACTLY i want... like what Newdoverman said...i need to freeze rows are not underneath each other ( sepereated ones ) !! and i know there is a way cuz i have seen one before

[oeldere]

The only way i can think of (if I understand your right) is a solution with VBA and hide rows under a partilar condition.