View original (French)

My page is split in two on Excel???

Solved
constance BOISSIER -  
 Constance boissier -
Hello,

My page is cut in two. Normally when I switch to page break mode I drag the mouse so that my two pages become one, but now I can't do that!
Can you help me?

Thank you.

Configuration: Windows / Chrome 53.0.2785.116

3 réponses

Réponse 1 / 3
PHILOU10120 Posted messages 6463 Registration date   Status Contributeur Last intervention   833
 
Hello Constance Boissier

Do you have 2 vertical scroll bars?
If so, hover the mouse over the separator bar and then move it up towards the top of the sheet

--
Practice makes perfect. - It's at the foot of the wall that you can see the mason - one always learns from their mistakes
2
Réponse 2 / 3
Raymond PENTIER Posted messages 58550 Registration date   Status Contributeur Last intervention   17 475
 
Yes.
But where is this file?

--
Retirement is nice! Especially in the Caribbean... :-)
Raymond (INSA, AFPA, CF/R)
0
Constance boissier
 
Well, in a folder on my desktop. When I open it, I no longer have access to the orientation or the margins??
0
Raymond PENTIER Posted messages 58550 Registration date   Status Contributeur Last intervention   17 475 > Constance boissier
 
I think we didn't understand each other... You need to send us your file! 
 1) Go to https://www.cjoint.com/ 
 2) Click on [Browse] to select your file (max 15 MB)
 3) Scroll down to click on the blue button [Create Cjoint link] 
 4) After a few seconds, the second page will show up, with the link in bold; right-click on it and choose "Copy link"
 5) Go back to your discussion on CCM, and in your reply message 
 paste it.
=>See the sheet https://www.commentcamarche.net/faq/29493-utiliser-cjoint-pour-heberger-des-fichiers
-1
Constance boissier
 
It fixed itself. I think it was a bug in my Excel.
I'm sorry for bothering you, but thank you very much!
Next time at least I know how to ask my question, thanks!
0
Réponse 3 / 3
Gyrus Posted messages 3360 Status Membre 526
 
Hello,

To allow the movement of page breaks to another location in a spreadsheet, the drag-and-drop cell feature must be enabled.

In Excel Options > Advanced Options, under Editing Options, ensure that the Cell drag-and-drop option is checked.

See you!
0