Your Business Quick Tip Newsletter
Vol 21 No #211 – 13th May 2022

---

Two Lovely & Useful Windows Key “Opening” Shortcuts

1. 1. 1. Window & No# Key
         If you’ve pinned programs to your Taskbar (you can tell by the little icons that you can quickly open them with the Windows key + Number key.The number corresponds to location of the icon – first, second, third etc. So, , Windows key + 2 will open the second item on the Taskbar
      2. To launch a new app,
         Hit the Window Key and start typing the name of the app. It will pop up and you can click it. In Mac – Command + Space

---

Keeping the Cell Phone Zero in Excel and Google Sheets

What is your workaround for keeping cell phone numbers in your spreadsheets? Typing in the letter O? Adding spaces?

Instead, you can force Excel and Google Sheets to display placeholder 0 digits by applying a custom format. Here’s how:

Excel

1. Select the cell, range or column.
2. Home Ribbon > Number Menu select the Drop down arrow (it probably will say General);
3. Select More Number Formats > Custom.
4. Type in the number of zeros that comprise the entire cell phone number
5. For example my phone number is 0275755359. So you’d need 10 zeros.

Google Sheets

1. Select the cell, range or column.
2. Select Format on the Menu
3. Select Number > Custom Number Format
4. Type in the number of zeros that comprise the entire cell phone number.
5. For example with 0275755359 you’d need 10 zeros.

---

Password, Passwords – just a timely reminder

Once again compromised logins and passwords are in the news, here in New Zealand the AA has notified that it has one of its sites breache, so here are 5 tips for you to remember.

1. Do not reuse/recycle passwords
2. Do not make them easy to guess
3. But make them easy to remember,
   – For example: instead of  P@SsT5y&R something like Get’s.Go.When!
4. Change them regularly
5. And finally use a Password Manager and 2FA (Two factor Authentication) for key sites.

You can also check to see if you’re part of a known breach by going to https://haveibeenpwned.com

---

If you like either of these tips – please:

1. Call on +64 27 575 5359, or email me at debbie@successis.co.nz for a lovely quote on training or conference presentations 
2. Refer your friends to the quick tip newsletter https://debbiespeaks.com/newsletter/newsletter-sign-up/