JuicyAppleNews

Devices don’t connect to iPhone tethering: how to set 2.4 GHz instead of 5 GHz?

by

[ad_1]

All iPhone models from iPhone 12 can use the faster 5GHz Wi-Fi band to improve Tethering (hotspot) performance. But if your client devices are having problems with the 5 GHz band (not all devices support it), then you can always configure your personal hotspot to use the slower 2.4 GHz Wi-Fi band. In this tutorial, we’ll show you how to switch between 2.4GHz and 5GHz bands on an iPhone in Tethering.

 

 

Devices don’t connect to iPhone tethering: how to set 2.4 GHz instead of 5 GHz?

 

♥ BY THEME: How to recognize text from photos on iPhone without installing third-party applications.

Your Exposed

User IP: 54.36.149.88

User City: Roubaix

User Region: HDF

User Country: France

User Country Code: FR

Latitude: 50.6916

Longitude: 3.20151

Timezone: Europe/Paris

ISP: OVH SAS

Flag:

Invalid type

 

Get Protected Now Buy the best NordVPN discount Deal

Wi-Fi performance: 2.4GHz vs 5GHz

Prior to the iPhone 12 lineup, the Tethering feature was limited to the slower 2.4GHz Wi-Fi range. And even if you use a dual-band Wi-Fi router that supports both the 2.4 GHz and 5 GHz bands, your phone has always used the slower 2.4 GHz band for tethering.

The iPhone 12 models now support the high-speed 5G cellular network. When used, the speed can easily exceed the capabilities of 2.4GHz Wi-Fi. In this case, your iPhone will download data over 5G networks much faster than any clients tied to its hotspot, such as an iPad, your Mac or Windows PC, using a 2.4 GHz connection. Curiously, there is no mention of this feature on Apple’s website and company documentation.

Here are the main advantages and disadvantages of both Wi-Fi bands:

  • 2.4 GHz band: Slower data transfer, larger range, better compatibility.
  • 5 GHz band: faster data transfer, less range, less compatibility.

Thus, forcing the iPhone to take advantage of the faster 5GHz band will improve the AP’s performance, but there may be compatibility issues with some devices and routers.

iPhone 12 and later devices use the 5 GHz band by default for their hotspot functionality. If you experience interruptions or problems connecting to certain client devices, then switching your personal hotspot back to the 2.4 GHz band should fix any problems.

♥ BY THEME: How to reduce background noise in iPhone video calls (highlight voice).

How do I switch my personal hotspot between 2.4 GHz and 5 GHz?

You can switch between the 2.4 GHz and 5 GHz bands in the iPhone’s tethering settings:

1. Open the Settings app on iPhone 12 or newer Apple smartphone.

2. Tap the item “Modem mode” in the main list.

3. Activate the switch “Maximum compatibility”…

How to turn on 2.4GHz or 5GHz Wi-Fi in tethering on iPhone 12?

 

This will force your phone to use the slower but more compatible 2.4GHz band.

“Internet performance may decrease for devices connected to your access point when this switch is activated,” reads the feature description.

Actually, this is how the Personal Hotspot feature worked before the iPhone 12.

Conversely, deactivating the switch back tells your Apple smartphone to switch the personal hotspot to the faster but less compatible 5GHz band.

♥ BY THEME: How to blur background during video calls on iPhone (WhatsApp, FaceTime, Instagram, Telegram, etc.).

A few tips for working with Modem Mode

Keep in mind that the performance of a personal hotspot will vary depending on factors such as signal strength, distance between the connected device and your iPhone, the type of Wi-Fi range used, the number and thickness of walls, other obstructions, and more. Interestingly, the Personal Hotspot also works through the Lightning port. This is handy if you want to connect to your Mac or Windows PC for a faster, more reliable wired connection.

You can turn on Tethering in the Settings app on your device. Keep in mind that some carriers require a separate data plan for the smartphone to work in this mode. Personal Hotspot requires Wi-Fi and Bluetooth to be turned on on your iPhone and all client devices using this feature.

See also:

[ad_2]

U, I, O, J, K, L, M (Г, Ш, Ш, О, L, D) keys don’t work on Mac, what should I do?

by

[ad_1]

Have you noticed that not all buttons are pressed on the keyboard of your Mac (MacBook, iMac, Mac mini)? If only I, O, J, K, L, M (Г, Ш, Щ, О, Л, Д) “refused”, nothing terrible happened – the whole point is that you quietly activated the old function “Control keys” (formerly called Mouse Keys or “Mouse Keys”).

♥ BY TOPIC: Birthdays on iPhone, iPad and Mac: How to Add and Enable Reminders…

Why won’t my Mac keyboard type the letters U, I, O, J, K, L, M (G, W, Sh, O, L, D)?

The computer keyboard contains a lot of outdated elements from the 20th century, when people still used typewriters and mechanical calculators. For example, the key ⇧Shift was originally conceived to literally bring up the typesetting of a typewriter, but now it is used to switch from lowercase (small) to uppercase (large).

Shift

Well, today, it seems, everyone already knows that when entering a password it is better not to press the Caps Lock key – Apple computers even have a corresponding warning.

The Num Lock key was the product of an “in-between” era, when mechanical and numeric keys coexisted peacefully with each other. Some IBM computers did not have arrow keys, but there was a separate numeric block for quickly entering numbers.

Over time, IBM figured out how to combine these two functions. The Num Lock button blocked the dialing of numbers and turned the “number” keys into “arrows”. With their help, it was possible to move the cursor on the screens of computers that did not yet know the mouse.

