Arrays have more powerful options than simple Excel ranges but, happily, it’s very easy to convert a range of cells into an array. Or sometimes you have a mix of arrays and ranges that need to be managed as a collection of arrays. That’s what we’ve needed to make the
Microsoft Word’s ‘Pickup where you left off’ or ‘Welcome back’ message is different from the Shift+F5 shortcut. All the recent talk about the ‘Pickup where you left off’ feature in Word had a few Office-Watch.com readers asking how it’s different from the long-standing GoBack shortcut in Word – Shift +
Outlook has three features called ‘Archive’ with the newer versions (Archive and Online Archive) much better than older ‘AutoArchive’. We’ll explain the difference, how to use Archive and why to avoid AutoArchive. Each form of Archive sets aside older messages or emails you’ve finished with. It does that in two
One of the more obscure settings when putting a frame around a picture in Word or PowerPoint is the Cap Type or line ends. This setting only applies when you are using one of the dashed borders with the choices Square, Flat and Round. To put a dashed border on
Join Type is what Microsoft calls the corners of the picture frames – the place where the horizontal and vertical lines join. There are three options: Round. Bevel and Mitre. We’ll show you where those choices are and what they look like. We’ve previously looked at ways to put frames
Word and PowerPoint have some great ways to add a border or frame around an image, graphic or logo. We covered these broadly in a Framing Pictures in Office and now we will look in detail at the Compound Type, or multi-line borders. Compound Type is Microsoft’s name for the
Here are three options for putting a photo inside any Microsoft Office Shape or Icon (Word, Powerpoint etc.). Photographers call it cropping a photo to a shape or graphic. There are three different ways to get the same or similar result. Two are quick and easy. The third option is
A new report lists the top software vulnerabilities of 2019. Little surprise that Microsoft and Office feature in the top ten but not with the latest security bugs. Recorded Future’s report is headed 2019 Vulnerability Report: Cybercriminals Continue to Target Microsoft Products and lists the top ten vulnerabilities of 2019.
Get a hi-res version of Canadian National flag into Office documents, Word, Excel or PowerPoint, then use some Office picture tools to enhance the image. The same help applies for any other national flag, just look for a different source. Get the Canadian Flag Image There are many, many copies of the Canada flag available.
Courtesy of the good folks at Popbitch comes this groaner; To the person who stole my copy of Microsoft Office, I will find you. You have my Word. Joker from Office 365/2019 Icons with some extra formatting Boom, boom. We’re here all week. Try the chicken. Don’t forget to
It’s the Chinese Year of the Rat, to celebrate in Word, PowerPoint or Office generally is easy with an Icon or Online Pictures search. Not interested in the Chinese New Year? These same tips apply to many other events or festivals. Rat Icon Insert | Icons has many graphics including
There are many ways to edit a logo or graphic in Microsoft Office; recolor, outline, shadow, reflection plus Shape options. All demonstrated here using the Star Trek logo ready for Word, PowerPoint or Excel. We’ve found the iconic logo in the best form to use in Office. Even if you’re
Microsoft Office, especially PowerPoint and Word, have simple and easy ways to ‘jazz up’ a simple image, flag or logo with one of the many framing options. Instead of just copying a graphic into a document or slide, try one of these variations. They retain the original image but give
One of the sillier online debates is an argument about the usefulness of algebra and other maths skills in a world where Excel is available on almost any screen. To us this is silly because it’s not a simple either/or choice. It’s about balance, a concept that’s not fashionable these
Here are two options to stop Microsoft Office for Windows from automatically updating itself and why you might want to do that. Office for Windows All versions of Office that have current support (currently Office 2010 and later) get: updates to fix bugs in the software patches to stop security
He’s done it again, David Peel has quickly made up a new version of his Excel Year Planner that starts the year from any month you choose. Great for academic years (start in August) or financial years (e.g. Aussie start in July). The year selector is top left of the
The second Access memory leak has finally been patched by Microsoft, almost a year after a very similar problem was discovered. These bugs have been around since 2002 and the effects are still in some Access files. Both are faults in the way Access saves data to memory locations in
It’s possible to apply individual cell formatting in Word consistently using a little VBA code. In effect it makes styles for cells in a way that Word itself won’t do. Reuse this code to apply the same formatting to many cells. Cell Format Special We’ve made two VBA functions for
Nested IF statements can be hard to understand and manage but there are alternatives which can be easier to handle, fix and change. We’ll start with the relatively simple example we used for demonstrating IF and nested IF. =IF(C2>89,"HIGH DISTINCTION",IF(C2>79,"DISTINCTION",IF(C2>69,"CREDIT",IF(C2>49,"PASS","FAIL")))) This example has only five levels of nesting, we’ve seen
Are there any advantages to getting an Solid State Drive (SSD) when running Microsoft Office? We have some advice from actual use. Solid State Drives are faster and power saving drives that are now less expensive and more available, but are they worth the trouble for Office users? YES —
Criminals don’t even respect Santa and the festive season with malware infested emails pretending to be holiday schedules or the Christmas party. Is nothing sacred? Cofense Labs report that Emotet botnet is being spread via Word documents with timely emails for the end of the year. All these dangerous emails
The latest ebook from Office-Watch.com is a little different, it’s a heartfelt ‘Thank You’ to our Office Watch donors. Peter and Victor have again been quite astonished and humbled by the generosity of readers to our reader appeal. Both the money and kind remarks have been a considerable morale boost
Pantone has announced its Color of the Year for 2020 here’s how to get it in Microsoft Office – Word, Excel, PowerPoint, Outlook etc. The color of 2020 is … Classic Blue Source: Pantone As usual what’s more amazing than the color is the description from the ‘Pantone Institute’. Classic
Sometimes we want to change the margins around a Word document, either to change the way the page looks, or to get the text to fit onto the page. To do this, go to Layout > Margins or use the Ruler to drag the margins. There are several default options
