Highest Rated Comments


Frozenlazer660 karma

I love it when something I've known for probably 20 years gets brought up like this.

Here's a couple more:

Want to sum up a column, try alt =

Want to change a reference in a formula from A1 to A$1$ to A$1 to A1$ press F4 to cycle thru.

Frozenlazer326 karma

Not on the team - You can do that. Just goto "View" and then click "New Window"

It will open a clone of your current workbook, same as if you had a second file open, then you can arrange those with the "Arrange All" button or just by dragging them around.

Edit - You can even use it to look at 2 different points in the same worksheet. They will mirror each other if you type into one, it changes in the other.

Frozenlazer147 karma

Have you tried the scaling options in the print dialog? You can force it to things like "All columns on one page". It seems to usually work for me. I mean you'll never get 50 columns on page in size 12 font, but other than that, it works okay.

Frozenlazer88 karma

I've always felt like picking the "fastest" local server isn't really a great test of what internet speed is all about. Esp when it is often a server hosted by my ISP.

To me its a bit like saying that I can get to the corner store very quickly because there are no stop signs or traffic between my house and the store. So maybe that means my speed to that destination is 70mph.

However if I wanted to travel to the mountains of Mongolia, my average speed would be far far less.

And with the internet, we are constantly accessing information from all over the world thru all types of networks.

I guess really it comes down to the goal of Speedtest.net. Is it to determine the absolute fastest I can connect to another host, or is it to give me an idea of real world performance.

I'd love to see a second type of test that hits a handful of random servers across a random set of networks and see how that performance compares across ISPs.

Frozenlazer82 karma

How can that be? If I learn to read CAT by saying CCCC AAA TTTT. CAT.

Then I later learn to read HAT, I can reference that the AT in CAT in the same as the AT in HAT and get to the correct result quicker.

Maybe I'm a bad person to think about this because reading came EXTREMELY easy for me, and I was the one who was frustrated by the "dumb" kids trying to sound out simple words.

I definitely remember learning what I think we called phonics.

CH makes this sound. CK makes that sound, TION makes this sound. LA makes that sound. Vowels change the sound of other vowels. (Like vs Lick). Put that shit together and you've got a word.

I can't explain any of this anymore because I learned to read in like 1986-1990 (preschool thru 3rd grade or so).

But I swear we weren't just shown flash cards with words, we learned the phonics. This was also the era of "Hooked on Phonics worked for me!"

So did we take a giant step backwards in teaching reading in the years between when I grew up and today?