On some laptops, including older Macs, Num Lock had a different feature. There he turned part of the keyboard into a pseudo trackpad. This role was assigned to the buttons U, I, O, P, J, K, l, semicolon, M, period and slash (slash). Num Lock was turned on on such computers by pressing the F6 button. Apple stopped supporting Num Lock on F6 in 2008. True, it is still available on some laptops in Boot Camp mode (on which ones, Apple does not say). An independent developer who disagreed with this decision by the Cupertinians created the NumLock application “to return everything as it was” for Mac OS X, but has not updated it in several years.

♥ BY TOPIC: How to quickly open recently closed tabs in Safari on Mac – three ways.

State of the art

Apple, in fairness, hasn’t forgotten about this feature at all since IBM. It is now available as settings Accessibility entitled Control Keys (invoked by the keyboard shortcut ⌥Option (Alt) + Command (⌘) + F5).

U, I, O, J, K, L, M (Г, Ш, Ш, О, L, D) keys don't work on Mac, what should I do?

You can also activate it along the way System Preferences → Accessibility → Pointer Control → Other Controls tab…

Accessibility in Mac System Preferences

U, I, O, J, K, L, M (Г, Ш, Ш, О, L, D) keys don't work on Mac, what should I do?

As a result, the numbers on the keyboard with the numeric block turn into “arrows”. In order to “click” with such a “mouse”, press the number 5, to press and hold, press 0, to release, press the point. If you use an Apple laptop keyboard or a regular keyboard without a numeric keypad, the keys of the times of IBM turn into an “arrow” cursor – 7, 8, 9, I, O, P, J, K, L, M and the dot play the same role, as 789/456/123/0 on the numeric keypad (details).

How to control the mouse pointer with the Mac keyboard (macOS)

♥ BY TOPIC: How to hide files and folders on Mac (macOS) from strangers: 3 ways.

How to disable the Control Keys function

There are three options – by calling the Accessibility window (⌥Option (Alt) + Command (⌘) + F5), through the settings (section “Pointer Control”) or pressing the ⌥Option (Alt) key 5 times, after which a corresponding notification will appear on the screen.

However, it is worth noting that pressing the ⌥Option (Alt) key five times will only work if the corresponding checkbox is checked in the settings “Pointer Control”…

U, I, O, J, K, L, M (Г, Ш, Ш, О, L, D) keys don't work on Mac, what should I do?

See also:

[ad_2]

How to learn to make a decision so you don’t regret it later

by

[ad_1]

Forks are constantly encountered on our path in life. They give you the opportunity to make a certain decision and change your life, or leave everything the same. We change partners, work, place of residence, lifestyle, clothes, and even our body. Unfortunately or fortunately, it remains a mystery – how could life change due to a different decision?

And does he exist, that very ideal and correct path? Psychologists advise not to hope for the right decision and not to wait for the right moments. You just need to evaluate your choice in terms of potential benefit or harm. You can give five tips that will help you not to miss the chance of your life and pay attention to it.

♥ BY TOPIC: Why goosebumps appear on the skin, why fingers wrinkle from water and other unusual facts about the human body.

There is no perfect opportunity

People often wait for the right moment to do a certain thing. However, everyone has their own idea of ​​the ideal. You can draw an analogy with the work of abstractionists, in which each viewer will find something close to himself. Is there an ideal moment or opportunity? Even speaking about the work and its conditions, people will name their different criteria. First, you need to understand for yourself what exactly the right decision is and what clear definitions it has.

When it comes to employment, then you can ask questions of workload, involvement, payment. It may turn out that the ideal job in general would seem to be caring for exotic birds on distant islands in the ocean. Psychologists believe that if the given chance is at least 60% in line with the given criteria, then it is worthy of consideration. In other words, if, for a decent payment, they invite you to look after the birds at the local zoo, you should agree, and not wait for the perfect offer.

♥ BY TOPIC: Holland and the Netherlands: what’s the difference and what is the correct name?

Define the limits of possible freedom

Life decisions tend to change the way we are used to. We can reassure ourselves that the change is clearly for the better, but it will also cause discomfort. So, dream job offers most likely implies maximum immersion in it. But will there be time for your family? Making the right decision can lead to frustration. To prevent this from happening, when choosing a job, it is worth identifying the following priorities:

  • distance to home;
  • wage;
  • type of occupation;
  • the degree of employment.

For each item, it is worth setting some framework that you do not want to break. This will make the decision easier. For example, a desired job should be half an hour away from home, a salary is needed at least $ 1,500 a month, live communication with clients is of interest and there is no fear of overworking until late. A clear definition of the boundaries for each of these points will allow you not to waste time considering inappropriate options. They violate the established framework of freedom and are not able to become the right decision.

♥ BY TOPIC: Motivating quotes from billionaires.

Don’t wait for the perfect opportunity – create yourself

Only in fairy tales a kind wizard suddenly appears to the heroes and fulfills all their wishes. In life, patiently waiting for your chance for an ideal job or for the right partner will most often lead to nothing but disappointment. It is worth getting up and taking steps towards your dreams. Have you always dreamed of becoming an artist? Why not get some brushes and an easel and sign up for a painting course? You can try to exhibit your work at least at small or avant-garde exhibitions. If you want to find your soul mate, then you should make friends of the opposite sex, go on dates and meet. This is more likely to achieve a result than simply waiting for a person whose image is a puzzle assembled from fantasy.

