Keyboard shortcuts allow you to do things with your keyboard instead of your mouse to increase your speed. Basic Select cell B2. 1. To select the entire range, press CTRL + a (if you press CTRL + a one more time Excel selects the entire sheet). 2. To copy the range, press CTRL + c […]
This example describes how to create dependent drop-down lists in Excel. Here’s what we are trying to achieve: The user selects Pizza from a drop-down list. As a result, a second drop-down list contains the Pizza items. To create these dependent drop-down lists, execute the following steps. 1. On the second sheet, create the following […]
Drop-down lists in Excel are helpful if you want to be sure that users select an item from a list, instead of typing their own values. 1. On the second sheet, type the items you want to appear in the drop-down list. 2. On the first sheet, select cell B1. 3. On the Data tab, […]
This example teaches you how to use data validation to prevent users from entering incorrect product codes. 1. Select the range A2:A7. 2. On the Data tab, click Data Validation. 3. In the Allow list, click Custom. 4. In the Formula box, enter the formula shown below and click OK. Explanation: this AND function has […]
This example teaches you how to use data validation to prevent users from entering duplicate values. 1. Select the range A2:A20. 2. On the Data tab, click Data Validation. 3. In the Allow list, click Custom. 4. In the Formula box, enter the formula shown below and click OK. Explanation: The COUNTIF function takes two […]
This example teaches you how to use data validation to prevent users from exceeding a budget limit. 1. Select the range B2:B8. Note: cell B10 contains a SUM function that calculates the sum of the range B2:B8. 2. On the Data tab, click Data Validation. 3. In the Allow list, click Custom. 4. In the […]
There might be certain contacts you want to know instantly if they are calling or messaging you. To make sure they don’t blend into the crowd, you can change their specific alert tones so you recognise when that particular person has sent you a message or is WhatsApp calling you. iOS & Android: Chats > […]
There is nothing more annoying than seeing those blue ticks appear without a reply following soon after. If you want to torture yourself a little more and find out when your message was actually read and how long you’ve been ignored for, you can. We don’t advise it though. iOS: Chats > Specific chat > […]
how to Send a public message privately in whatsapp. Ever had a free evening and wanted to ask several of your friends if they are around without having to open up each chat to ask them seperately? You can send a broadcast message to a list of contacts with it appearing as though you’ve asked […]
Some messages are more important than others. Whether it’s a date you need to remember, or a good restaurant you’ve been recommended. It’s possible to bookmark these messages and find them all easily in the Starred Messages section. iOS: Chats > Specific chat > Specific message > Double tap or hold down and press the […]
How to Get shortcuts to specific conversations Do you have a few extra special people you talk to all the time via WhatsApp? We do too. You can create a shortcut for specific conversations on Android, making it easier to access those chats you need all the time. Android: Chats > Specific chat > Menu […]
Hide your profile pictureYou might not want everyone to see your profile picture, especially if you’re part of several groups where you don’t know everyone in the group. perhaps you just fancy being a little mysterious for the day. Either way, you can choose if everyone, no-one, or only your contacts see your picture. iOS […]
Ever passed your phone to a friend and instantly panicked about the messages they might see come through? Yeah, we haven’t either. For those that have, you can turn off message preview on iOS so only the contact’s name will appear, rather than their life story. In Android, it’s not possible through the WhatsApp app […]
Save your data allowance If you’ve got a limited data allowance, you don’t want WhatsApp munching it all away. Thankfully, you can customise when media is allowed to download, as well as ensure calls use as little data as possible. iOS and Android: Settings > Data Usage .
Ever been out and about, read a chat and then completely forgot to reply? We do it all the time. There is a way to mark important chats with dot to remind you to go back to it though. iOS: Chats > Swipe left to right > Mark as Unread Android: Long press chat > […]
Who is really your favourite person? It might not be who you think. On iOS, there is a way to find the people you send the most messages to and how much storage each person takes up, among other things. iOS: Settings > Account > Storage Usage > Select Contact.
Those blue ticks can get you in a whole world of trouble, especially when you don’t reply instantly and someone sees you have read their messages. You can turn them off, but it’s worth noting that if you do, you won’t get read receipts for your messages either. iOS: Settings > Account > Privacy > […]
If you enable mobile template for your blog, here is a good news, you can now customize your mobile site to your own personal taste using CSS definitions. You will able to decide which widget is to be displayed in mobile site and which one shouldn’t. You can also configure a widget to appear on […]
This example teaches you how to use data validation to reject invalid dates. 1. Select the range A2:A4. 2. On the Data tab, click Data Validation. Outside a Date Range 3. In the Allow list, click Date. 4. In the Data list, click between. 5. Enter the Start date and End date shown below and […]
Use data validation in Excel to make sure that users enter certain values into a cell.Data Validation Example In this example, we restrict users to enter a whole number between 0 and 10. Create Data Validation Rule To create the data validation rule, execute the following steps. 1. Select cell C2. 2. On the Data […]
