Mick2152
102102
1544
42
Aug 27, 2021 4:37 PM
Mick2152
102102
1544
42
Tehnam
set... print... area...
letisdorock
That's why you preview before printing.
LooseyGooseyBrett
Not that hard to find, or if not find simply delete the extra columns
sadurdaynight
(the joker) If you don't look at print preview before printing the spreadsheet, then you get what you fucking deserve!
DavidBrooker
I remember a meeting where some old coot argued that we shouldn't upgrade excel from 2003 because newer editions allowed more rows, up 1/2
DavidBrooker
to a million or more, and that this was "too many". 2/2
Cthulhuonabike
Unless you select all grid lines those pages will just print off blank pages that can be put back in the printer
sammyismycat
ahhh "set print area". uhhuh
ArcaneDryad
Won’t it just print out empty paper? And can’t you just stop printing if you see extras are coming out?
amsterdam1981
Doesn't everyone set a printarea?
fordag
There is (at least there was) a flight simulator game hidden in Excel.
thetof91
Don’t even need to print. The excel file will be very big. Someone in the company all of the sudden had a excel 120 mb. Found out because
thetof91
Of 1 cell very long down was coloured grey. So it had to save that, and then save that every cell down was blank. After removed it was 5 mb.
waltjrimmer
But... Why? Why do you not want people to print Excel sheets? I mean, it's weird, but why punish it?
Solear
To be honest it's not printing data, just turning empty papers, that can be stopped any time.
VC999999
that's why I always do "print preview"
livinglitch
I did the math for this. A standard ream of paper is 500 pages. Printing out to XFD1048576 uses 40,628,331 pages (1/?)
livinglitch
Once paper is put through a printer it is heated and curled. It can't be used again or there will be a high chance for a jam (3/3)
livinglitch
That works out to be 81,256.662 remans of paper and at the which would cost about $1,056,341 dollars in paper to print. (2/3)
ComcastLover
If this is the evilest thing you can imagine you lack imagination
Broonstar
most people who print excel sheets tend to set a printable area
kakivara
Some of you fucking suck at imagining things, and it shows.
cowboyshooter
Who isn't setting their print range?
Hobnobble
A1 notation at it's absolute peak.
Farinhadefigo
its*
theangryjanitor
Jeez man. Paint their windshield while your at it
APointlessBee
My mom did that to her band teacher but she didn't know that shoe polish was water proof aaaaaand he spent all weekend scraping his windows.
theangryjanitor
Man. Their car insurance sucks. No free windshield replacement? Cry safety issue and they don't argue.
DidCatchABreak
Yeah, that'll be a manager that does that, and someone else will actually have to deal with the mess
TotallyNotASnail
Ctrl + arrow key will jump to the end of the filled cells and if there are none, the end of the sheet
Randomusername210
This! Thank you!
SploogeMcDuck316
My printer tells me how many pages it will be when printing. Im sure a million pages would throw a flag.
theamazingmrbiggs
also, it won't 'eat' a ream. the paper will be blank
IFoldlyGo
That's why you make sure to add header and footer text
waltjrimmer
No. I've gotten printed out Excel sheets. It prints the cells. So you'll have pages of printed out empty cells.
livinglitch
Even if they are printed blank, it still eats the paper. Once its been heated through the printer it cant be used again or it could jam. -IT
SithElephant
That's just what they want you to think. Don't be a sheetple.
livinglitch
No. I got called to a site several weeks in a row for jammed printers. We would get it fixed with new parts and it would break again.
livinglitch
heads by putting the paper through once to print the template, then a second time to print the letter that we discovered the cause. (3/X)
livinglitch
We swapped the printer out with a brand new one and that broke within a few weeks. It wasn't until we saw the users creating letter (2/x)
livinglitch
We fixed the workflow by sending the pages to a different printer that could be stocked with actual letterheads. (4/4)
inchwormwrath
I use excel everyday, but I can't remember the last time I printed a spreadsheet. I don't even have a printer hooked up.
CogYang
I usually delete unused cells. As rows or columns back if needed later
Silverbananahorse
EmailFail
Spoken like someone working with Excel daily
Einstein9073
In Excel when you delete a row or column, a new one gets added at the end. In Google Sheets, that row is gone forever
theangryjanitor
Like all the time we spend doing things that are productive, unproductive or of inestimable productivityness. Like raising happy kids.
Kliamovich
I always set a print range
theoracleofdreams
PugDogMan
cyberimg
1048576 is of course 2^20. XFD is... 24,6,4, so 2^14
rbudrick
Of, course.
JeretJax
ENCHANTMEN
With default settings, this prints 36,567,729 pages
LurkerOfDarkness
"Fit to page"
TunnelRat13
Congratulations. This is even more evil. Thanks Satan.
CziltangBrony
FrenchButterPerformance
So it's 2^6 = 64 times longer than it is wide?
xXxSTEVOxXx
2^34 cells seems like enough right?
drbloodbathmc
No. I need more because…I want them….
DanteLidge
Why not say 17,179,869,184 instead of acting like a smartass? (17.1 milliard/billion)
GerberLegalTeam
The fuck is a milliard?
DanteLidge
1000 million, what the US calls a billion
GerberLegalTeam
Thanks, never heard that before.
xXxSTEVOxXx
Efficiency because I am a work-smart-not-hard-ass. Also. Rude.
DanteLidge
How is it efficient to use a system I'm guessing 80% of the world can't intuitively use? I myself don't know exponents by heart.
xXxSTEVOxXx
requires less typing. lol why is this important enough to follow up on... like what is at stake here
OlafJS
How many countries use milliard?
ExtraAverage
At least twone
OlafJS
In Scandinavia perhaps?
DanteLidge
Milijarda is Croatian for Milliard, which is what we use. Billion for 1000 million is only in the US, AFAIK.
OlafJS
Interesting, we also use milliard but do have billion and billiard (which are 1 000x and 1 000 000x US billion)
KingXizor
That would round up to 17.2 milliard, Jackass.
DanteLidge
17.17 if you don't round up, I just used only one decimal point.
SPCNewbie
If you were rounding to 2 decimal point wouldn't be .18 since it was .179
RedClaws23
Decimal truncation is just being wrong with extra steps. Sauce: Am physicist, have been wrong with extra steps
TomBrokaw
Why is using scientific notation "acting like a smartass"?
DanteLidge
Because it's not a large enough number to warrant it. Should I say 2^10 instead of 1024? It's a bit ridiculous, isn't it?
xeth
I give 1^1^1^1 fucks, how people write
TomBrokaw
Not large enough according to who? You don't have to like it, but criticizing it comes across as remarkably petty
DefinitelyNotMadeOfBees
Do people print Excel spreadsheets??
Bystandr
Yes and for more than just accounting ledgers- excel can map other data, and sometimes stat mapping can be assisted with physical copies.
DefinitelyNotMadeOfBees
Why would you use Excel for that?
Bystandr
Convenience, mostly. Most everyone has excel. Few people have dedicated scientific data correlators so it maps across all the people you
Bystandr
want to share it with that dont have those tools.
Bystandr
I guess I should add: the last time I used it that way professionally was almost 20 years ago, so things have changed a bit since, no doubt,
Noodlesocks
We do because the company I work for uses it for things that don't need to be spreadsheets.
thisismyusernamewhatsyours
Ppl print everything.
Pimparoo3
Do...do you not? Print that shit all the time to review stuff. It's easier if I can highlight/ add in notes manually.
DefinitelyNotMadeOfBees
I...do not. I work with large datasets; printing them would be an enormous waste, especially since I make incremental changes all the time.
Ssigel
Usually i turn them into PDFs (only selected cells to avoid unecessary pages in my file) and sometimes people print those PDFs
ITellBadPuns
I had to take a course on Excel once. Spent the whole time doing pixel art and printing it lol
SirButcher
I create invoices with excel...
DefinitelyNotMadeOfBees
Fair. I used to, too.
Dakksys
Have you MET middle management?
q2grapple
I’m too busy working on my TPS reports to meet anyone
Sutashi
Sasly there are people who change the view so it looks like a word processor then add objects to put text in.
JustAFlamingoInDisguise
My boss does. I sent him daily pivot tables and charts with productivity and stock data. He prints them for meetings ?
Mr21782Man
I know people that print everything to read, including emails.
DefinitelyNotMadeOfBees
Those people scare me.
backrideup9
I balance my bank accounts with it for about 8 years. Keep a good budget that way.
theusernameformerlyknownastildo
At times, yes cause even with 2 monitors it's easier to have in front of me than toggling. But I always set the print area to what I need.
thetof91
I am next to accounting in the company. They print a lot. Paychecks and all that they have to keep physical copy for 5 years.
H2ONerd
I print them all the time at work, DEP does everything in weird excel sheets. Some of the expressions are nuts, but they work.
T1GWBJAH
Almost everyday at my work since we use it for customs documentation
CodeWarrior
If they are using it as a form template that will eventually be filled out by hand.
DarthGaymer
Only print the summary tables, never the data
leidrienne
I work in pharma research and we print out data to check by hand against the source to make sure it was entered correctly
DefinitelyNotMadeOfBees
Thank you. I also work in pharma R&D and messy SDTMs or, god forbid, TLFs are the bane of my existence.
girlsdontp00p
Many workplaces still want physical records in case servers are somehow lost
ChloeRed
One of my clients is glad they keep paperrecords after their parent company had a ransomware attack, we didn't lose anything but didn't 1/
ChloeRed
have access to the digital versions for over a week. Makes "fun" outcomes when you need things like insurance documents. 2/2
DefinitelyNotMadeOfBees
Fair, but they should have backup servers in place, too
ChloeRed
Really? You have backup servers in place with copies of your data and no connections to anything else (how do you get the data onto them 1/
seamusmcfly
Those of us that do know how to use the print selection.
TheyCalllMeTIM
Sorry I have to run and stop the printer. It’s on page 16 of 13000
TeflonTrout
Coming here to say that. Always use that or print preview, even in Word
LordRevan2584
We are a dying breed my friend.
IhopeyougetstageIIIcoloncancer
That's only because instead of having sex we're optimizing our Match-Index lookup algorithms.
shortcakechuckles
I want you to know that I really appreciate this comment.
IhopeyougetstageIIIcoloncancer
I appreciate that, but I wish you hadn't. It's too late for me, but you can still save yourself and live a full life, free from Offset() !
Degarafarat
First to pdf in case we f*ck up (and we will). Afterwards on paper when or if needed
detour512
Why print anything...pdf save to phone, tablet or palm pilot.
kildrgn
packing slips with initials from QC department. easier to pass around a paper to assembly shop to make notes on while building items.
DefinitelyNotMadeOfBees
...you have a Palm Pilot??
detour512
Uh no...my friend does...and um...yes I do have one.
pastelteapot
I work in finance and we print excel sheets all the time
OSCgal
Same. Though these days it's mostly print to PDF.
DefinitelyNotMadeOfBees
Do you do data work? Like analytics or forecasting?
pastelteapot
yeah.