♥ BY TOPIC: Warren Buffett’s 5/25 rule – highlighting the most important things in life.

Listen to your body’s signals

We may not always be aware of certain perspectives in the brain, but our body will already give signals of erroneous actions. So, sleepiness, weakness and fatigue do not necessarily indicate a busy work schedule. It is likely that this is a signal from the body about an inappropriate occupation for it.

On the other hand, if the relationship develops and the work is enjoyable, then the body will feel better. We have all experienced slight tremors and pleasant impatience before starting a new phase in our lives. This can be compared to the joyful anticipation of a child who will have another birthday tomorrow.

♥ BY TOPIC: How to learn to memorize information better than others: 9 effective tips.

Start small

Often people are waiting for a chance at something big, which will make them dive headlong into an important project. But before you get involved in the work of your whole life, you should first study it and start small. If you want to become an artist, you don’t have to try to create huge canvases on the whole wall. To prove yourself, you can start with small sketches, miniatures, portraits. Studying the intricacies of the skill will allow you to understand future steps towards the desired goal. If, at the very beginning of your journey, you are guided by high expectations, then this can only cause pain of disappointment.

See also:

[ad_2]

Don’t look for the perfect partner, or 7 signs of a strong relationship you don’t need to end

by

[ad_1]

Any girl dreams of a prince on a white horse, guys – of a beautiful princess. Of course, this is just a reference to fairy tales, life is much more prosaic. Nevertheless, somewhere in the depths of the subconscious, there remains a desire to find the ideal partner. And for some reason, the idea of ​​him does not correspond in any way to those people who meet in life. In reality, next to us there will be an ordinary person, with his own merits and demerits – the ideal will probably remain unattainable. There are several signs that make it possible to consider the existing relationship quite normal and natural.

♥ BY TOPIC: What is better to say to a person instead of the banal “don’t worry” or “don’t worry.”

Coincidence of views on life

And again you can remember the beautiful phrase “opposites attract each other.” In reality, partners in a relationship should want about the same thing. This applies both to general views on life and the world around (it is stupid to quarrel in the family because of politics), and to far-reaching personal plans: acquiring a house and a car, having children, and approaching upbringing. It will be difficult to keep the peace if one partner relies entirely on homeopathy and the other believes in scientific approach and traditional medicine. On the other hand, it happens that a man loves hiking and playing guitar by the fire, while a woman prefers a cozy bed and a hot bath before bed. It is premature to call it a catastrophe – there are no one hundred percent coincidences, and differing interests are permissible within the framework of the same provision of personal space to each other.

♥ BY TOPIC: 9 things to do before age 30

Mutual trust

Couple in love

Personal space can be provided to each other only if there is absolute trust and mutual understanding in the couple. However, these are generally fundamental things for a healthy relationship. Today, the rule “jealous means love” is considered by very few people to be relevant. Jealousy is based precisely on mistrust, suspicion, and possessiveness. If you start searching your partner’s pockets, reading his correspondence in a desire to find something spicy there, then something goes wrong in the relationship.

♥ BY TOPIC: How to know if you are wasting your life: 13 signs.

The right to privacy

It is no coincidence that after a while, men begin to literally demand a little personal space. Women, even unwittingly, are trying to control the time and thoughts of their chosen one. Personal space is necessary for everyone. Only there it will be possible to create a free atmosphere in which there is a place not only for suppressive relationships. The creation of a couple by two people does not at all mean that they now have to be inseparable throughout the day, share common interests and walk together everywhere.

Let everyone have the opportunity at least sometimes to be alone, meet friends, take time for their hobbies, or just take a walk. And some healthy couples even spend their holidays separately. This separation can be an original way to strengthen a relationship.

♥ BY TOPIC: How many calories do a man or woman need per day to lose weight, how to calculate.

Equal contribution to relationships

Some couples say that one partner loves, and the other allows himself to be loved. Some people think that this is how relationships are built. But in the end, while someone sacrifices everything, the other only reaps the benefits, not noticing the efforts of the partner. There was even an opinion that it was the woman who should work on the relationship, creating the very “weather in the house.” Conflicts must be ironed out, compromises must be found on both sides.

The statement that relationships are hard daily work on the part of both partners sounds too pretentious. Ideally, everything should happen naturally. But even if someone is working on this alone, this is also overkill.

♥ BY TOPIC: Who has the most followers on Instagram – 40 most popular accounts.

Constant dialogue

Couple in love

Quite often, quarrels in a couple arise according to the scenario: “I thought it up myself, I got offended myself.” It is not worth hushing up problems, sometimes your partner, even the most ingenious, has no idea what you are holding in your head. Avoiding dialogue will not help a healthy relationship in any way. An important principle of a good family and a long and happy life is precisely the ability to communicate with each other and find compromises. This applies to both the discussion of a banal delay at work (you can explain your anxiety, and not make a scandal), and planning global things.

♥ BY TOPIC: What are the sousseki, why the legs are chicken, not chicken, and what is the bast hut made of: words from fairy tales, the origin of which you might not know.

Partners don’t try to change each other

People are often unhappy with their partner, and this is observed regardless of his gender. Eternal claims translate into attempts to change a person to fit their patterns. First, it all starts with the appearance and wardrobe, which can still be understood, but then we can talk about changing character traits. The wife wants to see her husband more responsible, and he wants her more docile.

But everyone knows for a long time that such attempts to “break” an adult will end in fiasco. It is easier to initially find someone who suits you than to try to change someone who was initially a stranger to you, making both him and yourself unhappy.

