Go-To buttons in spreadsheets 





Good Morning, ,

Today is Thursday, October 13
Today I have to go to Calgary for injections into my
eyeballs. That means no Friday, Saturday, or Sunday
newsletter.

Have FUN!
DearWebby

Todays Bonehead Award:
SC visitor in FL passes out in drive-through
Details at Boneheads
______________________________________________________
Today, October 13, in 
1792 The cornerstone of the Executive Mansion was laid in
Washington, DC. The building became known as the White House,
after the Canucks had burned it in 1812 and it was
subsequently whitewashed in in 1818. 
See More of what happened on this day
in history.

If you can help with the cost of the Humor Letter, please donate what you can!
______________________________________________________ Efficiency is intelligent laziness. --- Socratex "Whatever it is the government does, sensible Americans would prefer that the government do it to somebody else." --- PJ Orourke ______________________________________________________ If you like the Humor Letter, please vote! ______________________________________________________ Upon her engagement, the exuberant young woman went to her mother and said, "I've found a man just like father!" Her mother replied, "So what do you want from me, sympathy?" ______________________________________________________ 2017 Launch Flash Sale MTP $29.99 ______________________________________________________ From the archives: Some funny news: Court TV Thursday June 07 07:56 PM EDT Ms Leibovitz heard rumors that there was sexual harrassment going on at New York City Transit and went to work there. However, when nobody lived up to that rumor and provided her with any sexual harrassment, she sued the Transit authority that having to worry about getting sexually harrassed or not, was a form of sexual harrassment and caused her to gain weight. She was originally awarded $60 000, however last Wednesday the Second Circuit Court of Appeals threw out the jury award and reversed a lower court judge's ruling supporting it. As of now, not getting sexual harrassment is not a form of sexual harrassment. ______________________________________________________ From FB ______________________________________________________
If you like the Dear Webby Daily Humor Letter, please vote for it at the Ezine Finder: Thanks for your votes!
______________________________________________________ Reported by the Bausell Sailor An INTERNATIONAL BONEHEAD AWARD has been earned by Kevin Yonson, 28, South Carolina SC visitor in FL passes out in drive-through One is supposed to drive through a drive-through, not stop at the ordering speaker and pass out. That’s what happened to a couple who apparently had a Big Mac attack in the Middle Keys Tuesday night and couldn’t make it out of the McDonald’s drive-through. It resulted in several criminal charges being filed. The Monroe County Sheriff’s Office says Kevin Yonson, 28, of South Carolina was behind the wheel of a white Ford with a woman in the passenger seat. They ordered food about 10:30 p.m. but didn’t drive up to the window to pay and get their meal. So a McDonald’s employee went outside to find out what was going on and saw them asleep in the car, still at the ordering speaker. He called the Sheriff’s Office. Deputy Christopher Schwartz wrote in his report that when he approached the car, he saw the “female asleep, mouth open, with drool coming down her face.” He tried to wake her but she “continued to sit with her eyes closed.” She finally woke up and “looked at me as if she had no idea where she was.” She then shook Yonson awake. Schwartz told her stand behind the car; by that time, Deputy Garrett Bragg already had Yonson at the back of the car. Both smelled of alcohol, Schwartz wrote. Bragg asked Yonson to go through a field sobriety test. At first he agreed, then decided not to. He got combative and was yelling, Schwartz wrote. The deputy wrote that Yonson resisted being handcuffed. At one point, Bragg and Sgt. Nick Whiteman “grabbed” Yonson and “secured” him against the car. Schwartz then tried walking him to his cruiser but Yonson “lost his balance and stated I pushed him over.” After a minor scuffle, the police got Yonson into Schwartz’s cruiser. Turns out that Yonson isn’t who he told police he was. He didn’t have a driver’s license and initially gave his last name as Johnson, then admitted to who he really is. Turns out Yonson is a registered sex offender in West Virginia stemming from a Feb. 9, 2015, conviction there. He hadn’t registered in Monroe as a sex offender, as required by law. He also has three drunk-driving convictions in South Carolina, one in 2008 and two last year. The woman was taken back to her hotel. Yonson, however, was booked into the county jail, where he remained Friday on $25,000 bond, charged with felony driving under the influence (fourth or subsequent offense), failing to register as a sex offender, resisting arrest, driving with a suspended license, battery on a law officer and giving false information to a police officer. He’s scheduled to go before Acting Circuit Court Judge Ruth Becker in Marathon on Oct. 27. ______________________________________________________ Tech Support Pits From Helga Re: Goto link in spreadsheet Dear Webby, I'm glad to have finally found a spreadsheet guru again! How do I make goto links to jump to far away cells in a spreadsheet? I used to know how to do it with DOS spreadsheets, but those tricks don't work any more. What do I do for making Got-To buttons in Excel? Thanks, Helga Dear Helga Yes, when the spreadsheet makers started to cater to the mouse addicts and reduce productivity, a lot of old tricks were lost. Now, for a GoTo you have to first name the destination. I usually just name a cell that has no numbers in it near the place I want to jump to. To name it, put the cursor intom that cell, and look at the top left, where Excel shows you the name of the cell, for example D120. Click in there and type a nickname for that area, for example October. That's all tehre is to nameing a destination. Now go to where you want the Go-To button. If you have a fixed header row, that does not scroll, for column headers, -a DEFINITE Must-Have for pros-, put your elevator buttons in there. If you want, you can put a small icon in there. Put the cursor on it, and hit ALT I, i Then you get a confusing looking window. It is quite simple once you stop panicking. Select the middle row, Place in existing document Now type the destination cell number where it tells you to. (Second line from the top) If the destination is on a different sheet, use the directory tree there to select the sheet and the right button. That is all there is to it. If you want more than just 3 Worksheets, like you have the A to ZZ worksheets in Quattro, just hit ALT I, w, or click on Insert, Worksheet That way you can have for example a top sheet for a year, and 12 monthly sheets. If anybody wants to know the top secret way to show data from one of the other sheets in the stack, for example show the total expenses result in Worksheet 11 (October) on the Annual Roundup (Worksheet 1), I'll tell you tomorrow. Have FUN! DearWebby "When you exit this vehicle, please lower your head and watch your step. If you fail to do so, please lower your voice and watch your language. Thank you."
If you can help with the cost of the Humor Letter, please donate what you can!
Daily tip from Thriftyfun.com Expandable Garden Hose Review By Litter Gitter [185 Posts, 613 Comments] When I heard about the expandable garden hose, I was not impressed. I didn't think there would be much to it. However, three years ago, I saw one in Bed Bath and Beyond and decided to purchase it. It is one of the best buys I have ever made. I really enjoy using it. It stretches out to 50 feet. It is light weight and does not tangle. It makes washing the car, the siding on the house, and cleaning out the gutters much easier. After I use it, I open the hose nozzle for the water to drain out. As it drains, the hose crawls as it shrinks. When the water is no long coming out, I remove the heavy nozzle and hang the hose to dry. I keep it in the utility room out of the weather. "Expandable Garden Hose, the hose that grows". It would make a great Christmas gift.
Ophelia Dingbatter's News
No sermon and not suitable for church, just jokes and fun for grownups. Read it on-line or subscribe. If you subscribe, look for the double opt-in confirmation request.
While meeting with a client he wished to impress, a big executive flipped on his intercom and barked to his secretary, "Miss Jones, get my broker on the line." "Yes sir," came back a voice, "stock or pawn or marriage?"
cutest koala bears (thanks to //the Bausell Sailor)
____________________________________________________ A car was involved in an accident. As one might expect, a large crowd gathered. A typical newspaper reporter, anxious to get his story, pushed and struggled to get near the car. Being a clever sort, he started shouting loudly, "Let me through! Let me through please! I am the son of the victim." The crowd made way for him. Lying in front of the car was a donkey. ____________________________________________________ A certain little girl, when asked her name, would reply, "I'm Mr. Sugarbrown's daughter." Her mother told her this was wrong, she must say, "I'm Jane Sugarbrown." The Vicar spoke to her in Sunday School, and said, "Aren't you Mr. Sugarbrown's daughter?" She replied, "I thought I was, but mom says I'm not". ____________________________________________________
Fantastic photos that look like paintings!
____________________________________________________
Today on October 13 in
1775 The U.S. Continental Congress ordered the construction
of a naval fleet. 

1792 The cornerstone of the Executive Mansion was laid in
Washington, DC. The building became known as the White House,

after the Canucks had burned it in 1812 and it was
subsequently whitewashed in in 1818. 

1812 American forces were defeated at the Battle of
Queenstown Heights. The British victory effectively ended
further U.S. invasion of Canada. 

1843 B'nai B'rith, the Jewish organization, was founded by
Henry Jones and eleven others in New York City, NY. 

1854 The state of Texas ratified a state constitution. 

1943 During World War II, realizing the obvious winner, Italy
switched sides, signed an armistice with the Allies and
declared war on Germany. 

1944 American troops entered Aachen, Germany, during World
War II. 

1944 During World War II, British and Greek advance units
landed at Piraeus. 

1951 In Atlanta, GA, a football with a rubber covering was
used for the first time. Georgia Tech beat Louisiana State
25-7. 

1953 An ultrasonic burglar alarm was patented by Samuel
Bagno. 

1957 Bing Crosby and Frank Sinatra introduced the Ford Edsel
on an hour long special. 

1960 The World Series ended on a home run for the first time.
Bill Mazeroski's homerun allowed the Pirates to beat the
Yankees. 

1981 Egyptian voters elected Vice President Hosni Mubarak as
the new president one week after Anwar Sadat was
assassinated. 

1989 U.S. President George H.W. Bush called for an overthrow
of the Panamanian ruler Manuel Antonio Noriega. 

1992 A commercial flight record was set by an Air France
supersonic jetliner for circling the Earth in 33 hours and
one minute. 

1995 Walt Disney World Resort admitted its 500-millionth
guest. 

1998 The National Basketball Association (NBA) canceled
regular season games, due to work stoppage, for first time in
its 51-year history. 

1999 The U.S. Senate rejected the ratification of the
Comprehensive Test Ban Treaty (CTBT). 

2010 Near Copiapó, Chile, 33 miners were trapped underground
in San José Mine. The miners were rescued after 69 days
underground. 

2016  smiled.


[ view entry ] ( 3 views )   |  permalink  |  print article  |   ( 3 / 796 )

<<First <Back | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | Next> Last>>