Re:You Suck at Excel with Joel Spolsky (2015) [video]
by bpizzi on Thursday September 08, 2016 @04:22AM
(#12451187)
I don't get why he's drawing a line instead or putting a proper border... Anyone got the subtility or is it that he just don't know about borders?
[ Parent
| on HN ]
Re:You Suck at Excel with Joel Spolsky (2015) [video]
by squimmy on Thursday September 08, 2016 @05:40AM
(#12451527)
He explains that by using a line he can more easily move it "when the quarters move".
Using a border would require removing the border and adding a new one every three months. A line can be dragged around at will. This also makes it more useful for miscellaneous illustrative purposes.
Re:You Suck at Excel with Joel Spolsky (2015) [video]
by davej on Thursday September 08, 2016 @08:53AM
(#12452463)
I'm an excel noob but doesn't table mode fix all this.
Re:You Suck at Excel with Joel Spolsky (2015) [video]
by duncanawoods on Thursday September 08, 2016 @04:44AM
(#12451278)
Possibly because a border is part of a column so if you insert a new column adjacent to a border you have to remove the old one and redraw it which is pretty annoying because its tucked behind a few clicks and menus.
A line however floats relative to the columns so you don't have to remove/redraw it. At worst you might have to move it.