♥ BY TOPIC: Ideal weight for women and men: how to determine with medical formulas: 5 methods.

Feeling safe

Relationship security plays an important role. It refers not only to the physical sphere, but also to the emotional one. Many still believe that a woman should be wary of her husband – the head of the family. Hence the anecdotes about the car scratched by his wife or unnecessary expenses that will lead to the anger of a man. Jokers advise to play up the situation and not stir up a scandal by hiding the truth. In fact, the presence of fear in a relationship is, in principle, a bad indicator. There is nothing normal in this.

See also:

[ad_2]

8 words successful people don’t use

by

[ad_1]

We all want to be successful and achieve certain results in the chosen areas of activity and life in general. However, observations show that only those for whom the phrases that will be discussed today do not exist are achieving goals. So what are these formulations and why is it better to discard them?

♥ BY TOPIC: Who has the most followers on Instagram – 40 most popular accounts.

“Maybe” “maybe”

By using these words, you leave yourself the opportunity to change your mind. “Maybe I’ll go to the gym,” “Maybe I’ll start doing something,” these are just excuses when you don’t really want to do something. It’s easier to let someone make a decision for themselves and “maybe” support it.

♥ BY TOPIC: Hell for a perfectionist: 50 photos that destroy harmony.

“Tomorrow”

The phrase of the famous heroine of “Gone with the Wind” Scarlett O’Hara: “I’ll think about it tomorrow” has long become commonplace, but it is not always applicable in everyday life. As a rule, in 80% of cases, cases postponed “for tomorrow” are never implemented, although it is quite possible to complete them on the same day. Probably, you are putting too much on yourself and then it is worth reconsidering the workload, or simply “killing” the lazy person in yourself, which is not so easy to do, but more important from a long-term perspective.

♥ BY TOPIC: How to find out about his intimate life using a user’s social network account.

“Never”

“Never say never” – life is complex and unpredictable and is not divided only into black and white. Different situations arise in life, and a person who previously said: “I can never raise my hand against another” begins to defend himself with all his might in case of danger for him and his family. “I will never forgive her / him” – with time, forgive, and perhaps even forget about the insult. As a rule, only selfish and self-righteous people operate with phrases like “never”, “for nothing” (or “always”, “forever”).

♥ BY TOPIC: How many years do trees live (table).

“Future”

The phrases “I will be healthier / more successful / richer in the future” is just self-satisfaction and a way to suppress thoughts about what really bothers you. Don’t put it off for the future, but think about what you can do or change today.

♥ BY TOPIC: Why you should plan your life for years ahead.

“It’s a pity that …”

There is no point in regretting what was done or not done – you can no longer fix everything. Accumulated regrets increase negative experiences that only weigh on you. Repeating the endless “sorry that …” you just circle in search of what is already irretrievably lost.

♥ BY TOPIC: What is horsepower and how much horsepower is in one horse?

“It’s my pleasure”

Very often, in response to thanks for the help or the work done, we answer: “Not at all”, thereby allowing colleagues or friends to continue to exploit us. It is better to replace “not for anything” with “please”, because the service you provided, the time spent, the effort put in has value. Plus, “please” is the most effective and positive way to convey this value in a friendly way, even if you are truly selfless.

♥ BY TOPIC: 9 things to do before age 30

“Impossible”, “unreal”

“It is impossible to lose 5 kg in such a short time”, “It is impossible to quit my job, because I have no money”, “It is impossible to run 5 km, I have no shortness of breath and I walk with difficulty” – think about those who suffer from serious diseases or recovering from accidents. After all, they do not give up simply because it is difficult for them to get up in the morning and get ready for work. Your “impossible” is just a memory of past negative experiences and a habit of putting off everything that seems difficult for later.

♥ BY TOPIC: What is better to say to a person instead of the banal “don’t worry” or “don’t worry.”

“By chance”

“I was completely mistaken by accident”, “I accidentally forgot”, “I happened to be at this event” – in fact, you made a mistake due to carelessness, took too much on yourself and therefore forgot, wanted to get to any event and the last moment we found an opportunity to be there. Draw conclusions for yourself from accidents in order not to do (or do) in the future what happened the first time by accident. The best assistant in business is dedication and perseverance, and not at all by chance.

See also:

[ad_2]

How to create a handy checklist (checklist) in Excel so you don’t forget anything

by

[ad_1]

Excel is a pretty handy tool with extensive functionality. Many applications offer the ability to create different lists, but why use other programs if you have Excel?

♥ BY TOPIC: Exposure of focus in the “Camera” iPhone: setting and fixing.

How to create a handy checklist (checklist) in Excel

Below we show how to create a table with checkboxes that you can delete as you complete tasks. Excel will even display when you uncheck all the boxes. Creating a table is quite simple. To do this, open the tab “Developer”, add a list of tasks, add checkboxes and advanced formatting. And now, in order.

♥ BY TOPIC: Notes Tables on iPhone, iPad, and Mac (macOS): How to create and customize.

1. Open the tab “Developer”

Default tab “Developer” not displayed. It can be added to the feed as follows: open “File” → “Parameters” → Customize Ribbon… In the list Main Tabs check the box “Developer”and then click Done…

How to create a list in Excel

♥ BY TOPIC: The “Rule of Thirds” when shooting with an iPhone: what it is and how to use it.

2. Adding a list of tasks to the table

