You can make it easier to see your current place in a workbook by dynamically highlighting the selected row, column, cell or headings. Here’s obvious and more subtle highlighting options plus the downside of highlighting, real world tips and debugging tricks if you’re having trouble. There are many different variations on this method; two colors, […]
Just one of the many tricks to get people to giveaway their password is a bogus ‘system delay’ email, supposedly from your network administrators. The fake login page is given extra credibility being hosted on a Microsoft server! It starts with a fake message from the ‘Excel Team’ saying you can’t ‘Open Excel or any […]
Once you have the basic setup for the I ♥ or I Love … sign, the fun begins. Making your own variations for a Word document or PowerPoint presentation. Start by making your own I ♥ or I Love … sign based on the original I Love NY logo. Font variations Simply changing the font […]
It’s pretty easy to make a similar I ♥ or I Love logo, in Microsoft Word or PowerPoint. It’s even a little easier for Mac users. Check out Making the original I Love NY sign to see how the original logo is put together. The logo looks simple but it’s not. We’ll show you the […]
Here’s the design details of how the famous I ♥ NY / I Love NY logo was made. The font, colors, symbols and how they come together to make an iconic sign imitated all over the world. The logo was created by Milton Glasner in the back of a taxi but these days all you […]
Here’s how to block .IQY web queries in Excel that are being used to infect machines with Buran ransomware. Yet again, a mostly forgotten part of Office is being used by hackers to get inside computers and networks. Suspicious Link (great name) found this nasty in an email. It pretends to be a forwarded message […]
We’ve completed our series on ‘Hidden’ options in Word, Excel and PowerPoint. How to hide text, images, cells, slides etc within documents. Hiding is a useful option and avoids deleting content that might be needed later. It lets you make a different version of a document/sheet/deck without the hassle of maintaining two very similar documents. […]
If you have a slide that you want to keep in your PowerPoint deck but don’t want to show them in a presentation, you can hide those slides. Go to the strip of slide thumbnails down the side of your project and select the slide you want to hide. You can select multiple slides using […]
OneNote for Windows has a better future after some reverse-course announcements from Microsoft. OneNote desktop program gets extended life and a promotion. The desktop and app versions merging into a single codebase. We’ll also explain the strange case of two OneNote for Windows. The announcements amount to a 180° reversal of past poor, short-sighted management […]
We have recently discussed how to show hidden formatting characters in Word, but it is also possible to hide text and even images in Microsoft Word, as long as you are using Word on your computer. At this stage, Word Online and Word phone apps don’t allow you to hide text. See Find and Remove Hidden […]
Word is very clever dealing with Hidden text, perhaps a bit too clever at times. Here’s some tricks for positioning and formatting with Hidden text. Students quiz (left) and Teachers version (right) from the same document. The answer text is hidden in the student version but there’s still space for their answers. Leaving space where […]
If you want to remove hidden text from your Word document, you first need to find it. For a shorter document, you can use the Show/Hide button to see what’s hidden and delete it manually, but that would be very time consuming for longer documents with lots of hidden passages. Never fear, there are a […]
Make your worksheets look more compact and focused by hiding unwanted columns or rows. Hidden rows/columns still work in calculations, they can be referenced in formulas etc. It’s pretty straightforward. Select the columns or rows, right-click and choose Hide. Keyboard shortcuts Type Control + 9 to hide a row. Control + 0 to hide a […]
If you have data in Excel that you don’t want to be visible, but you still need to be able to use it in calculations, there are two ways to hide cells. It’s another case of Office having an official and unofficial hiding option. Here we’re talking about hiding individual cells or ranges. There are […]
The Microsoft Whiteboard app can now import pages from Word documents or selected slides from a PowerPoint deck. The new feature is better than it’s promoted because you can select pages/slides not just entire documents or decks. Start from the Insert menu where there are now options for Word document and PowerPoint document. The PDF […]
3D Formulas in Excel allow you to make calculations using data from many different worksheets, including ones that don’t exist yet. This can be incredibly useful, when you have similar figures for different periods across worksheets and want to use data from all of those periods. For our example, we have a file with expenses for a number of years, a different worksheet for […]
A new Windows 10 bug patch has some fixes for Microsoft Outlook. Microsoft’s documentation is typically brief, so we’ll fill in some details. The time zone changes are too late to help some customers … why? KB4520062 has many Windows 10 fixes but a few affect some Outlook users and anyone using the new Windows […]
Over time there’s been a change in the way email programs login to your mail host. It’s mostly hidden from us mere humans but important to understand. Here’s how to use oAuth and how to bypass it, if your email program doesn’t support it. Older versions of Outlook don’t know about Open Authentication but there’s […]
Like it or loath it but the comma ellipsis has arrived ,,, as an alternative to the more common ellipsis with dots. Here’s how to use it in Word and Office. The comma ellipsis is a modern, more casual version. It’s used as a more dramatic, even annoyed trailing off of a thought, compared to […]
You can add text that appears smaller and slightly below (subscript) or above (superscript) your main text quite easily in Word. This kind of text is commonly used in mathematics (e.g. X2) and other technical fields (e.g. H2O), but can also be used for something as simple as a date or other ordinal number (e.g. […]
