Previously we talked about How to add a Drop-down List in Word, but you can also work more efficiently in Excel worksheets by making use of drop-down or pull-down lists. We will show you how to use Microsoft Excel’s data validation function to create useful lists within your spreadsheets. How to avoid the trap that lies waiting for the unwary
There’s another way you can force a page break before a paragraph in Microsoft Word. By setting this up, the page breaks can automatically appear without you having to worry. This is particularly useful if you have long documents with several different headings. Just simply modify the style to include
Interactive checkboxes can easily be added to your Word document for a variety of uses. Perhaps you need to create a to-do checklist to help monitor the completion of tasks on top of a collaboration document, or make it simpler for users to read and complete surveys or forms. Either way, we will provide
Microsoft has released a patch for the MSHTML security bug that’s being used with Office documents to infect computers. The bug is in MSHTML, the browser rendering engine used by Microsoft Office. If someone is tricked into opening a hacked Office document with ActiveX control, they could infect their computer
There are many API’s available on the Internet that can provide great and timely data in ways that Excel can understand, here’s how you can do it. We’ve recently received emails asking how to use Excel to import data from specific API’s. Always we have the same answers because most
Outlook’s Folder Pane displays all folders which lets you quickly move between folders and views. Minimise the Folder pane, you will no longer be able to see your folders. As a result, some users get puzzled as to how they can bring back the expanded Folder Pane view. There are a few ways that
Printing email messages is something that we all do at various times, and in theory it should be as simple as clicking the Print icon in your email program – but what if the message won’t print out properly? Sometimes the printed version of an email message (or web page)
Here’s what you need to know about the two official international document formats, Microsoft’s OpenXML (.docx .xlsx etc) and Open Document Format (.odt .ods etc) both supported in Microsoft Office and most other office suite software. Each format has been recognized by international bodies so there are two ‘official’ document
Excel’s PivotTable allows you to evaluate trends, comparisons, and patterns within datasets. Once a PivotTable is setup, you can filter “Drill down” into it to focus on key information. These days there are several ways to filter a PivotTable, Slicers (which Microsoft loves to boast about), AutoFilter and by Field
Simple, easy and free ways to convert audio files like WAV, FLAC and many others into a format that PowerPoint or your smartphone prefers such as MP3, MP4 or AAC. The BBC Sound effect downloads are in WAV format. That’s a good, high-fidelity and uncompressed format that works in PowerPoint
How to stop your Office Watch newsletters going to the Junk E-mail folder. To make sure your Office Watch newsletters don’t end up in your Junk Email folder you need to set us up as a ‘Safe Sender’. Here’s how to do that in Outlook. Keep in mind that Outlook
If you think font selection is hard, spare a thought for lawyers who have to deal with different official rules, recommendations and accepted practice for court submissions. Jason Steed at JDSupra sets out the complications for US lawyers. The D.C Circuit court started ‘discouraging’ use of Garamond font but no
Now you know how to insert checkboxes in Excel, here are some ways to use check box cells in Excel. Counting the checked/unchecked boxes, calculate percentage checked and even showing a separate list of items based on their checked status. A cell with a check box has two values: TRUE – checked FALSE – UNchecked
Here’s how to collaborate on a ‘live’ file (Word document, Excel workbook, PowerPoint deck or OneNote notebook) saved on OneDrive or other cloud service. It’s part of our series on accept a sharing request and collaborating on a ‘live’ document saved online. Microsoft spends a lot of energy getting people
Microsoft spends a lot of time explaining how to share a file (Word document, Excel workbook, PowerPoint deck or OneNote notebook) but very little on how to accept a sharing request and collaborate on a ‘live’ document saved online. Live or real-time collaboration lets two or more people work on
Save-the-date cards, invitations, place cards and other wedding paperwork can be made in Word. Reduce stress and expenses, by creating your invites digitally through Word. Creating your own invites is a great approach, adding a personal and unique touch to proceedings. Usually, you’ll find Wedding Invites are in A5 size. Simply open your new document, go to the Layout
A security company has revealed a dangerous setting in Microsoft PowerApps. Microsoft has fallen back on one of their oldest tricks, blaming the customer. There’s a similar ‘way too open’ option in Word, Excel and PowerPoint. Power Apps provide ways for organization to make simple apps to access online data
Sometimes Outlook for Windows can download a lot of data that it doesn’t mean to. When we say ‘a lot’ we mean many gigabytes, sometimes far more than the size of the mailbox, which makes no sense at all. Here’s some options for fixing the problem with tips for using
A detailed look at a common email phishing attack, what to look for and how to avoid it. The most common form of phishing (password stealing) attack fakes a Microsoft account login. Most people have a Microsoft account for their work, home or both so it’s a large slow-moving target
Importing genetic codes into Excel is still a problem despite widespread reports of the problem. And still Microsoft is blamed, despite the real solution is with the lazy scientists who need to learn how to use Excel. A new report in the journal Nature shows that Autocorrect errors in Excel
Modern Excel has a danger zone that hackers increasingly use to get into your computer. It’s been there for well over twenty years but is being abused a lot more in 2021. Here’s how to disable it. The problem is in a very old method of Excel automation called Excel
Type the Tau – lower case τ letter into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Tau (lowercase τ) is the 19th letter of the Greek alphabet. The lowercase letter is used in Biology, Mathematics and Physics, such as proper time in relativity. In ancient times it was also used as
Type Zeta – lower case ζ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Zeta – lower case ζ symbol is the 6th letter of the Greek alphabet. It is used for various mathematically and scientific reasons, such as representing the Riemann zeta function, the heat flux through a
Type Gamma upper case Γ and Gamma lower case γ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Gamma (uppercase Γ / lowercase γ) is the third letter of the Greek alphabet. It represents the “g” sound in Modern and Ancient Greek.
