Freeze panes in a spreadsheet Solved

Question

In a spreadsheet, freezing panes allows you to do what?  I'm counting on you  Thank you in advance

bradakash · Accepted Answer

Fixing the panes is useful, for example, when you have many rows and columns and you are navigating through them. This allows you to see what each row or column corresponds to.

jacky · Answer

Hello, can someone please tell me how to do it?

Furtif · Answer

Simple, you go to "Window" and click -- *** @+ / Sneaky *** *** I'm not here, you've never seen me, in fact, I don't even have a PC! ***

Vaucluse · Answer

Good evening Jacky
2 options in Excel:
Taskbar / Window /
1st Option Split
The sheet is divided above and to the left of the selected cell, and the 4 panes are independently movable vertically and horizontally according to the displayed cursors
2nd option: freeze panes, the setup is the same, but the left and top panes remain fixed
BCRDLMNT
--

Science without conscience is but the ruin of the soul

Vaucluse · Answer

Hello Eric, have a good Sunday if you're there:
Sorry about this morning, but what is the difference between what you say and, I quote myself:
"The sheet is cut above and to the left of the selected cell"
And to freeze panes:
"the configuration is the same, but the left and top panes remain fixed"
You must have partied a bit last night? ;-)...! ;-)...!
BCRDLMNT

--
Science without conscience is but ruin of the soul.

eriiic · Answer

Hello Vaucluse,

Uh, well none actually :-)
I just skimmed through it and since it's the second option that I use, I only read that one without even noticing that you were referring to the first one. Sorry
Have a good weekend
Eric

papanimatthew · Answer

To freeze the first row and the first column, select cell B2 and in the Window (or View) menu click on 'Freeze Panes'.

JeanCharles · Answer

Hello,  I found this nice image tutorial explaining how to freeze panes in an Excel spreadsheet:  http://www.seeyar.fr/figer-volets-excel/  ++

Freeze panes in a spreadsheet

8 réponses

Canon mb5350 - cartridge replacement impossible

Texture issues in enshrouded

Football manager (club management game)

Select next line csh foreach

Win32 kamso then rootkit detection

Win32:spyware-gen [trj] detected by avast

Unknown video error on the freebox player

Make it or break it

How to open a cbr file

Please log in with manager privileges.