This is the only example on you tube of doing this task that was shown and explained easy, thank you SO much this was driving me insane.

@Pinoyitsolution

3 жыл бұрын

I figured it was so, that's why I shared it.

Thank you i love you

Nice Trick Thanks

Thank you very much, really helpful

thanks

Very smart way to make it work, thanks!

@Pinoyitsolution

3 жыл бұрын

Thanks

Thank you so much, this is literally the best and easiest.

not even Microsoft videos has this trick hahahah thank you! very much appreciated!

Thanks so much

@Pinoyitsolution

3 жыл бұрын

No problem

thanks, exactly what I was looking for

Thank you

Thank you! The only trick that worked!

@Pinoyitsolution

4 жыл бұрын

You are welcome.

Thank you, great trick!

@Pinoyitsolution

3 жыл бұрын

Glad it was helpful!

Genius

@Pinoyitsolution

3 жыл бұрын

Thanks

Thank you!

@Pinoyitsolution

5 жыл бұрын

Glad to be of help to you.

Nice work. I find it so bizarre that Excel only allows for the top row to freeze! Thanks for your trick!

Excellent Work.

@Pinoyitsolution

3 жыл бұрын

Thanks.

Great thanks for amazing trick.

@Pinoyitsolution

4 жыл бұрын

You're welcome.

tnx

FANTASTIC ! IT IS RESOLVED.

@Pinoyitsolution

6 жыл бұрын

@usman faisal THAT'S GREAT NEWS

@Pinoyitsolution

6 жыл бұрын

PLEASE DON'T FORGET TO SUB. THANKS!

great thanks!

@Pinoyitsolution

4 жыл бұрын

You're welcome.

Thank you :)

@Pinoyitsolution

3 жыл бұрын

You're welcome!

Yes.. it's working.. thanks

@Pinoyitsolution

6 жыл бұрын

@Anvar sadath. You're most welcome. Please don't forget to sub! Thanks!

ty

Nice work but how excel does not allow to do it in simpler way.. Very lacking

@Pinoyitsolution

3 жыл бұрын

Thanks. I agree.

Great "trick". Just stupid that Excel does not allow you to specify how many rows to freeze in the first place.

@Pinoyitsolution

3 жыл бұрын

Thanks. Maybe no body bothered to ask for it. :)

Is there any way to freeze the top 3 rows in addition to freezing the side two columns? Thank you.

@Pinoyitsolution

5 жыл бұрын

Hi, there is. I put up a private video for you here, kzread.info/dash/bejne/kZekuKulmNi0eZc.html.

@julienpounders4899

5 жыл бұрын

@@Pinoyitsolution hey thanks for the response! but there is an issue with that video "This video is not available"

@Pinoyitsolution

5 жыл бұрын

@@julienpounders4899 my apologies. Please try again.

😍😍❤️❤️❤️

@Pinoyitsolution

3 жыл бұрын

👌😊👍

Is there a way to just freeze row 3 only in your scenario?

@Pinoyitsolution

2 жыл бұрын

No. I think it's not possible.

But after that when you freeze the first column, the top rows unfreeze

I had to select the whole sheet and THEN unhide.

@Humanist1199

4 жыл бұрын

Thanks Ken with your comment i unhide my row else it was not showing :)

Thanks @Pinoyitsolution