Essential keyboard shortcuts for the Office Selection Pane
Use these essential keyboard shortcuts to make best use of the Selection pane in Microsoft Office. Alt + F10 Open Selection Pane F6 Move the keyboard focus through the major regions until reaches the Selection Pane Tab Navigate by keyboard through the buttons in the pane and then into the list Up arrow, down arrow […]
See more with Selection Pane in Excel, PowerPoint and Word
Selection Pane is essential in Word, Powerpoint and Excel to hide or display the objects or to change the order, rename objects, group / ungroup, and delete objects. If you’re using images, graphics, Text Boxes, charts, SmartArt or other objects, the Selection Pane is a must. So, let’s start with some basic details of how […]
How to use Excel’s Business Assist – Forecast
Business Assist – Forecast is a new Excel add-in from Microsoft which forecasts future volumes based on past data. How to use the add-in, if you can and understand its limitations. From the promotion, Business Assist – Forecast sounds like a useful tool but it’s a different story when we tried the add-in for ourselves. […]
Excel trick uses a single cell to get the latest stock or exchange rate
Here’s the Excel trick to grab a recent stock price or currency exchange rate using a single cell. It bypasses the multiple steps needed for the Stock/Currency data type and the annoying lack of configuration in the standard stock/currency data type. The single cell trick makes for more compact and workbook plus letting you select […]
Great guide to harnessing Python in Excel
In a great development for data analysts and coding enthusiasts, John Lam’s new guide that expertly explains Python programming with Excel from the start to a practical example. Book of Python in Excel goes through the basics like using the XL() function in Python to grab data from an Excel workbook, importing external data and […]
Patch Tuesday – Two November 2023 highlights
Here’s just a few of the security breaches that caught our eye from a total of 63 security flaws patched in this months dump of fixes from Microsoft. Including five ‘zero-day’ bugs plus another 20 Edge browser security bugs fixed earlier in November. We’ve included links to more detail and specific patches for each version […]
Eiffel Tower 🗼 emoji in Word, Excel, PowerPoint and Outlook
Insert the Tower 🗼 (Eiffel Tower, Tokyo Tower) emoji, symbol or stock photo into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. The emoji is commonly called ‘Eiffel Tower’ in the west but it was originally intended to show the Tokyo Tower. That’s why some emoji are colored […]
Add comments/help to your Office VBA code
ChatGPT is a powerful tool that can enhance your Office VBA code with comments and help. It or Copilot can analyze your code and generate explanations, tips, and examples to make it easier to read and debug One of the modern AI tricks is to help write and understand programming code. We’ve already looked at […]
Trademark ™ symbol in Word, Excel, PowerPoint and Outlook
Type the Trademark ™ TM symbol as text and icon into Microsoft Word Excel PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Trademark ™ TM symbol is, strictly speaking, called the Unregistered Trademark symbol. Its counterpart is the Registered Trademark ® Trademark in Word and Outlook The Trademark ™ sign has an […]
Registered Trade Mark ® symbol in Word and Office
How to insert the Registered Trade Mark ® symbol as text or icon into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Registered Trade Mark ® not to be confused with the Unregistered Trade Mark ™ symbol. Registered Trade Mark ® in Word and Outlook The Registered Trade Mark […]
Care of ℅ symbol in Word, Excel, PowerPoint and Outlook
The Care of ℅ symbol can be typed into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Care of ℅ symbol is one of those useful symbols you’ll never see on a keyboard and have to go hunting for. ℅ is used on envelopes and addresses, it refers to […]
Microsoft Office photo editing with Apollo 8’s Earthrise
As a quick example of what’s possible, here’s a quick look at some photo editing options in Microsoft Office, Word, Excel, PowerPoint or Outlook emails. Since it’s Christmas, we’ll use one of the famous Apollo 8 Earthrise images. We’ve already talked about how Apollo 8’s Earthrise, as we know it, is a cropped, rotated and […]
Fast umlaut ä ë ï ö ü in Microsoft Word and Office
Once you know the ‘secret’ shortcuts, it’s easy to type the umlaut vowels ä ë ï ö ü Ä Ë Ï Ö Ü in Word and Outlook but, alas, it’s not the same in Excel or PowerPoint. There are alternatives in Windows and Mac if you’re not using Word. There’s also a stand-alone ¨ umlaut […]
Satellite Antenna 📡 emoji in Word, Excel, PowerPoint and Outlook
Type the Satellite Antenna 📡 symbol/emoji into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Satellite Antenna or Dish 📡 symbol can be used for modern television, radio, GPS or wireless broadcasting generally. Can be used with the Satellite 🛰 emoji or icon. How Satellite Antenna 📡 looks […]
How to quickly switch between Word and Office windows
Often you need to switch between windows of the same program, so there should be a quick keyboard shortcut to do that. Here are your options in Windows or Mac. Whether you’re moving between Word documents, Excel workbooks or PowerPoint decks or Outlook emails, the need is the same. You want to quickly move between […]
Satellite 🛰 emoji in Word, Excel, PowerPoint and Outlook
Insert the Satellite 🛰 emoji or icon into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. How Satellite 🛰 looks in different fonts. In Windows fonts only Segoe UI Emoji and Segoe UI Symbol have the Satellite emoji. As usual the Apple version (Apple Color Emoji font) looks […]
