CTRL+End Goes Too Far in Excel and Google Spreadsheets

Irked. That's how you feel when you hit CTRL+End and you land way beyond the end of your data in Microsoft Excel or Google Spreadsheets.

CTRL+End overshoots the end of the data after a lot of data is deleted. Although you eliminated the data, the spreadsheet doesn't update what it considers to be the active range.

However, there's an easy fix.

First, delete all the rows that used to house the deleted data.

Second, save the spreadsheet to force it to update the active range.


Google News Won't Save Editor's Pick Viewing Frequency Setting

You visit Google News. You start to look at the Editor's Picks.  Sewing and Crochet World appears. No offense to sewers and crocheters, but you just aren't into that so set this publication to appear rarely by moving the slider under the headlines over to the far left.

Next visit what do you see? Sewing and Crochet World! Adding insult to injury, the frequency setting is back to sometimes! What gives?

So you try several times to set it to rarely but the setting never sticks.

Try this -- it might not work but is worth a shot.  Go to Personalize at the top of Google News. Find the publication that you want to change the frequency of  Under Adjust Sources. If the publication isn't listed, you can type its name in the "adjust frequency of any source" box to make it appear. Move the slider to the desired frequency and then scroll down and hit the save button.

This has worked for me.  Your mileage may vary.