View original (French)

Remove header and footer in excel, data lost

marjo83100 -  
trotte-menu Posted messages 904 Registration date   Status Member Last intervention   -
Hello,

I followed your instructions, but when I do a print preview: blank page. I printed: blank page.
Fortunately, I saved my file.
I am using LibreOffice, and I can't figure out how to remove "Sheet 1" and "Page 1".
Thank you for your help.

Configuration: Windows / Edge 94.0.992.50

3 answers

  1.
    OOoForum Posted messages 3871 Registration date   Status Member Last intervention   965
     
    You talk about Excel in the title and LibreOffice in the message. It's all a bit unclear.
    With free software, you work in ODS format, not XLS.

    .
    --
    Why pirate MS Office when there is a free solution?
    Use OpenOffice.
    0
  2. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    Hello. 

    What instructions? You haven't been given any instructions!
    .

    To remove "sheet1", right-click on the tab and choose [Delete sheet ...].
    You can't remove "page 1"; you just need to not select it in Format / Print area ...

    --
    Retirement is nice! Especially in the West Indies ...
    Raymond (INSA, AFPA)
    0
  3. trotte-menu Posted messages 904 Registration date   Status Member Last intervention   349
     
    Hello,

    I think you didn't understand. marjo83100 wants to remove Header 1 and Page 1 that she sees in the preview mode.

    Switch back to normal view
    Insert menu > Header and Footer
    Header tab > Delete Header 1

    Footer tab > Delete Page 1

    Click OK

    Alternatively, from the Insert menu, remove the header and footer if they are unnecessary.

    Or maybe I didn't understand, and if so, I apologize.

    0