Do some Excel Work for Workers Schedule
- Statusi: Closed
- Çmimi: €10
- Kandidaturat e marra: 23
Përmbledhja e konkursit
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
Aftësi të rekomanduara
Këndi publik i sqarimeve
-
sergpooh
- 8 vite më parë
Hello. You watched my version with using custom view? Without macro.
- 8 vite më parë
-
thanhphu282
- 8 vite më parë
Please contact with me. My Macro will help you with only one click.
- 8 vite më parë
-
metifdare
- 8 vite më parë
I have solved it and you will have to just print the file normally but I am unable to upload the excel
- 8 vite më parë
-
Krijuesi i Konkursit - 8 vite më parë
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
- 8 vite më parë
-
chrismdev
- 8 vite më parë
Hi - i have it solved for you however it will not let me upload the excel file
- 8 vite më parë
-
captaksinha
- 8 vite më parë
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.
- 8 vite më parë
-
ElaineTeo
- 8 vite më parë
Entry #13 .. Please check
- 8 vite më parë
-
accurateG
- 8 vite më parë
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
- 8 vite më parë
-
nurmohammad21
- 8 vite më parë
rating please !
- 8 vite më parë
-
nwss1986
- 8 vite më parë
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.
- 8 vite më parë
-
roysude
- 8 vite më parë
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:)
- 8 vite më parë
-
nwss1986
- 8 vite më parë
Solved.please check my uploaded files..
- 8 vite më parë
-
Suryavijaysinh
- 8 vite më parë
You can use group.
- 8 vite më parë
-
chrismdev
- 8 vite më parë
I just wrote a macro that hides, prints then unhides
- 8 vite më parë
-
Suryavijaysinh
- 8 vite më parë
nice then submit it bro. Good luck for your entry:)
- 8 vite më parë
-
chrismdev
- 8 vite më parë
Hi - i have it solved for you however it will not let me upload the excel file
- 8 vite më parë
-
ultimatum78
- 8 vite më parë
set printing area in page layout
- 8 vite më parë
-
Krijuesi i Konkursit - 8 vite më parë
i know what you mean but it doesnt work that way
- 8 vite më parë
-
mariakrodrigues
- 8 vite më parë
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..
- 8 vite më parë
Si të fillosh me konkurset
-
Posto konkursin Shpejt dhe thjeshtë
-
Merr shumë propozime Nga e gjithë bota
-
Zgjidh kandidaturën më të mirë Shkarko dokumentet - E thjeshtë!