In each cell of the table, specify the task. In our example, one of the cells will contain “Total number of items”second – “Packaged items”… Cell “I’m ready” will be displayed in red if not all the checkmarks in the list are unchecked, and in green if all the boxes are unchecked.

Open the tab “Developer”… Click “Paste” and in section Form Controls select “Checkbox” (icon with a check mark)…

How to create a list in Excel

♥ BY TOPIC: How to remotely connect to an iPhone or iPad and view its screen from a computer, Android or iOS device.

3. Add checkboxes

Click on the cell where you want to add a flag. You will see text displayed to the right of the checkbox box. Since we only need a field, select the text and delete it. After removing the text, the field does not automatically resize.

How to create a list in Excel

If you want to change it, right-click on a cell to select a field, and then left-click on it. This way you can resize it and move it to the middle of the cell. To copy the checkbox field and place it in other cells, select the cell, and then use the cursor keys (keyboard arrow keys) to move to the checkbox cell. In order to copy a checkbox field to other cells, move the cursor to the bottom corner of the cell, grab it with the mouse button and drag it over the cells where you want to copy the field. Release the mouse button.

How to create a list in Excel

♥ BY TOPIC: Gmail Master, or How to Clean Up Your Google Mailbox: 5 Tips.

Advanced list formatting

Depending on the purpose of the list, you can use advanced formatting.

Create a TRUE / FALSE column

To do this, use the column to the right of the checkbox fields. The checkbox will return TRUE (if checked) or FALSE (if it is removed). This way you can see if all the check boxes are cleared.

Right-click the first checkbox field and select “Object format”…

How to create a list in Excel

In the tab “Control element” in the window “Object format” click on the cell selection button on the right side of the field “Cell Link”…

How to create a list in Excel

Select the cell to the right of the checkbox. The address of the selected cell is placed in the field “Cell Link” in the compact version of the window “Object format”to expand it re-click on the button “Link to cell” and select “OK”… Repeat the procedure for each cell in the list.

How to create a list in Excel

♥ BY TOPIC: Viber for Windows, Linux and Mac in Russian: eight life hacks you might not know.

The total number of items and the count of marked items in the list

Specify the total number of checkboxes in the list in the cell to the right of the cell “Total number of items”… The number of checked boxes can be counted using a special function. Enter

=СЧЁТЕСЛИ(C2:C8; ИСТИНА)

or

=COUNTIF(C2:C8,TRUE)

to the cell to the right of the cell “Packaged items” and press Enter… As shown in the example below, the function will count the number of cells in column C (C2 through C8) that have the value TRUE or TRUE…

How to create a list in Excel

Hide TRUE / FALSE column

In order to hide this column, right-click on its heading and in the menu that appears, select “Hide”… The column will be hidden.

How to create a list in Excel

How to check if all checkboxes are unchecked

To do this, select the cell “I’m ready” and enter

=ЕСЛИ(B10=B11;"Да";"Нет")

or

=IF(B10=B11,"YES","NO")

If the number in cell B10 matches the value of the counted flags in cell B11, it will automatically display “Yes”otherwise “Not”…

How to create a list in Excel

♥ BY TOPIC: How to look good in any photo: 5 simple tips.

Apply conditional formatting

With conditional formatting, you can highlight cells with color. For example, you can set conditional formatting so that all cells with values ​​of a certain type are colored red.

Create a rule by opening “Home” → Conditional Formatting → “Create rule” → Conditional Formatting Rules Manager → “Use a formula to define formatted cells”… Enter

=$B10<>$B11

in field “Format values ​​for which the following formula is true:”… Replace values ​​B10 and B11 with cell addresses “Total number of items” and “Packaged items”if they are not the same cells.

How to create a list in Excel

Create another rule, but in the field “Format values ​​for which the following formula is true:” enter the formula

=$B10=$B11

Then press “Format”, select a color and click “OK”…

In the window Conditional Formatting Rules Manager enter the addresses of the cells to be filled with color in the field “It applies to”… Enter the same addresses for both rules. In our case it is = $ B $ 13… Click “OK”…

How to create a list in Excel

Cell “I’m ready” turns green if all the checkboxes are unchecked, or red if not.

How to create a list in Excel

See also:

[ad_2]

What is better to tell a person instead of the banal “don’t worry” or “don’t worry”

by

[ad_1]

Each of us is in a state of great anxiety from time to time. Neither meditative exercises nor yoga will help get rid of this. Entering the room and seeing silent colleagues, it seems to us that they gossiped about us. When we receive a new and difficult task, fear arises that it will not be possible to complete the job. Even a simple headache may seem to some as a harbinger of a brain tumor.

♥ BY TOPIC: What should be the pulse of a healthy person and how to measure it.

In this state of obsessive anxiety and anxiety, people who often want to help are often next to us. Usually they say what they see as a calming phrase: “Don’t worry!” The intentions of the helpers are good, but they are trying to suppress unproductive behavior. And the phrase itself may be considered useless. People under stress feel that they are being dismissed, or that their problem is contrived. Just telling someone not to worry is ineffective. There are three good alternatives to this banal phrase.

♥ BY TOPIC: 9 things to do before age 30

How can I help you?

Rather than trying to haphazardly comfort someone, it is better to try to really help someone in trouble. It may well be that your help will not resolve the situation. But such a proposal will show that you are not only aware of the existence of the problem, but also ready to turn your shoulder and help get out of trouble. This phrase means that you can be relied on. And even if help is not needed, a person is always pleased to know that someone supports him.

♥ BY TOPIC: 7 famous symbols you might not know about

