Excel’s Paste Special feature can be used to modify multiple numbers at once. Paste Special is more commonly used to paste only values or formatting, it has other tricks to offer. We’ll show you firstly how to multiply numbers in Excel by using Paste Special then add, subtract and division.
To play a selection of different audio tracks, one after another is surprisingly clumsy even in Microsoft 365 PowerPoint. For example, you might like to have multiple tracks from a single album or several movements from a symphony. We expected that a simple Animation would work with the second music track
Almost Equal sign ≈ can be typed into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. The Almost Equal symbol ≈ is commonly used within Mathematics to indicate two values are roughly equal, but not exactly equal. Or use it whenever you need
How to move rows or columns up, down or across an Excel worksheet. There’s a quick way but it’s not obvious. Excel has a variety of different ways in doing this, but it’s important to know the fastest and easiest way, to save you a lot of time and hassle.
Type Up Down Arrow with Base or underline ↨ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. How Up Down Arrow with Base ↨ looks in different fonts. Here’s some examples of how Up Down Arrow with Base / Underline ↨ looks
How to insert either of the Tilde ~ ∼ symbols into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Tilde ∼ symbol is easy on some keyboards but for other keyboards, there’s no specific key for Tilde. The two Tilde symbols There are
There are many ways to add common sound effects and background music to your PowerPoint videos. But what if you wanted audio from an online source like YouTube? You can copy from online to an audio file, save it to your computer then link into a slide deck. There are many tools to ‘rip’ a video with audio from
Type the Up Down Arrow ↕ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Up Down Arrow ↕ symbol is a vertical line with arrowheads on both ends, pointing up and down. How Up Down Arrow ↕ looks in different fonts. Here’s some examples of how Up Down Arrow ↕ looks in common Office fonts. Up
Insert the Black Chess Queen ♛ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Black Chess King ♛ symbol is useful for users that want to represent the chess piece as a symbol, rather than an image. Or just a generic crown icon. How Black Chess Queen ♛ looks in different fonts. Examples of
Office Background are the patterns at top right of the title bar in Word, Excel, PowerPoint and other Microsoft Office apps. Here’s the ‘Underwater’ and ‘Doodle circles’ backgrounds, just two of the 14 you can choose from. Office Backgrounds are fairly pointless decoration. They were added to Office 2013 to almost universal apathy outside the Microsoft Hype Bubble™. There is one
Type the Approximately Equal To ≅ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Approximately Equal To ≅ symbol with a curvy line above the usual = symbol is commonly used within Mathematics to refer to approximate equality between two values, congruence
Excel Charts can be even better looking by completely replacing those plain color blocks with pictures. We’ve already shown how to overlay an Excel Chart with an image now we’ll replace the block with a picture. Although commonly differentiated by differing colors like this, how about we look at different images instead? First, click on the plot area within the column, here we’ve
Windows lets you make the text cursor stand out on your screen. Additionally, you can edit the text cursor thickness to improve its visibility in Word, Outlook and anywhere you type. Changing the cursor is especially helpful in finding your place in Word. With the optional Text cursor indicator preview,
If you want even more flair with your Microsoft Word drop cap letters, why not take advantage of the Microsoft online images range? See Simple Drop Caps Word for the basics of Word Drop Caps and Fancy Drop Caps in Word for a lot more. Click where you want a drop cap letter to
Would you like some music to play before your PowerPoint ‘show’ begins? Most people do this by playing music separately from PowerPoint then clumsily switching over when they start speaking. There’s a better way. The more elegant method is adding repeating music to an opening slide. Add the audio file then change
Audio on a PowerPoint slide can be played when you click on the audio icon on a slide. Choose the audio icon then on the Playback pane, choose Start: when clicked on. You can have multiple audio tracks on a slide, each one plays when you click. This slide has two sound effects
How to insert the Approx Equal or the image of symbol ≒ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. Approximately Equal To or the Image Of ≒ symbol is commonly used Japan, Korea and Taiwan to indicate two values are approximately equal, but not exactly equal. How Approximately Equal ≒ looks in different
Sometimes when you are filling out the cells in an Excel worksheet, the same thing must be written repeatedly. There’s a fast way to do it using a surprising Excel shortcut. Luckily, there’s an easier shortcut around it. Previously we have spoken about Auto Fill hidden tricks in Excel, but you might not be aware
A PowerPoint presentation sometimes needs that extra oomph, such as an occasional sound effect. Here are a few common ones that you’ve heard from movies and TV shows. You can use them as a trigger sound, or novel background noise. It’s all about the sounds: Wilhelm Scream – stock sound effect used in several TV shows
A very small set of mouse cursor options is included in Windows 11, but they are fairly simple and basic. Perhaps you’d like something easier to see? A larger or more colorful mouse pointer? There are options to change the colour of your mouse, and even adjust the size, however if you wanted
Make your extra fancy mouse cursors using a feature buried in Windows 11, Windows 10 and earlier Windows too Download mouse pointer themes for free, from sites like Open Cursor Library. Microsoft has made the option to change your Pointer Icons a little tricky, it takes a few steps, but is fairly easy to manage once you’ve downloaded your theme. As Microsoft has left little creativity when it comes
Type the Reversed Tilde ∽ into Microsoft Word, Excel, PowerPoint, or Outlook. Both in Office for Windows and Office for Mac. Reversed Tilde ∽ symbol is the vertically flipped version of the usual tilde ~ symbol. A tilde starts with the downward curve while the reversed tilde has a rising
How to insert the White Chess Queen ♕ into Microsoft Word, Excel, PowerPoint or Outlook. Both in Office for Windows and Office for Mac. White Chess Queen ♕ symbol is useful for users that want to represent the chess piece as a symbol, rather than an image. Or just a generic
There’s an easy way to make a Word document version of a PowerPoint presentation and it’s another way to make a handout for your audience. It’s a simple step by step process of converting your PowerPoint (.pptx) presentation file into a Word Document (.docx). Firstly, you will need to open your PowerPoint Presentation (amazing but true) Next, select File | Export Select Create Handouts | then the Create Handouts button This section
