40 Excel Shortcuts You'll Definitely Want to Bookmark

Navigation

These simple shortcuts can help you navigate between workbooks, sheets, rows and columns.
Shift + Enter (PC and Mac) = Move up through a selection
CTRL + ↑ (PC); Command + ↑ (Mac) = Jump to the top of a column
CTRL + ↓ (PC); Command + ↓ (Mac) = Jump to the bottom of a column
CTRL + . (PC and Mac) = Jump to the corner of a selection (Note: Rotate to each corner by repeating this keystroke)
CTRL + w (PC); Command + W (Mac) = Close the active workbook window
CTRL + Shift + F6 (PC); Command + Shift + F6 (Mac) = Switch to previous workbook window
CTRL + Tab (Mac only) = Switch to the next open worksheet
CTRL + Shift + Tab (Mac only) = Switch to the previous open worksheet (Mac)
F11 (PC and Mac) = Start a new chart sheet
Shift + F11 (PC and Mac) = Insert a new sheet
CTRL + y (PC); Command + Y (Mac) = Repeat the last action
CTRL + d (PC and Mac) = Fill selected cell with the content in the cell above selected cell
CTRL + r (PC and Mac) = Fill selected cell with the content in the cell to the left of selected cell

Formatting

Formatting in Excel can be difficult if you don't know of what you're doing. Here are a few shortcuts that to help you easily format your cells.
CTRL + F (PC); Command + F (Mac) = Find and replace values
CTRL + Shift + % (PC and Mac) = Show all values as percentages
CTRL + Shift + $ (PC and Mac) = Show all values as currency (Note: Replace $ with your own country's currency key)
CTRL  + Shift + ~ (PC and Mac) = Show all values in general number format
CTRL + Shift + & (PC); Command + Option + 0 (Mac) = Apply an outline border to selected cells
Here's what cells look like with (left) and without (right) a border:  
        









CTRL + 2 (PC); Command + b (Mac) = Apply or remove bold formatting to selected cells
CTRL + 3 (PC); Command + i (Mac) = Apply or remove italic formatting to selected cells
CTRL + 9 (PC and Mac) = Hide selected rows
CTRL + Shift + ( (PC and Mac) = Unhide selected rows
CTRL + 0 (PC and Mac) = Hide selected columns
CTRL + Shift + ) (PC and Mac) = Unhide selected columns
CTRL + ; (PC and Mac) = Insert current date
CTRL + Shift + : (PC); Command + ; (Mac) = Insert current time
CTRL + k (PC); Command + k (Mac) = Insert a hyperlink

Selecting Rows & Columns

Save yourself the manual dragging and selecting rows and columns with these handy keyboard tricks.
Shift + ↑ [or] Shift + ↓ (PC and Mac) = Expand the selection by one cell either upward (↑) or downward (↓)
CTRL + Shift + Arrow Key (PC); Command + Shift + Arrow Key (Mac) = Expand the selection to the last non-empty cell
CTRL + [spacebar] (PC and Mac) = Select entire column
Shift + [spacebar] (PC and Mac) = Select entire row
CTRL + a (PC); Command + a (Mac) = Select entire sheet
Alt + ; (PC); Command + Shift + z (Mac) = Select only the visible cells in the current selection

Formulas

Formulas are a huge part of every marketer's Eccel toolkit. Here are a few shortcuts that'll make you a formula wiz.
= (i.e. press the "equals" sign; PC and Mac) = Start a formula (e.g. "=A4+A5")
Alt + (PC); Command + Shift + t (Mac) = Insert AutoSum formula
F2 (PC); CTRL + u (Mac) = Edit active cell
CTRL + a (PC and Mac) = Display the Formula Builder after you type a valid function name in a formula

Miscellaneous

Here are a few more time-saving shortcuts.
F7 (PC and Mac) = Open spelling & grammar check
Shift + F2 (PC and Mac) = Insert a comment

Control + Shift + s (PC); Command + Shift + s (Mac) = Save your work as

Yahoo doesn't accept cellphone number?

Recently I have big issue with yahoo. I need a couple of newest accounts at yahoo to test.
Since a while, yahoo asks for cellphone number to complete the registration process.
A verification code will be sent by yahoo to this number and you have to type this code on the webpage.
I found a lot of trash cellphone numbers. Just like trash Email addresses, these numbers can be used by anyone but the sms texts including history can be read by anyone as well.

http://vsimcard.com/free_cards.php for instant.
I used the number 004917679801863 to set up a new account.
Sadly yahoo told me this is not a valid cellphone number.

If I review the history...

Sender	Date	Content
447781470659	03/11/2015 11:05:52	7699 ist Ihr Bestätigungscode von Yahoo
447781470659	03/11/2015 09:51:04	8635 is your verification code from Yahoo
447781470659	03/11/2015 00:11:02	0697 ist Ihr Bestätigungscode von Yahoo

at least this number has been used for setting up new accounts only by today.

which means,

• This number is active. Yahoo has accepted it.
• The same number can be used more than once.
• The same number can be used more than once on the same day.

Here is the question: is 3 times the limit for the same number?

Mobile phone

It's extremely important to keep your contact info up-to-date because it's one of the ways that we protect your account security. If you forget your password, you can easily reset it with your mobile number and get back into your account. If you don't provide a supported mobile number, you'll be unable to complete registration.
We also collect an optional phone number in the event you don't have access to your mobile so that we can call or send a text if you lost account access.

Yahoo doesn't say how often one single number can be used.
However, I found the following code in the quell text.

//SMS
    SMS_STATUS_99                           : 'Es ist ein Fehler aufgetreten. <a href="/registration">Bitte versuchen Sie es erneut.</a>',
    SMS_STATUS_101                          : 'Es ist ein Fehler aufgetreten. <a href="/registration">Bitte versuchen Sie es erneut.</a>',
    SMS_STATUS_106                          : 'Dies ist keine gültige Handynummer.',
    SMS_STATUS_107                          : 'Sie haben die Höchstgrenze für SMS erreicht. <a href="/registration">Bitte versuchen Sie es erneut.</a>',
    SMS_GENERIC_ERROR                       : 'Es ist ein Fehler aufgetreten. <a href="/registration">Bitte versuchen Sie es erneut.</a> ', 

Was is the meaning of SMS status 106? I am neither a deliverability expert on SMS nor a yahoo guru...

It seems, yahoo must try to send SMS to this number but without success.

Who knows more about it? Otherwise, I will keep on testing to find out a solution.

Trackbuster untracks commercial emails at Gmail

A tracking pixel is like a tiny picture, normally being (un)seen on the left side of the bottom of an email.
Once an Email has been opened and the pictures have been loaded, this tracking pixel, which had been implanted by the Email marketers, will tell them: this mail has been opened

Since an open might generate a lead or even a buy, the open rate of a Emailing campaign becomes a huge factor.

Trackbuster is now working with Gmail to untrack the commercial emails.
This service will analyze the incoming emails at Gmail, identify the invisible tracking pixel and remove them. For the paranoid internet users, it shall protect their privacy.

I tried this tool and it works

I don't know how perfect it can be. But the opens, which the marketers track, will be even less at Gmail.

Gmail has a new release! New analytics tool with smart dashboard

Google launched its Gmail Postmaster Tools, which allow the qualified high-volume senders to get a better idea of how Gmail treats their emails.

The tool shall show lots of deliverability informations in different dashboards.

Once the domain ownership has been verified, the qualified senders can monitor the Email delivery to the biggest ISP of the world.

Sogou mail will be closed soon

On the login page to Sogou webmail, we now find an official announcement that Sogou will stop providing Email service by 30th of September 2015.

Since December 2014, the registration to a new Email account at Sogou has already been closed. 
The existing mail addresses @sogou.com will be still active until 31st of March 2016, once a user chooses the service provided by Sohu to relocate his address to Sohu. The mails to Sogou old address will be sent forward to the Sohu address automatically. Meanwhile the user can also send his mails by using Sohu mail.

The relocation is quite easy. Sohu webmail has now the new feature "relocating by one click".
The account and password of Sogou mail are asked, then press the yellow button "relocating by one click". After 48h, all of the history mails can be read at Sohu.

If the relocation hasn't been set up manually until 31st of March 2016, a new sohu account will be created by Sohu system to continue providing Email service.

new link for the removal of Outlook IP block

Since a couple of weeks, I can't open the support page

https://support.msn.com/eform.aspx?productKey=edfsmsbl2&ct=eformts

at Outlook for mitigation the IP reputation.
If an IP is supposed to be blocked by Microsoft, it might help removing it from the blocklist.
It was an automatic process. Once we fill out the formulas and press "submit" button. Then the guys at outlook will review the IP reputation. They decide if this IP will be further blocked or the block will get lifted.

But the link above relinks now to another support page, which is useless for lifting a block.
What bad news.

Do you have the same issue? Don't worry, I found the new link for it and share here with you

https://support.microsoft.com/en-us/getsupport?oaspworkflow=start_1.0.0.0&wfname=capsub&productkey=edfsmsbl3&locale=en-us&ccsid=635639051175184163

Case study 33iq -- SendCloud (part1)

33iq, meaning of showing how smart you are, is the biggest SN (social network) in China focusing on brain teasers.
I love solving puzzles, so I registered myself as a user.
Then I found out that they are doing quite incredible Email Marketing. To be honest, I never thought that the Email Marketing can be so highly developed in main land China.

I neither can nor want to know the total marketing operation of 33iq exactly. I am only interested in Emails, so I'd like to talk about it from the EM (Email Marketing) perspective and my point of view.

On the homepage, I can find the button to login and register easily on the right side of the head. They are sized big and clearly.

After I roll down this page, a banner pops up at the bottom, which stays from then on until the foot of this page to let you sign up using other social network IDs. Of course the biggest ones in China: QQ and weibo.

I don't know if they tested the best side of webpage to have their lead registration buttons, before they put them in these places, but very standard and pretty smart.

The registration process is not difficult. Email address is asked.

I like the slide verification, although it's not widely used. In my opinion, it's much better than typing unreadable letters or numbers.

Thanks to SendCloud, the confirmationsemail came immediately and landed in the primary tab at Gmail.

No, not the shipping company from Netherlands. SendCloud is a young but leading ESP (Email Service Platform) made by Sohu in China.

The sender has a name and is a postmaster, which is unusual but okay.

The content is clear and targeted, without a single advertising.

And there is a sidebar(!!)

Strict DOI (double Opt-in)

I digged deeper to read the header of this Email

Delivered-To: kenatexperian@gmail.com
Received: by 10.182.24.169 with SMTP id v9csp506700obf;
        Thu, 23 Apr 2015 07:42:56 -0700 (PDT)
X-Received: by 10.68.65.111 with SMTP id w15mr5887472pbs.57.1429800175793;
        Thu, 23 Apr 2015 07:42:55 -0700 (PDT)
Return-Path: <05561b10-e9c7-11e4-8020-00163e62bc6d@mail10.sendcloud.org>
Received: from mail36.sendcloud.org ([101.227.180.36])
        by mx.google.com with ESMTP id sj10si12766109pac.198.2015.04.23.07.42.52
        for <kenatexperian@gmail.com>;
        Thu, 23 Apr 2015 07:42:54 -0700 (PDT)
Received-SPF: pass (google.com: domain of 05561b10-e9c7-11e4-8020-00163e62bc6d@mail10.sendcloud.org designates 101.227.180.36 as permitted sender) client-ip=101.227.180.36;
Authentication-Results: mx.google.com;
       spf=pass (google.com: domain of 05561b10-e9c7-11e4-8020-00163e62bc6d@mail10.sendcloud.org designates 101.227.180.36 as permitted sender) smtp.mail=05561b10-e9c7-11e4-8020-00163e62bc6d@mail10.sendcloud.org;
       dkim=pass header.i=@sendcloud.org
Message-Id: <553904ee.aae4420a.7d08.355eSMTPIN_ADDED_MISSING@mx.google.com>
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=sendcloud.org; i=@sendcloud.org;
 q=dns/txt; s=mail; t=1429800172; h=Sender : To : From : Subject : Date
 : Content-Type : Content-Transfer-Encoding : MIME-Version : REPLY-TO :
 From : Subject : Date; bh=7ZxY9EvxGap9rMjKNYJEMQlD0hA1rP2s5hXlBsYwcHA=;
 b=jT2xifVevJQ3Nq+3TntMfiy7hhTgo4E09lmsdtObS6BNfNm/grjMGoUW3NUVtWsx3xiXzh
 +u9ZzWD1MwkEHlvJPzf6NP2PvIZKYPgQAzgITVKP25B90J6g6J4/VqIFSXjmNsJtY2Bw7Dp6
 F5pv7u6oO3Uk1bRjeZW8Ybl2n5NDY=
Sender:05561b10-e9c7-11e4-8020-00163e62bc6d@mail10.sendcloud.org
Received:from localhost ([115.29.201.198]) by SendCloud Inbound Server (Haraka/2.2.4) with ESMTPA id 6803468F-B1A2-483A-B966-12278E625757.1 envelope-from <postmaster@notice.33iq.com> (authenticated bits=0); Thu, 23 Apr 2015 22:42:51 +0800
To:=?GBK?Q?=D3=C3=BB=A7?= <kenatexperian@gmail.com>
From:33IQ <postmaster@notice.33iq.com>
Subject:=?GBK?B?uNDQu9eisuEzM0lRzfijrMfr0enWpEVtYWls?=
Date:Thu, 23 Apr 2015 22:42:50 +0800
Content-Type:text/html; charset="UTF-8"
Content-Transfer-Encoding:quoted-printable
Content-Disposition:inline
MIME-Version:1.0
REPLY-TO:33IQ <postmaster@notice.33iq.com>
X-SENDCLOUD-UUID:1429800171967_21449_16810_2341.sc-10_10_127_51-inbound0$kenatexperian@gmail.com
X-SENDCLOUD-LOG:1429800171967_21449_16810_2341.sc-10_10_127_51-inbound0$kenatexperian@gmail.com#kenatexperian@gmail.com#64116#21449#0
X-SMTPAPI:

SPF and DKIM have been set up.

You can hardly believe how many IP addresses are used by SC. Who said, Ranges of IPv4 has been poorly assigned to Asia!

sendcloud 

45.56.67.250/32 (1 address) 

61.135.130.0/23 (512 addresses) 

61.135.132.0/23 (512 addresses) 

61.135.150.0/24 (256 addresses) 

61.135.178.0/23 (512 addresses) 

61.135.181.0/24 (256 addresses) 

101.227.178.0/23 (512 addresses) 

101.227.180.0/23 (512 addresses) 

103.249.252.104/31 (2 addresses) 

220.181.19.0/24 (256 addresses)

The DKIM signature is the most complicated I have ever seen.
Sadly the d for domain has been valued standard/default as sendcloud.org.
Shared pool maybe, easier to set up?

DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=sendcloud.org; i=@sendcloud.org;  q=dns/txt; s=mail; t=1429800172; h=Sender : To : From : Subject : Date  : Content-Type : Content-Transfer-Encoding : MIME-Version : REPLY-TO :  From : Subject : Date; bh=7ZxY9EvxGap9rMjKNYJEMQlD0hA1rP2s5hXlBsYwcHA=;  b=jT2xifVevJQ3Nq+3TntMfiy7hhTgo4E09lmsdtObS6BNfNm/grjMGoUW3NUVtWsx3xiXzh +u9ZzWD1MwkEHlvJPzf6NP2PvIZKYPgQAzgITVKP25B90J6g6J4/VqIFSXjmNsJtY2Bw7Dp6 F5pv7u6oO3Uk1bRjeZW8Ybl2n5NDY=

The sender IP 101.227.180.36 has at moment excellent senderscore. The rDNS has been set up.

Classified as moderate volume sender, it seems this pool has not been used consistently.
And yes, as I guessed a shared pool.

Sending Domains
info01.sendcloud.org
info02.sendcloud.org
mail.hibay.net
mail.joboto.com
mail.jubi.com
mail09.sendcloud.org
mail10.sendcloud.org
mail11.sendcloud.org
mass.mail.xiaoenai.com
triggermail.zyxd.net

usermail.okcoin.com

www.mangasearcher.com

xingyunvpn.com

Depends on the domain reputation, it may be now a good point to think about segmentation and separation of transnational emails.

Ohoh I feel like knowing a lot of business secrets by now :D

Let's stop here for now, next time, I will check the newsletters and share my founds with you.