I understand how you feel now

Remember the alarming situation that caused a sinking heart. It could be an email sent to the wrong person, or the loss of a valuable document, being late for an important meeting … Regardless of whether the circumstances were to blame or yourself, you felt lonely at such a moment.

When we are worried about something, we subconsciously consider ourselves the only one with whom such a difficult situation could happen. But this is not the case. Reassuring a friend that he was in the same situation and felt the same will add confidence and comfort. It is worth sharing your problems with loved ones and finding out how they coped in a similar situation. It is easy to see a solution to the problem using someone else’s example.

♥ BY TOPIC: Life hacks and unusual effective applications for ordinary things: TOP-50.

This is really terrible

Regardless of the strength of our desires, we are not able to help everyone. But you can give a person the opportunity to talk, pour out his soul. If you cannot help either by deed or by advice, then all that remains is to admit the fact of the situation.

What is better than just saying, “Don’t worry”? We acknowledge the emotions of a person and let him know that they are justified, rather than dismiss him. Thus, we demonstrate our readiness, if necessary, to accept his feelings and experiences.

If your loved one is obsessed with an unpleasant situation that makes them nervous, it’s too easy to casually remark, “Don’t worry!” But this phrase will neither help nor comfort. Try one of the suggested alternatives and you can actually reduce the person’s anxiety.

See also:

[ad_2]

Do not wait for the foldable iPhone. You don’t need him

by

[ad_1]

Smartphones have stopped developing rapidly. A bar made of metal and glass has become an ideal form, it remains only to hide the camera under the display.
It turned out that there is almost nowhere to improve the main chips, so manufacturers are creating new ones. This crisis of ideas gives rise to functionally useless models: they are developed in order to sell, and not make our life more convenient.
Apple will not only not be able to release a foldable smartphone, it just doesn’t need either it or us.
Technology is not ready for flip smartphones
We are “here” if apple engineers learn not to crumple displays
The bendable glass in the Z Flip is hidden under plastic so as not to burst from microcracks. The bends and bumps on the Razr are generally crazy.
Many have already managed to bend the display, but it’s all not important when it looks and feels unfinished. A few more generations will pass before Cupertino seriously decides to design a real product.
If it comes to this at all, because two waves of unsuccessful experiments have already passed in the history of phones.
🌊 1. Mobile phones brought to perversions in zero
From left to right: Nokia 7280, 7600, 3250
In 2003-2005, Nokia dominated and, in order to stimulate demand, launched one strange device after another. There was nothing wrong with this: some models entered, some did not. But all this happened from a lack of radical changes that ultimately led the company to decline.
The situation with Samsung is becoming similar for the same reason:
* There is market dominance
* Company models are hard to figure out
* Tortured ideas give rise to the super-expensive Galaxy Fold and Z Flip, which are inconvenient to use.
But this does not mean that the history of Nokia awaits Koreans. They survived both eras: mobile and protosmartphone. Surely they will come out of the water for the third time when the devices begin to change again. The scheme with copying successful ideas has long been worked out.
🌊 2. Smartphones bent and broke, did not enter
From left to right: LG G Flex 2, Galaxy Note Edge, Xiaomi Mi Mix 3, Oppo Find X, Galaxy Round
This was done both for the sake of form, and for the sake of functions.
For example, Galaxy Round and LG G Flex with concave screens did not bear any practical benefit. Then Samsung experiments resulted in a rounding off at the edges of their Edge versions. Which, however, in the new flagships have already disappeared.
The newer Mi MIX 3 and Oppo Find X have movable elements. But at least they were made to get rid of the camera eye on the front panel. They solved one problem, added another: the mechanics greatly spoil the strength and, of course, kills moisture protection.
It is impossible to incorporate all this into the main flagships. It will be too unreliable. Samsung itself decided to split the lineup, and not mix its new “shells” with S-models.
While everyone was trying to hype, Apple never made emotional releases.
Clamshells are more a trend than a killerfic
From left to right: Moto Razr 2019, Galaxy Fold, Huawei Mate X, Surface Neo, Surface Duo, LG G8X ThinQ
The buyer comes in smooth animations, long software support, good cameras. But it’s definitely not that the smartphone can now be folded in half. It will be useful when it ceases to be noticeable.
We look at why it was necessary to fold the mobile phone in zero. There were three useful points:
1. Protection of buttons against accidental clicks
2. Protection of the display inside the shell
3. The larger display fits in a smaller case
Advertising photo Galaxy Z Flip
Today, only the last reason could work if the case did not become a heavy thick sandwich. There is no sense in folding it in half.
Well, Samsung offers a couple of “unique” scenarios for the Z Flip form factor, but literally no one will keep it as a makeup bag to take a selfie.
Cupertinians do not copy
Suspiciously detailed patent of a folding device for 72 images, which Apple received at the beginning of the year
No one has such a slender lineup as Apple. You always know the number of the new iPhone and what the best device will be with the prefix “pro”. To enter into a series of products an offal with incomprehensible tasks not in the style of the company.
But even if it comes out, it is not clear what place it will take. The iPad turned out to be something between a laptop and a smartphone, while a foldable device will either be a tablet and an iPhone at the same time, or it should create a new category with its own philosophy.
Apple will not go further than prototypes
Early versions of what later became the iPad, MacBook, and iPhone
To understand the ambitiousness and scale of the company’s development, look at those that have not reached mass production.
This is the main argument that there will be no clamshell in its current form. Outside of Apple’s labs, a minimum of designs is being chosen. Last time we learned about unfinished AirPower, it all ended tragically. So it’s unlikely that similar bold ideas will be selected for production or, moreover, announced.
Maybe Tim Cook is right now spinning the bendable prototype iPhone 13 Quadra in his hands, but by the time he is released in four years, he will be transformed into a completely new device. Or we will not see any half displays from Apple, simply because they look unnatural in the place of the bends and spoil the user experience.
As a result, either a universal joint is born, or technological clamshells die
The mechanism in the Moto Razr 2019 sounded and looked perfect in theory, but in practice the dents turned out to be worse than that of Samsung
Until they come up with a reliable method to bend and unbend the display so that no bumps and dents are visible, the devices will remain at the niche level. But even if someone thinks out the ideal mechanism, he will surely remain with the company itself. How it happened with the chin of the iPhone X against all smartphones on Android.
Another scenario is possible when the trend will spread to mid-budget models, and everyone will put up with imperfections. In the end, we are already used to bangs and cutouts for selfie cameras.
I am 100% sure of one. Apple is not a company that sits on a hype engine. She is rather the chief engineer. Everyone else is either trying to catch up with her, or to jerk earlier on the curved rails.
This usually leads to what everyone knows about the MacBook, iPod, and iPhone. And to the fact that everyone forgot about some Galaxy Round.

