Here’s an even better way to make an automatic list of tabs in an Excel workbook it works in Excel for Windows and Mac and bypasses some possible traps. Start with our article on Automatic worksheet/tabs list in Excel which explains how to add a list of Excel tabs/sheets with
Function Fn keys on your keyboard, though neglected, have a special role to play in Microsoft Office. Sometimes they combine with Ctrl, Alt or Shift keys to provide certain functions. Here’s how to use Fn keys when they’re on smaller laptop keyboards or totally missing! Plus how Microsoft Office’s help
Here’s a complete list of the Word Function Key features from fast access to Help, jumping around the document, doc panes, spelling, grammar and managing field codes. Letâs discuss in detail the functionality of the F-keys labelled F1 through F12 on your keyboard. F1 – Help, field jump F2 –
Insert the Epsilon upper case Î, and Epsilon lower case Δ symbols in Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Epsilon (uppercase Î / lowercase Δ) is the fifth letter of the Greek alphabet. The uppercase isnât commonly used outside of the Greek language,
The inverted or Spanish question mark  ¿ is available in Microsoft Word, regardless of language setting. Thereâs even an in-built shortcut. ¿ is most commonly used in Spanish for the start of a question sentence. This guide is mostly for people without a Spanish keyboard or who only occasionally need
Make Excel mobile for iPhone or iPad read aloud a workbook. Great for double-checking figures from a printed source. The options arenât very good but weâll explain what might be possible. Excel 365 does not have a Read Aloud or Speak feature similar to Word for iPhone/iPad let alone Word
Grab high-res still pictures from movies and videos to insert into Office documents or emails. Weâll show you how to capture or grab a proper, full size, high-resolution still image from a high quality video file then paste that picture into an Office document or Outlook email. Why do this?
Itâs now possible to insert a PowerBI report directly into a PowerPoint slide, finally resolving a long-standing customer demand and glaring omission. The PowerBI report has filters and pivots to adjust the display directly. The data is live in both Edit and Slide Show modes. Microsoft calls this Interactive Data
Outlook for Mac is now available to all, no payment or subscription required. It combines email, calendar and contacts in the one app. Anyone with a recent Mac computer can install Outlook for Mac for email, calendar and contacts from the App Store. All the common and most less-common email
Here’s how to replace private or confidential text with ‘filler’ nonsense or anonymous text in a Word document. Handy for getting help with Word formatting or numbering problems where you can’t share the real document to an outsider. This is often a problem for legal workers or others with privacy
Losing recent work on a document is really frustrating so here are a few tips to make Office document saving more reliable, with less risk of loss if the computer or Office programs crash. A few changes to Microsoftâs defaults can mean lower blood pressure for you. Save AutoRecover every
The ultimate in PowerPoint Handouts arenât made in PowerPoint at all. Link a presentation to handouts in Microsoft Word, where you have all the powerful Word formatting features available to you. Youâre forgiven for not knowing this option existed, because itâs not immediately obvious and you need to go several
The rainbow shape with multi-color effect is possible in text, shapes and images for any Microsoft Office documents including Word and PowerPoint. With a few changes you can make a rainbow for documents or slides. Rainbow Text Effect Insert | WordArt choosing whichever preset is closest to what you want.Â
A rainbow in Office is a custom gradient effect available for Shapes including WordArt borders and many elements in Word, PowerPoint and other Office programs for Windows or Mac. We have the exact colors, positions and options to use for a great rainbow. All the Office preset gradients are single-color
Hereâs how to mask a photo with any Microsoft Office shape or icon and do it with full control over what appears from the original image. Weâve already explained two simple ways to crop a photo to a shape or fill a shape with some options to move and resize
The picture option âSet Transparency Colorâ doesnât always work properly in Microsoft Office. Weâll explain the problem and suggest some fixes. When we were making our article âMake a transparent shape to mask a photo in Word, PowerPoint and moreâ we discovered that the âSet Transparent Colorâ option didnât work
Recent investigations have revealed some worrying truths about the risks in opening OneNote notebooks, a surprising fact about .one files, some bad news and good news. Criminals are increasingly sending out nasty OneNote .one files in emails, taking advantage of another Microsoft security âblind spotâ. OneNote Embedded File Abuse from
Microsoft is expanding their Phone Link feature in Windows 11 to include Apple iPhones. That means call and SMS text messaging from an iPhone can appear on a Windows screen. Phone Link is already available for Android phones. With a connected smartphone Microsoft likes to talk broadly about âmessagesâ and
XLL addins for Excel coming from the Internet will be blocked by default as a security measure. Here’s how it works and how to enable XLL files and bypass the new block. You can implement a similar block now in other Excel versions without waiting for Microsoftâs late change. Excel
It is possible to display your Mac screen to another person or even let someone take control of your Mac to fix a problem or help learn a computer skill. Weâll explain how to find and start the Screen Sharing app in macOS and an alternative. Windows has a similar
The âspeech to textâ Dictation feature is now in OneNote for Mac. Look on the far-right of the Home tab for the Dictate button. Click on it to make the little Dictation toolbar appear. Our book Dictation and Read Aloud in Office explains Dictation and other Office speech features from
There are new look menus and toolbars coming to the iPhone Microsoft Office apps, Word, Excel, PowerPoint and the all-in-one Microsoft 365 app. We’re not sure when you’ll see these changes because they are three months late! Microsoft started talking about this âfast and fluentâ change in November 2022. Three
There are two ways to switch between Letter (Imperial) and A4 (Metric) paper sizes for Microsoft Word documents on Windows or Mac. One is easy and temporary, the other changes the document itself. Also how to switch Word’s default paper size and how to save PDF’s to another page size.
