Do some Excel Work for Workers Schedule

  • Status: Closed
  • Præmier: €10
  • Modtagne indlæg: 23

Konkurrence Instruktioner

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

Anbefalede Evner

Bedste indlæg fra denne konkurrence

Se flere indlæg

Offentlig Præciserings Opslagstavle

  • sergpooh
    sergpooh
    • 3 år siden

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

    • 3 år siden
  • thanhphu282
    thanhphu282
    • 3 år siden

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

    • 3 år siden
  • metifdare
    metifdare
    • 3 år siden

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

    • 3 år siden
  • alexlexa
    Konkurrenceafholder
    • 3 år siden

    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

    • 3 år siden
    1. chrismdev
      chrismdev
      • 3 år siden

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

      • 3 år siden
    2. captaksinha
      captaksinha
      • 3 år siden

      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.

      • 3 år siden
  • ElaineTeo
    ElaineTeo
    • 3 år siden

    Entry #13 .. Please check

    • 3 år siden
  • accurateG
    accurateG
    • 3 år siden

    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

    • 3 år siden
  • nurmohammad21
    nurmohammad21
    • 3 år siden

    rating please !

    • 3 år siden
  • nwss1986
    nwss1986
    • 3 år siden

    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.

    • 3 år siden
  • roysude
    roysude
    • 3 år siden

    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:)

    • 3 år siden
  • nwss1986
    nwss1986
    • 3 år siden

    Solved.please check my uploaded files..

    • 3 år siden
  • Suryavijaysinh
    Suryavijaysinh
    • 3 år siden

    You can use group.

    • 3 år siden
    1. chrismdev
      chrismdev
      • 3 år siden

      I just wrote a macro that hides, prints then unhides

      • 3 år siden
    2. Suryavijaysinh
      Suryavijaysinh
      • 3 år siden

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

      • 3 år siden
  • chrismdev
    chrismdev
    • 3 år siden

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

    • 3 år siden
  • ultimatum78
    ultimatum78
    • 3 år siden

    set printing area in page layout

    • 3 år siden
    1. alexlexa
      Konkurrenceafholder
      • 3 år siden

      i know what you mean but it doesnt work that way

      • 3 år siden
  • mariakrodrigues
    mariakrodrigues
    • 3 år siden

    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..

    • 3 år siden

Vis flere kommentarer

Sådan kommer du i gang med konkurrencer

  • Opret din konkurrence

    Opret din konkurrence Hurtigt og nemt

  • Få tonsvis af indlæg

    Få tonsvis af indlæg Fra hele verden

  • Tildel det bedste indlæg

    Tildel det bedste indlæg Download filerne - Nemt!

Opret en Konkurrence Nu eller slut dig til os i dag!