IOS has a notification issue. And they don’t solve it

by

[ad_1]

Push notifications have become one of the best interface solutions that Apple has brought to the masses. Nearby are only a mouse and screens with multi-touch.

But judging by the annual upgrades of this function, no one has figured out how they should work and at the same time not interfere: they try to group, give access to customization and restrict to modes like “Do Not Disturb”.

Talk about random clicks. This is the most annoying notification problem that no one solves.

Messages come unexpectedly and there’s nothing to be done about it.

One way to catch a person by surprise

Are you going to click the “Back” or “Change” button at the top of the application, and instead open a message that I really didn’t want to answer now. It rarely happened to me, but because of this, somewhere deep in the subconscious, I always work with the top of the screen carefully.

The situation may simply be out of place when you are engaged in an important task, but then you accidentally read an invitation to a meeting: now you have to get distracted by time management. And if there is not enough RAM, then the first application will also be reset.

Displays are growing, so every tap counts

The names are large, but some elements for something are still inserted at the very top.

In iOS 10, Apple Music received a redesign, which then expanded throughout the operating system. A lot of space, card menus, animation layers. Gigantic headlines became the most noticeable detail.

They take up a lot of useless space. Therefore, the large names of applications and sections are justified, if only there is nothing more to click on at the top.

Larger display – further up the upper buttons. It is inconvenient to reach for them: the more often you have to press, the more likely it is to drop the smartphone. Random shifts make things worse.

The top of most applications is very active.

Here are just the system elements that force you to pull your hands and unexpectedly open notifications:

• back
• edit
• Add
• Share
• Search line
• Page up
• Context menu
• Log in to your account settings.

It’s impossible to bring them all down. Especially considering the fact that the lower part is now occupied by a huge bar of the “Home” strip for X-models and newer. If you take all the safe areas of the display that Apple itself prescribes, there is not enough living space for pushes.

Framing tetris from buttons is not an option

An example on the right is unlikely to be able to use

I’m not an interface designer, but we all consider ourselves that way when something is wrong. Threw options, how to solve the problem.

Make cards smallerand omit the interactive elements a bit. Swipe for the control center can be returned down and then a safe zone will remain for notifications.

Remove active buttons from the top. To do this, you will have to rewrite the application logic, which is somehow possible at the system level, but for other applications it is unrealistic.

Move the pushies to another place or redesign them. The VK application had an interesting notification function with the output of text in the status bar. The information is visible, but you definitely won’t hit it by accident. Only with the arrival of the bang did it become useless.

Make preanimation of notifications at the system level. iOS “revived” due to hundreds of small active elements that give an almost tactile feel of what is happening on the screen. Pop-up cards can also be pumped. For example, if microseconds before they appear, make small movements from above. Or first show the push tongue, and after a moment push it fully.

Introduce micro-delay from accidental clicks. Ideal option, in my opinion. Because disabling the responsiveness of the window for a moment is simple, but it will be noticeable only to those who really did not want to click. All the rest simply will not get ahead of freezing touches while they drag their fingers until notification. It will be important only to calculate the time, so that the intentional pressing still worked.

Hold to avoid disaster

So far, the situation will be saved if you touch an unwanted notification, but have not yet removed your finger from the screen. With a long push hold, it transforms into a response window. Close it on the cross and the message will remain unread.

For other cases, there is no solution. We’ll have to answer, make appointments, make excuses to the boss or wife.

IOS interface time to redo

In fact, what we now see in our smartphones is iOS 7 on steroids. Apart from the iPad, seven years ago, the largest screen for it was only 4 inches in size against the current 4.7-6.5.

The problems associated with large screens and bangs have accumulated a lot. The percentage of charge is visible only in the notification center; two hands were needed to call him from above; and the contextual return button is, in principle, no longer relevant.

The planned functions are divided into releases every year, because OS stability and the user base are now a priority. I think this is the right direction. True, radical changes are now waiting longer.

So there will be no miracle with the release of the next version. It’s good if they solve the main problem of “dialers” and transfer it to the pushy when the screen is on.

This will make the problem of accidental clicks even more dangerous, but there will be something to fix in iOS 15.

 

