We often need to forget a Wi-Fi hotspot or change its properties. This was easily possible by using the right click menu (also called the context menu). With Windows 10, there is no context menu. Frustrating! Here is the solution.
Click on the network icon in taskbar to open the list of connections. At the bottom click Network Settings. Now you see another list of Wi-Fi networks. DO NOT go there. Click on Manage Wi-Fi settings.
Ignore the Wi-Fi Sense settings on top. Scroll down to Manage Known Networks. CLICK (not right click) on the network you want and then finally you see the Forget button.
Enjoy the experience!
Read this article first: Frustration = Feature Guarantee! (Table Row breaking across pages). Here we saw how to ask Word to manage repeating the header automatically across pages.
What I learnt today is that the Repeat Header Rows feature works across columns as well. This is very useful when we have a narrow table shown in multiple columns on the same page.
Chances are – you have seen it while printing documents. But of course, you did not know what it is – so you never clicked on it. It is a very powerful feature of OneNote. Here is how to use it – why to use it and how to use it properly. (Reading time 7 min)
Continue reading Have you seen a printer called Send to OneNote?
Double click to select all sub-pages in OneNote
OneNote can have pages and sub-pages. Multiple sub-pages can be selected quickly by double clicking on the Main Page. If the main page is not the currently selected one, triple-click on the main page. (First click is for selecting the page and remaining two clicks are for selecting sub-pages. That makes it a total of 3 clicks!). Notice that you can also collapse and expand sub-pages.
Sub-pages are useful for managing sub-topics to main topics. It is also useful in case of recurring meetings with the same customer or similar topic. In case of students, sub-pages can also be used for assignments associated with specific lectures.
Learn to use OneNote to your advantage: Read Knowledge Pack: OneNote (20+ articles)
This was a shortcut I knew. But did not find a practical use for it. Till recently when I was conducting a session for the legal team of an insurance company. If you work on large and complex documents, I am sure you will find this useful.
You are editing a complex and long Word document. While scrolling or navigating, something goes wrong and you suddenly land up in a completely different, far away place in the document. You did not know where you were, nor do you know where you are. You just want to go back to the original place where you were editing. Bookmarking is not an option because you could be editing anywhere, you cannot keep adding bookmarks all over the place.
The solution is simpler than you think. Just press SHIFT F5. Word remembers last THREE editing positions. That solves the problem elegantly.
Also appreciate someone who thought of this need and provided a solution 20 years back!
Chat is a well established part of our lives. WhatsApp, WeChat, Line, Skype, FB Messenger, Google Talk, etc. – So many options. Even in corporate context we have Lync (now Skype for Business), and others. Whether personal or corporate, we can use Chat for engaging into some cheating. Not in the true sense of the word – as in – not to violate law, but to get some political advantage. Here is how you can do it.
Continue reading Office Politics: Cheat Chat
SUM and COUNT are the most common methods of summarizing data. It is easily done in Pivot Table or any other analytical tool. What is equally important is DISTINCT COUNT. But it is not commonly used. Why not? Firstly, due to lack of awareness and secondly, due to lack of that feature in Pivot Table. Let us solve both problems in the next 10 minutes.
Continue reading Instant benefit: Try Distinct Count wherever you are using Count
We get data and make reports repeatedly. Often we forget to look at the same data in different ways. Due to this unbelievable amount of useful information is lost.
Act Now is a new idea I am trying. It asks you to do some activity and post the results.
Continue reading Act Now: Discover one new and useful thing from familiar data
Some documents seem to be so cluttered with these blue wavy lines that we cannot read the content at all. Here is a solution to this problem and explanation of the root cause and the REAL solution.
Continue reading Irritant: Too many blue wavy lines in Word?
Consider a pivot table which has many fields in row as well as column area. Now, for whatever reason, you have to transpose the pivot table. Whatever is in the rows has to go into columns and vice versa. We cannot use Paste Special Transpose with Pivots.
The only choice seems to be manually dragging and dropping fields across row and column areas. Not only is this cumbersome, but it can also lead to mistakes. Don’t worry. I just found a smarter way.
Add a Pivot Chart. Never mind which type. Choose Pie because it takes least amount of effort graphically and it happily ignores child series of data. Now click inside the chart. Choose Design tab and click Switch Rows / Column. It instantly transposes the row and column fields. Delete the chart. Job done.
This works with Power Pivots as well. For large pivot tables, you may get the maximum series limit reached error for charts. Ignore that error and continue – because in this case, the chart is just a temporary means of achieving transpose operation.