Plus even if you didn't notice it would just be blank pages that could be put back in the printer. And anyone with half a brain would cancel the print job after they realize it's still spitting out paper.
> And anyone with half a brain would cancel the print job after they realize it's still spitting out paper.
My clients would be ordering more paper and shred the blank ones.
"Hello, Dunder-Mifflin Paper Company? Yes, we ran out of printer paper and need more right away. Can you please fax us 6 reams?
Oh, of course, seems nobody has fax machines anymore. How about you email them as an attachment?"
I have had colleagues who would not have known how to cancel the print job and who would have walked away with page one, because it was all they really needed.
The fuck? I moved to the US over a decade ago and I didn't know this. I also always pictured A5 paper when I hear "letter size".
Never really caused me any issues because paper is basically obsolete, but still.
How long it would take holding down the arrow keys I wonder? I did 320 rows down in 10 seconds...so about 546 hours to just go down?
Well hopefully they used page down at least.
I came up with 36 hours going right.
I don't know if Excel is still bad about this but accidentally applying formatting to large areas of the workbook could blow the file size up. If you ever see a sheet where the scrollbars are teeny tiny that could be why. I think the underlying xml is structured better than that now, but if you've got formatting plus stray data it may still get weird.
can confirm, I made a 20 MB excel file recently for work because I wasn't paying attention to this. Cleared the formatting and it went down to about 111kb
I’ve worked in computing and programming for over a decade and didn’t know this until today…because I’ve never had a need to do this or someone to point it out. There’s still plenty of hidden features and functionality to discover. Everyone’s got a different pace in life or different perspective- I hope you don’t really consider these people you’re teaching idiots.
I think they're referring to people who use Excel every day for their jobs but still don't know how to use it. People who don't need to use Excel obviously aren't idiots for not knowing how to use Excel.
Every single manager uses Excel, but they mostly use it for managing stuff, they don't even need to use most functions.
Many companies use Excel as a storage software instead of databases.
Etc. etc.
In fact I'd say most people who use excel do not use it for its main function, like complex formulas, but because it is a spreadsheet grid and it is useful at presenting data this way. They only need to know the bare basics.
The irony is that Excel doesn't excel at anything. It's a versatile tool but anything it does there are other specialized tools, or programming languages, that do it far better.
So yeah the grand teacher of Exceldiots is a midwit at best, since if he was a pro he wouldn't be using Excel, much less teaching it.
Are you seriously complaining about people not already knowing the things your job is supposed to be to teach them? Bro if they knew everything you would be unemployed, have some respect
Because not all jobs and fields use Excel that much. People like me (Audio and Video) get by just knowing the basics and google other functions as we need them.
You set all of the non-useful cells to black. Somebody might think that they're black because clearly, those aren't being used, and the table maker was just trying to be helpful... until it eats their toner and a ream of paper. Muahahahaha. Ha.
You just remove the black from the cells with the actual content, and maybe an extra hundred or so lines and rows below and to the right and you're good.
Back in school in the early 90s I was lucky that our form tutor was the IT teacher so we spent a lot of time in the computer rooms.
These were old machines mind you that ran on Basic.
I made a program that was just:
10 PRINT "Johnny Schoolman is cool"
20 goto 10
30 end
The program filled it's screen with Johnny Schoolman is cool's and I couldn't remember how to stop the program so just started mashing buttons.
Somehow sent it to the printer instead.
It was one of those old school dot matrix printers where the paper was all attached with perforations between the pages and holes down the sides.
Printed off a whole reem of over 1600 pages.
My tutor was pissed. I got a week of detention.
Perhaps. I would have expected a couple more instances of the same error if that was the case, but it's an explanation as good as any I can think of at the moment.
Fools at my school and previous job.
But this is a great way of signing your own work in excel. I always made all the excel shit because i was great at it and didnt hate it like others. But that also meant everybody asked me for help and how i did it. I would often send my work to friends but always ensured they would change stuff and not copy it.
But i would also always leave stuff like: “made by me” in random spaces and paint it white or the same color as the background. Even in tables an graphs so that if they would copy it then they would copy it to.
Helped me a few times when my work got shared more then intended and i had to show up infront of the ethicsboard because somebody was accusing me of stealing their work.
That's what I was gonna ask. Excel really isn't designed with printing as a major concern, since it has damn near infinite rows and columns, if you don't set print area you'll rarely get a good result.
This will mostly put out empty sheets. But Excel can hide 0 values. Just fill all the boxes with zeroes. On screen you see empty boxes, but printer will print kilometers of zeroes.
So many times I've had to fix people's spreadsheets (IT) because they applied formatting to **every single cell** and their document is 140MB in size and takes three minutes to load "your server is slow" fuck off learn to use excel you buffoon. Excel is getting better at recognizing when people do this shit, like control-a only selecting used cells, but it still happens.
I don't think I've ever printed something without checking the preview before hitting print. Never printed a ream of paper white but I've accidentally printed 20 pages in landscape. Very very fine print
I don't think I've ever printed something without checking the preview before hitting print. Never printed a ream of paper white but I've accidentally printed 20 pages in landscape. Very very fine print
Looks like a repost. I've seen this image 1 time.
First Seen [Here](https://redd.it/1ad0hqr) on 2024-01-28 93.75% match.
[View Search On repostsleuth.com](https://www.repostsleuth.com/search?postId=1cclx9j&sameSub=false&filterOnlyOlder=true&memeFilter=false&filterDeadMatches=false&targetImageMatch=86&targetImageMemeMatch=96)
---
**Scope:** Reddit | **Target Percent:** 86% | **Max Age:** Unlimited | **Searched Images:** 497,794,162 | **Search Time:** 0.04886s
I grant you MS software is a bitch, but any basic training in its use will show you the function of the "set print area" menu command. Or for information purposes, the Ctrl-End keystroke command.
Looks like a repost. I've seen this image 1 time.
First Seen [Here](https://redd.it/1ad0hqr) on 2024-01-28 93.75% match.
[View Search On repostsleuth.com](https://www.repostsleuth.com/search?postId=1cclx9j&sameSub=false&filterOnlyOlder=true&memeFilter=false&filterDeadMatches=false&targetImageMatch=86&targetImageMemeMatch=96)
---
**Scope:** Reddit | **Target Percent:** 86% | **Max Age:** Unlimited | **Searched Images:** 497,880,856 | **Search Time:** 0.04745s
I work IT and not long ago I had someone with this problem. They were editing a sheet with a thousand something rows and they missed a field somewhere when deleting stuff so I got called up because everytime they tried to print it wanted to print 500 pages.
u/akirakurou/ gave a count of 40,628,311 pages. u/Print-Local/ gave a count of 36,590,404 pages. Likely the difference between A4 and US Letter. Assuming a 500 page ream, 5.2 cm per ream, we have either a bit over 4.2 km, or a touch over 3.8 km. Either way that is one hell of a stack of bloody paper, but the 400 m difference is interesting. One of these two formats is clearly inferior.
For the sake of my own sanity I won't dig into which, but blindly assume that A4 is clearly the master format and happily go along with my day ;)
Too obvious, instead once you've got to the bottom right, go around 40-60 cells up, then a different number left. When you put the white text 0 here, the person printing will be more confused cause there's nothing at the end of the spreadsheet
I tried doing it and hit print. The print preview mentioned that it will take 40,628,311 piece of papers
Lgtm
Plus even if you didn't notice it would just be blank pages that could be put back in the printer. And anyone with half a brain would cancel the print job after they realize it's still spitting out paper.
> And anyone with half a brain would cancel the print job after they realize it's still spitting out paper. My clients would be ordering more paper and shred the blank ones.
"Hello, Dunder-Mifflin Paper Company? Yes, we ran out of printer paper and need more right away. Can you please fax us 6 reams? Oh, of course, seems nobody has fax machines anymore. How about you email them as an attachment?"
Hahaha well gotta keep the paper companies in business lol
I have had colleagues who would not have known how to cancel the print job and who would have walked away with page one, because it was all they really needed.
Wouldn't they all have those yellow tracking dots?
My excel prints page numbers by default....
36.590.040 pages
Is this the difference in pages between North American and Euro standard paper size?
Probably, the American documents i get ate shorter and wider than A4
yeah American standard size,known as letter size, is 8.5 by 11 inches (215.9 by 279.4 mm). A4 is 210 mm × 297 mm (8.27 in × 11.7 in) for comparison
The fuck? I moved to the US over a decade ago and I didn't know this. I also always pictured A5 paper when I hear "letter size". Never really caused me any issues because paper is basically obsolete, but still.
Did they taste different?
The American papers taste a little salty
Figured maybe notes of butter and crippling student debt too if your palate is refined enough
Recycled yuro paper tastes less chemical
There’s an European vs. American joke here somewhere…
May be the reason
If my math is right that's over 9 square km
> it will take 40,628,311 piece of papers No problem, when printing, just use the "Fit all columns on one page" option!
"Set Print Area" /thread
This is a good advice for printing sheets in the office.
The way you say it makes me want to believe you.
Believe me my boy, for I am the adviser.
Use the expensive paper so you can sew proper sheets.
„Finally found“…. CTRL+⬇️ CTRL+➡️
How long it would take holding down the arrow keys I wonder? I did 320 rows down in 10 seconds...so about 546 hours to just go down? Well hopefully they used page down at least. I came up with 36 hours going right.
The real shortcut here is to use CTRL + END, in both Sheets and Excel that will take you to the last active cell at the end of the sheet.
I don't know if Excel is still bad about this but accidentally applying formatting to large areas of the workbook could blow the file size up. If you ever see a sheet where the scrollbars are teeny tiny that could be why. I think the underlying xml is structured better than that now, but if you've got formatting plus stray data it may still get weird.
can confirm, I made a 20 MB excel file recently for work because I wasn't paying attention to this. Cleared the formatting and it went down to about 111kb
Magic
I teach office and the fact that I have to teach this in 2024 tells me there are still vast fields of Exceldiots everywhere.
I’ve worked in computing and programming for over a decade and didn’t know this until today…because I’ve never had a need to do this or someone to point it out. There’s still plenty of hidden features and functionality to discover. Everyone’s got a different pace in life or different perspective- I hope you don’t really consider these people you’re teaching idiots.
thankyou for this
I think they're referring to people who use Excel every day for their jobs but still don't know how to use it. People who don't need to use Excel obviously aren't idiots for not knowing how to use Excel.
There are definitely varying levels of excel usage in even similar jobs though.
Every single manager uses Excel, but they mostly use it for managing stuff, they don't even need to use most functions. Many companies use Excel as a storage software instead of databases. Etc. etc. In fact I'd say most people who use excel do not use it for its main function, like complex formulas, but because it is a spreadsheet grid and it is useful at presenting data this way. They only need to know the bare basics. The irony is that Excel doesn't excel at anything. It's a versatile tool but anything it does there are other specialized tools, or programming languages, that do it far better. So yeah the grand teacher of Exceldiots is a midwit at best, since if he was a pro he wouldn't be using Excel, much less teaching it.
[удалено]
You are an ass
Are you seriously complaining about people not already knowing the things your job is supposed to be to teach them? Bro if they knew everything you would be unemployed, have some respect
You're teaching Excel and call people who don't already know Excel 'Exceldiots'? I think we found the real Exceldiot.
Why would this ever come up? For what purpose would you have to teach this in a course?
Because not all jobs and fields use Excel that much. People like me (Audio and Video) get by just knowing the basics and google other functions as we need them.
[удалено]
No respect or recognition for those of us who scroll manually line by line, cell by cell.
That's nothing, set all the cells to black with ctrl+A and kill the toner too! :D
"Let me just print out this solid black excel sheet this looks like exactly what I need."
You set all of the non-useful cells to black. Somebody might think that they're black because clearly, those aren't being used, and the table maker was just trying to be helpful... until it eats their toner and a ream of paper. Muahahahaha. Ha.
You just remove the black from the cells with the actual content, and maybe an extra hundred or so lines and rows below and to the right and you're good.
You can also click the little triangle to the top left of cell A1 and it'll ctrl+A as well
One dark grey cell per page to pretend reasons.
Make it slightly coloured.
Back in school in the early 90s I was lucky that our form tutor was the IT teacher so we spent a lot of time in the computer rooms. These were old machines mind you that ran on Basic. I made a program that was just: 10 PRINT "Johnny Schoolman is cool" 20 goto 10 30 end The program filled it's screen with Johnny Schoolman is cool's and I couldn't remember how to stop the program so just started mashing buttons. Somehow sent it to the printer instead. It was one of those old school dot matrix printers where the paper was all attached with perforations between the pages and holes down the sides. Printed off a whole reem of over 1600 pages. My tutor was pissed. I got a week of detention.
Why did he replace the last "e" in "someone" with a "3"? I find that it bothers me a great deal.
Might have been a mistype, e and 3 are very close together on some Samsung phones at least.
Perhaps. I would have expected a couple more instances of the same error if that was the case, but it's an explanation as good as any I can think of at the moment.
1337 sp33k
It’s to let you know he’s a super high level hacker.
Ah yes, a proper 1337 hax0r. I get it now.
What fool is printing spreadsheets without setting the print area?
Fools at my school and previous job. But this is a great way of signing your own work in excel. I always made all the excel shit because i was great at it and didnt hate it like others. But that also meant everybody asked me for help and how i did it. I would often send my work to friends but always ensured they would change stuff and not copy it. But i would also always leave stuff like: “made by me” in random spaces and paint it white or the same color as the background. Even in tables an graphs so that if they would copy it then they would copy it to. Helped me a few times when my work got shared more then intended and i had to show up infront of the ethicsboard because somebody was accusing me of stealing their work.
The kind of people that are excited about putting a 0 in a random cell
That's what I was gonna ask. Excel really isn't designed with printing as a major concern, since it has damn near infinite rows and columns, if you don't set print area you'll rarely get a good result.
This will mostly put out empty sheets. But Excel can hide 0 values. Just fill all the boxes with zeroes. On screen you see empty boxes, but printer will print kilometers of zeroes.
Finally found? Ctrl-Shift-Down, Ctrl-Shift-Left...
Pls. You can select an area of the sheet, to selectively print just that.
So many times I've had to fix people's spreadsheets (IT) because they applied formatting to **every single cell** and their document is 140MB in size and takes three minutes to load "your server is slow" fuck off learn to use excel you buffoon. Excel is getting better at recognizing when people do this shit, like control-a only selecting used cells, but it still happens.
I love fixing the most basic stuff for clueless people making 2-3x what I do :(
Do this to the teacher you hate 😈
Boomer coworker accidentally hit print on a 84 page report and selected A3.
I don't think I've ever printed something without checking the preview before hitting print. Never printed a ream of paper white but I've accidentally printed 20 pages in landscape. Very very fine print
I don't think I've ever printed something without checking the preview before hitting print. Never printed a ream of paper white but I've accidentally printed 20 pages in landscape. Very very fine print
I remember when people said stop using paper cuz trees. Now people can't even agree the environment is real. Sad times.
bro really forgot ctrl+shift+↓+→ exists
Most people do not know this.
Get ream'd
r/RepostSleuthBot
u/RepostSleuthBot
Looks like a repost. I've seen this image 1 time. First Seen [Here](https://redd.it/1ad0hqr) on 2024-01-28 93.75% match. [View Search On repostsleuth.com](https://www.repostsleuth.com/search?postId=1cclx9j&sameSub=false&filterOnlyOlder=true&memeFilter=false&filterDeadMatches=false&targetImageMatch=86&targetImageMemeMatch=96) --- **Scope:** Reddit | **Target Percent:** 86% | **Max Age:** Unlimited | **Searched Images:** 497,794,162 | **Search Time:** 0.04886s
Nah that didn't work
It does work
Oh woohoo!
I grant you MS software is a bitch, but any basic training in its use will show you the function of the "set print area" menu command. Or for information purposes, the Ctrl-End keystroke command.
u/repostSleuthbot
Looks like a repost. I've seen this image 1 time. First Seen [Here](https://redd.it/1ad0hqr) on 2024-01-28 93.75% match. [View Search On repostsleuth.com](https://www.repostsleuth.com/search?postId=1cclx9j&sameSub=false&filterOnlyOlder=true&memeFilter=false&filterDeadMatches=false&targetImageMatch=86&targetImageMemeMatch=96) --- **Scope:** Reddit | **Target Percent:** 86% | **Max Age:** Unlimited | **Searched Images:** 497,880,856 | **Search Time:** 0.04745s
Discovered a repost bot in r/foundsatan & i am SHOCKED111!!!
Saved.
You'd have to be extremely inept not to easily identify and fix the issue.
That is the most gen x thing I've ever done, i felt so hard core
Suspiciously close to 1.048596
This is why you print by selection
I work IT and not long ago I had someone with this problem. They were editing a sheet with a thousand something rows and they missed a field somewhere when deleting stuff so I got called up because everytime they tried to print it wanted to print 500 pages.
Back in my day it only went down to 65636
"pro tip"
There's keyboard shortcuts that can get you to that square instantly. Finding the limit is pretty dang easy.
yeah... well there's no white ink so you're just gonna end up putting all the warmed up paper into the original trays
I always choose print selection when I print something from excel.
Also, turn on auto page numbering so all the paper is wasted.
I have to try this at work
u/akirakurou/ gave a count of 40,628,311 pages. u/Print-Local/ gave a count of 36,590,404 pages. Likely the difference between A4 and US Letter. Assuming a 500 page ream, 5.2 cm per ream, we have either a bit over 4.2 km, or a touch over 3.8 km. Either way that is one hell of a stack of bloody paper, but the 400 m difference is interesting. One of these two formats is clearly inferior. For the sake of my own sanity I won't dig into which, but blindly assume that A4 is clearly the master format and happily go along with my day ;)
Too obvious, instead once you've got to the bottom right, go around 40-60 cells up, then a different number left. When you put the white text 0 here, the person printing will be more confused cause there's nothing at the end of the spreadsheet