SpreadEveryone: The Fetchland Excel wire

98 watchers

ChrisHB Aug 2021 11:46am, 30 Aug 2021 21,146 posts	0 ChrisHB Or it might be easier to process a .csv version of the spreadsheet, at least in the days when I could write shell scripts.
quimby Oct 2021 11:03pm, 1 Oct 2021 5,034 posts	0 quimby MERGED CELLS. WHY?! (I've had an angry day at work having to make someone else's "data" usable.)
GlennR Oct 2021 11:55pm, 1 Oct 2021 58,917 posts	0 GlennR Definite sign of an Excel amateur.
JCB Oct 2021 1:47am, 2 Oct 2021 2,615 posts	0 JCB I must confess to using them for column headings and the like.
GregP Oct 2021 5:48am, 2 Oct 2021 129,773 posts	0 GregP I’m with Q. Shift-ctrl-l should put you straight, jcb
quimby Oct 2021 7:52am, 2 Oct 2021 5,035 posts	0 quimby Ooh, new shortcut. Thanks, Grep.
kstuart Oct 2021 8:21am, 2 Oct 2021 4,351 posts	0 kstuart When you have three columns of data under the same heading you kinda need to merge some of them surely. More common for me is displaying results with uncertainties lower down the same sheet you get the +/- in the middle which is a narrow column but above is normal data so merging is often the way to do it. Not averse to weird designs or really wide columns mind if i cba playing around with cell merging to make it fit right either though.
GregP Oct 2021 8:24am, 2 Oct 2021 129,777 posts	0 GregP ~has vapours~ ~unsubscribes to calm down~
SPR Oct 2021 9:49am, 2 Oct 2021 35,330 posts	0 SPR You can centre across selection without merging cells. Presume that's what the shortcut does. Merged cells are an abomination.
chunkywizard Oct 2021 11:08am, 2 Oct 2021 12,688 posts	0 chunkywizard Didn’t know that SPR, that sounds much better.