Do some Excel Work for Workers Schedule

  • Tila: Closed
  • Palkinto: €10
  • Vastaanotetut työt: 23

Kilpailun tehtävänanto

I would like rows 5-6, 8-9, 11-12 etc... not to be printed.
But not to hide them or to change the color. I would like them to be visible on screen but not to be printed.
Meaning I don't want to hide them before i want to print the sheet I just want them automaticly not to appear on the print.
Be careful row 5 ---> is number, row 6 is formula and this must not change

Suositellut taidot

Julkinen selvennystaulu

  • sergpooh
    sergpooh
    • 2 vuotta sitten

    Hello. You watched my version with using custom view? Without macro.

    • 2 vuotta sitten
  • thanhphu282
    thanhphu282
    • 2 vuotta sitten

    Please contact with me. My Macro will help you with only one click.

    • 2 vuotta sitten
  • metifdare
    metifdare
    • 2 vuotta sitten

    I have solved it and you will have to just print the file normally but I am unable to upload the excel

    • 2 vuotta sitten
  • alexlexa
    Kilpailun järjestäjä
    • 2 vuotta sitten

    i dont want that...i would just like to select rows that shouldnt be printed and that it would be automatic for all future prints

    • 2 vuotta sitten
    1. chrismdev
      chrismdev
      • 2 vuotta sitten

      Hi - i have it solved for you however it will not let me upload the excel file

      • 2 vuotta sitten
    2. captaksinha
      captaksinha
      • 2 vuotta sitten

      it can be done by changing the color of contents in cell to white which is not required to be printed. now if you want to view all contents of the excel sheet just select all and change the text color to black.

      • 2 vuotta sitten
  • ElaineTeo
    ElaineTeo
    • 2 vuotta sitten

    Entry #13.. Please check

    • 2 vuotta sitten
  • accurateG
    accurateG
    • 2 vuotta sitten

    Hello,I just know one macro that can do this.Please contact me.Maybe this macro can help solve your problem.Awaiting your responses.Thanks

    • 2 vuotta sitten
  • nurmohammad21
    nurmohammad21
    • 2 vuotta sitten

    rating please !

    • 2 vuotta sitten
  • nwss1986
    nwss1986
    • 2 vuotta sitten

    The macro selects the required range in the excel file (ie., D to BW and not whole row) and prints the selection.kindly check it out and give your feedback.

    • 2 vuotta sitten
  • roysude
    roysude
    • 2 vuotta sitten

    Hiii...Please put a filter on 2nd column containing data like Darko....etc..then uncheck the blanks...U will have your sheet containing the required data...Please get it printed. Hope this helps:)

    • 2 vuotta sitten
  • nwss1986
    nwss1986
    • 2 vuotta sitten

    Solved.please check my uploaded files..

    • 2 vuotta sitten
  • Suryavijaysinh
    Suryavijaysinh
    • 2 vuotta sitten

    You can use group.

    • 2 vuotta sitten
    1. chrismdev
      chrismdev
      • 2 vuotta sitten

      I just wrote a macro that hides, prints then unhides

      • 2 vuotta sitten
    2. Suryavijaysinh
      Suryavijaysinh
      • 2 vuotta sitten

      nice then submit it bro. Good luck for your entry:)

      • 2 vuotta sitten
  • chrismdev
    chrismdev
    • 2 vuotta sitten

    Hi - i have it solved for you however it will not let me upload the excel file

    • 2 vuotta sitten
  • ultimatum78
    ultimatum78
    • 2 vuotta sitten

    set printing area in page layout

    • 2 vuotta sitten
    1. alexlexa
      Kilpailun järjestäjä
      • 2 vuotta sitten

      i know what you mean but it doesnt work that way

      • 2 vuotta sitten
  • mariakrodrigues
    mariakrodrigues
    • 2 vuotta sitten

    try just selecting the columns that u need to print using CTRL and the mouse... and then give the command print for the selection.. let know if it works..

    • 2 vuotta sitten

Näytä lisää kommentteja

Kuinka päästä alkuun kilpailuiden kanssa

  • Julkaise kilpailusi

    Julkaise kilpailusi Nopeaa ja helppoa

  • Vastaanota tonnikaupalla osallistumisia

    Vastaanota tonnikaupalla osallistumisia Ympäri maailmaa

  • Palkitse paras hakemus

    Palkitse paras hakemus Lataa tiedostot - helppoa!

Ilmoita kilpailu nyt tai liity tänään!