How to upgrade your old MacBook so you don’t buy a new one

by

[ad_1]

The new 16-inch MacBook Pro gave Apple tech lovers the hope of updating the entire line of professional computers.

Although the beloved SD card slots and USB-A connectors will never be returned to the MacBook, we’ve still been able to find the most convenient keyboard instead of the sticky “butterfly”.

In six months or a year, it will be possible to replace the old Retina models with updated laptops. To give a second life to the “old people” and to work on them for some more time, we offer to make a simple upgrade.

Only models that support installation will be considered. macOS Catalina:

▸ MacBook Pro Mid 2012 or later
▸ MacBook Air Mid 2012 or later
▸ MacBook Retina Start 2015 or later

Upgrade impossible on the 12-inch MacBook, which was produced from 2015 to 2017, but the new MacBook Air 2018-2019 and on the MacBook Pro starting from 2016 models (TouchBar / Type-C).

The instruction is not suitable for new Macs with a T2 chip. Such manipulations require additional training

On older devices (MacBook Pro Retina and MacBook Air), you can replace the SSD drive. RAM upgrade could be carried out on the previous generation of laptops in a unibody package (laptops from 2008 to 2012 without the Retina display).

MacBook Pro Retina

Models that were produced from mid-2012 to mid-2015 are considered to be the third generation of the MacBook Pro. This entire line is also called Retina.

It includes 7 modifications with screen sizes 13 ″ and 15 ″:

Mid 2012: MC975LL / A, MC976LL / A, MD831LL / A
Late 2012: MD212LL / A, MD213LL / A, Z0N43LL / A
Early 2013: ME662LL / A, ME664LL / A, ME665LL / A
Late 2013: ME864LL / A, ME865LL / A, ME866LL / A, ME293LL / A, ME294LL / A, ME874LL / A
Mid 2014: MGX72LL / A, MGX82LL / A, MGX92LL / A, MGXA2LL / A, MGXC2LL / A
Early 2015: MF839LL / A, MF840LL / A, MF841LL / A
Mid 2015: MJLQ2LL / A, MJLT2LL / A

Macbook air

From the “air” laptops, devices that were released from mid-2012 to mid-2017 are suitable for us.

Upgrade is possible on any of the five modifications 11 ″ and 13 ″:

Mid 2012: MD223LL / A, MD224LL / A, MD231LL / A, MD232LL / A
Mid 2013: MD711LL / A, MD712LL / A, MD760LL / A, MD761LL / A
Early 2014: MD711LL / B, MD712LL / B, MD760LL / B, MD761LL / B
Early 2015: MJVM2LL / A, MJVP2LL / A, MJVE2LL / A, MJVG2LL / A, MMGF2LL / A, MMGG2LL / A
Mid 2017: MQD32LL / A, MQD42LL / A

Which drive to choose

The Cupertinians did everything to upgrade the drive in a laptop was problematic. The replacement procedure itself is not complicated and difficult, it is more difficult to choose the right SSD.

These generations of MacBook Pro and MacBook Air installed solid-state drives with a specific connector, which are different from most SSDs with an M2 connector.

Upgrade can be done as follows:

▸ Find the original Apple SSD of the right size, which was removed from another MacBook. On sale such discs are very rare.

▸ Find third-party SSDs with a similar connector. There is more choice, but prices are still biting. There are several models of the OWC brand: Aura Pro X2 and Aura Pro 6G, Transcend has similar disks: JetDrive 725 or JetDrive 850

▸ connect a regular M2 format SSD via a special adapter: such or such.

In the first case, it is best to order the necessary components in the USA on eBay. In the second case, the Transcend model will be a good option, along with the drive you will get an adapter for connecting the disk via USB, so you can quickly deploy a backup of the system to the SSD before installing it in the MacBook. After the upgrade, you can put the old SSD into the adapter and make it an external USB drive.

When choosing a model from a different manufacturer, a similar dock can be purchased on AliExpress.

In the case of the adapter, you should carefully select the model of the adapter itself and the model of the SSD suitable for it. The choice is very large, but you can make a mistake.

Attention! Different models of the presented laptops use SSDs of different sizes. Too large or wide strap can not fit in the space allotted to it inside the case.

To avoid errors, check the drive dimensions for your MacBook Pro or MacBook Air at iFixit.

Only after that pick up a new SSD and an adapter for it.

For those who are eyeing Transcend drives, a convenient table has been posted on the company’s website. In it you can find the right drive model for your laptop.

How to replace SSD

1. Back up the system through Time machine or using third-party software.

If you purchased a drive with an external dock for replacement, you can immediately connect it via USB, format it in the disk utility and deploy a backup to it.

2. Create a flash drive for a clean macOS installation according to our instructions.

3. Turn off your laptop to begin replacing the SSD.

4. Remove the back cover of the laptop. This will require a screwdriver with a bat P5.

5. Using plastic objects, carefully disconnect the battery cable.

6. With a screwdriver T5 unscrew the mount of the standard SSD and carefully remove it.

7. Replace the new drives and reassemble the laptop in the reverse order.

8. Reset PRAM / NVRAM according to the instructions. In some cases, without such a reset, the laptop will not perceive the new SSD as a system one.

9. Turn on the laptop and boot using the prepared flash drive (hold down the key Option / Alt during MacBook startup).

10. You can perform a clean installation of the system or immediately deploy the Time Machine backup.

Now the old MacBook is more capacious and high-speed drive. The increase in productivity is not the biggest, but for a year or two it will definitely be enough.