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 […]
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 […]
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 […]
