Just tested. It's Ctrl+right, not Ctrl+left.
Edit: also, no-one says that the cell size has to remain default. 34 million pages is rookie numbers.
Try this fun prank next time a coworker wanders off and leaves their PC unlocked!
Remember to print more than 1 copy, just incase you loose the originals
Remember to start the print going at 4:59pm on a Friday afternoon, preferably before a long weekend
I actually accidentally did this at school way back when. My mate and I decided to have an "Excel" race, where we'd start at the top of the sheet and see who could reach the bottom first by holding down either down arrow or pg down (this is obviously fun when you're 15).
Anyway, I reach the bottom, many laughs are had, go back the top, continue with whatever bullshit assignment we'd been given and then sent it off to the printer. Went onto some top down mini golf flash game and pissed about on there for a bit, until the teacher stands next to me and slams down a massive pile of paper onto my desk. She didn't look impressed.
Turns out I must have put a space or some random character at the bottom by accident and printed it. However the biggest issue was that I'd put my name in the header for the sheet, so every single page had my name in the top corner.
[CTRL] + [A]
Drop down Fill Color > Change to black
[CTRL] + [P]
[ENTER]
But won’t excel detect there’s no values and no print anything?
I think it has logic to only print pages which have values.
-
Type “.” In A1
-
Change the fill colour of A1 to Black
-
[CTRL] + [A] (Selects all cells)
-
[CTRL] + [R] (Copy’s the left most selected column across to the right most select column)
-
[CTRL] + [D] (Copy’s the top most selected column down to the bottom most select column)
Every cell will now contain the value “.” and be set to fill colour black.
-
Right click any of the column letters at the top > Set width > 1000. (Changes the column width to 1000 pixels. (Expanding the cells so they take up more room when printing)
-
Right click any of the row numbers at the left hand side > Set height > 1000. (Changes the row height to 1000 pixels. (Expanding the cells so they take up more room when printing)
-
[CTRL] + [P] (Opens up the print dialog)
-
[ENTER] (Selects the print button to start printing)
-
What does ctrl+p do?
Oh my god we finally did it, we finally went paperless as a species for long enough that someone doesn’t know what a printer is. I never thought I’d live to see the day, but it makes me very happy that we’ve finally gotten here.
I've just thought of a new internet game..
I call it "Zoomer or Boomer?"
Lol except this won't work. Print spooler will hang, job never sent to printer.
Also even commercial office printers usually have 500 page max unless you have some very special printer in the office.
I remember when I sent a huge pdf document to printer and my coworkers noticed that it printed a thick stack of black sheets. I immediately cancelled the printer job and took this pile of sheet to my home and used the clean side for printing.
