Microsoft Office Tips, Tricks and Shortcuts

Microsoft Office Blog | Avantix Learning

Check out our training courses >

How to Change Case in Word (Upper, Lower, Title or Sentence Case)

How to Change Case in Word (Upper, Lower, Title or Sentence Case)

You can change case in Microsoft Word documents using formatting commands or by converting case. If you want to be able to easily change case (like removing All Caps), it's best to change case using the Font dialog box. If someone has created upper case text using hard capitals where they have pressed the Caps Lock key and typed the text, then you can convert case using the Change Case command.

How to Modify Table of Contents Formatting in Word

How to Modify Table of Contents Formatting in Word

If you have created a custom or automatic table of contents (TOC) in a Word document, you can add heading levels to the TOC. You can add or edit levels using built-in heading styles or use custom styles as levels.

How to Insert or Type the Beta Symbol in Word (β or Β)

How to Insert or Type the Beta Symbol in Word (β or Β)

You can insert or type the Beta symbol in Word documents in several ways. The Greek Beta symbol can be entered in upper case (Β) or lower case (β) using built-in commands or keyboard shortcuts (including Alt codes, AutoCorrect entries or custom shortcuts). Beta is the 2nd letter in the Greek alphabet and is comparable to the letter B.

How to Password Protect Your Excel Worksheets and Workbooks

How to Password Protect Your Excel Worksheets and Workbooks

You can password protect worksheets and workbooks in Excel. If you want to prevent other users from opening or modifying an Excel workbook, you can encrypt the file with a password. You can also protect workbook structure where you can prevent users from deleting, renaming, moving or unhiding worksheets. Password protection can be added to your Excel file in several ways.

How to Find and Replace Formatting in Word (such as Bold, Italic and Font)

How to Find and Replace Formatting in Word (such as Bold, Italic and Font)

You can find and replace formatting in Word by searching for specific formatting, such as bold or italic, and changing it to other formats. You or even search for text with specific formatting and change the text and the formats. With Find and Replace, you can search for and change both character and paragraph formatting.

How to View Word Count in Microsoft Word (4 Ways)

How to View Word Count in Microsoft Word (4 Ways)

You can view word count in a Microsoft Word document in several ways. Although word count is typically displayed in the Status Bar, you can view a Word Count dialog box which can be displayed using the Ribbon, the Status Bar or a keyboard shortcut. In addition to word count, you can check a document for the number of characters, lines, paragraphs and pages. Word count and other statistics are also available in Word Properties. 

How to Use Cell Styles in Excel to Save Time Formatting

How to Use Cell Styles in Excel to Save Time Formatting

You can apply cell styles in Excel worksheets to quickly format cells in a consistent way and automate repetitive formatting. Excel includes several built-in styles (such as Heading 1, Heading 2 and so on) and you can modify styles before or after you apply them. If none of the built-in styles fit your needs, you can also create a new style.

How to Display All Available Styles in a Word Document (Including Headings 1-9)

How to Display All Available Styles in a Word Document (Including Headings 1-9)

You can display all available styles in a Microsoft Word document using the Styles task pane. By default, only some of the available styles (including heading styles) are displayed in the Home tab in the Ribbon. There are 9 levels of heading styles that can be displayed as well as many other styles. In order to view all available styles, you will need to customize the Styles task pane.

How to Double Space in Word (4 Ways + Shortcut)

How to Double Space in Word (4 Ways + Shortcut)

You can double space in Word using a keyboard shortcut, the Ribbon, the Paragraph dialog box or even by modifying a style. If you double space a paragraph, you are setting the line spacing of the paragraph to 2.0. Since double spacing is a paragraph format, it's important to understand that a paragraph in Word is anything with a hard return after it (you pressed Enter or Return).

How to Align or Justify Text in Word (4 Ways with Shortcuts)

How to Align or Justify Text in Word (4 Ways with Shortcuts)

You can align or justify text or other content in Word in several ways including using keyboard shortcuts, selecting commands in the Ribbon, using the Paragraph dialog box or modifying a style. It's important to note that alignment or justification is paragraph formatting so applies to entire paragraphs. You can align text or inline graphics in paragraphs that are followed by a hard return (you pressed Enter or Return).

How to Show or Unhide the Quick Access Toolbar in Word, Excel and PowerPoint

How to Show or Unhide the Quick Access Toolbar in Word, Excel and PowerPoint

In 2021 and 365 versions of Word, Excel and PowerPoint, you now have the ability to hide or unhide the Quick Access Toolbar. So if your Quick Access Toolbar seems to have disappeared, it may simply be hidden. In 2021, Microsoft also removed Undo and Redo / Repeat  from the Quick Access Toolbar and moved these commands to the Home tab in the Ribbon.

5 Ways to Insert or Type the Square Root Symbol (√) in PowerPoint (with Shortcuts)

5 Ways to Insert or Type the Square Root Symbol (√) in PowerPoint (with Shortcuts)

You can insert or type the square root symbol in PowerPoint presentations using built-in commands or keyboard shortcuts. The square root symbol or radical sign can be entered in placeholders, text boxes or in equation blocks on PowerPoint slides. You can use an Alt code shortcut, a Math AutoCorrect entry or create an AutoCorrect entry as a custom shortcut.

How to Insert or Type the Delta Symbol in Excel (7 Ways to Insert Δ or δ)

How to Insert or Type the Delta Symbol in Excel (7 Ways to Insert Δ or δ)

You can insert or type the Delta symbol in Excel worksheets using built-in commands or keyboard shortcuts. The Delta symbol is the fourth letter of the Greek alphabet and corresponds to the letter D. Delta can be entered in upper case (Δ) or lower case (δ).​ You can insert the Delta symbol using the Insert Symbol command, the Symbol font, Alt code shortcuts, AutoCorrect shortcuts or a custom format. The Delta symbol can be entered in cells, text boxes and equation blocks in Excel.

How to Remove Duplicates in Excel (3 Easy Ways)

How to Remove Duplicates in Excel (3 Easy Ways)

You can remove duplicates in Excel in several ways. When you use the Remove Duplicates tool, Excel will keep the first instance and the remaining duplicates will be deleted in the data set. It's common to remove duplicates in a list or data set so that the data can be sorted, filtered and summarized. You'll need to decide what you consider to be a duplicate (based on one or more fields or columns).

How to Freeze Row and Column Headings in Excel Worksheets

How to Freeze Row and Column Headings in Excel Worksheets

As many Excel worksheets can become quite large, it can be useful to freeze row and column headings or freeze panes so titles are locked in place when you scroll through your worksheet. In Excel, you can freeze both row headings and column headings or just one.

How to Insert or Type the Degree Symbol in Excel (5 Ways to Insert °)

How to Insert or Type the Degree Symbol in Excel (5 Ways to Insert °)

You can insert or type the degree symbol in Excel using built-in commands, keyboard shortcuts or a custom number format. A custom number format can be applied to cells and would apply the degree symbol as a format rather than inserting it. The degree symbol can be entered in cells, equation blocks or text boxes. It is automatically entered in superscript. The term degree is used in several temperature scales including Celsius and Fahrenheit.

How to Combine Cells in Excel Using Concatenate (3 Ways)

How to Combine Cells in Excel Using Concatenate (3 Ways)

You can combine the data from multiple cells into another cell using the CONCATENATE operator or CONCATENATE functions. CONCATENATE is often used to combine text in cells (like first name and last name) but you can also combine text with numbers, dates, functions, spaces, commas or dashes. If you have Excel 2019 or a later version, you can also use the CONCAT function. It is important to note that combining cells is different from merging cells.

How to Merge Cells in Excel (4 Ways with Shortcuts)

How to Merge Cells in Excel (4 Ways with Shortcuts)

In Excel, you can merge cells using the Ribbon or the Format Cells dialog box. You can also access merge commands by right-clicking or using keyboard shortcuts. Typically, when a user wants to merge cells, they are trying to place longer headers in one cell (such as January Actual Sales). You can merge cells horizontally across columns or vertically across rows.

How to Use Flash Fill in Excel (4 Ways with Shortcuts)

How to Use Flash Fill in Excel (4 Ways with Shortcuts)

You can use Flash Fill in Excel to extract, combine, clean or format data quickly without using formulas. In order to use Flash Fill, Excel must be able to understand a pattern in a column to the left of the column where you want to fill the data so the source data should be entered in a consistent way. You can use Flash Fill by clicking a button, using shortcuts or by using the Fill handle.

How to Hide or Unhide Excel Worksheets (and Unhide All Sheets)

How to Hide or Unhide Excel Worksheets (and Unhide All Sheets)

You can hide or unhide Excel worksheets using the Ribbon, the right-click menu or keyboard shortcuts. If you hide worksheets, you can still reference them in other worksheets or workbooks. If you have Excel 365, you can now quickly unhide multiple worksheets or all worksheets. If you have trouble hiding or unhiding a worksheet, protection may have been enabled or a user has used VBA (Visual Basic for Applications) to hide the sheet.

4 Ways to Insert or Type the Pound Symbol in Word (£)

4 Ways to Insert or Type the Pound Symbol in Word (£)

You can insert the pound sign or symbol (£) in a Word document using built-in Word commands or keyboard shortcuts (including Alt code, AutoCorrect or built-in shortcuts). This article applies to the British currency symbol, not the pound sign (#) or hash tag.

How to Generate Random Text in Word

How to Generate Random Text in Word

If you are creating a Microsoft Word document, template or mockup and you want to create placeholder text, you can generate random text using the built-in RAND function or LOREM function (which generates Latin or Lorem ipsum text).

How to Show or Hide White Space in Word Documents

How to Show or Hide White Space in Word Documents

You can show or hide white space at the top and bottom of pages in Microsoft Word documents. If you hide white space, you won't be able to see headers or footers in Print Layout View or the gray space that typically appears at the top and bottom of pages as you scroll through your document.

How to Insert or Type Greek Letters or Symbols in Excel (6 Ways)

How to Insert or Type Greek Letters or Symbols in Excel (6 Ways)

You can insert or type Greek letters or symbols (such as Alpha, Beta, Delta, Gamma, Omega, Pi, Sigma or Theta) in Excel worksheets in several ways. These include inserting symbols using the Insert Symbol command, the Symbol font, Alt code shortcuts and AutoCorrect shortcuts. You can insert Greek letters in cells, text boxes and equations in Excel.

How to Insert Multiple Rows in Excel (4 Fast Ways with Shortcuts)

How to Insert Multiple Rows in Excel (4 Fast Ways with Shortcuts)

You can quickly insert multiple rows in Excel using the context menu, keyboard shortcuts or the Home tab in the Ribbon. The key to inserting multiple rows at once, rather than one by one, is to select the number of rows you want to insert first and then insert rows. Excel will insert the same number of rows you selected.

How to Reorder Objects in PowerPoint Using Bring to Front or Send to Back (with Shortcuts)

How to Reorder Objects in PowerPoint Using Bring to Front or Send to Back (with Shortcuts)

You can reorder objects on a PowerPoint slide using keyboard shortcuts, the context menu, the Ribbon or the Selection Pane. When objects are placed on a slide, they are stacked on top of each other. It's common to reorder objects to change the stacking order. When you select an object and Send to Back, it's moved to the bottom of the stack. If you choose to Send Backward, it's moved back by object. When you select an object and Bring to Front, it's moved to the top of the stack. If you choose to Bring Forward, it's moved forward by object.

Use Excel Conditional Formatting to Highlight Dates Before Today (3 Ways)

Use Excel Conditional Formatting to Highlight Dates Before Today (3 Ways)

You can use conditional formatting in Excel to highlight cells containing dates before today or within a date range before the current date. In a worksheet, you can use conditional formatting to highlight selected cells by filling them with a color based on rules or conditions. This type of formatting is helpful if you want to highlight past due dates such as invoices that are 30, 60 or 90 days overdue.

How to Loop a PowerPoint Slide Show to Repeat Automatically

How to Loop a PowerPoint Slide Show to Repeat Automatically

You can set up a PowerPoint slide show lo loop or replay automatically. A looping presentation can be used at events, trade shows or even in a reception area in an office. The easiest way to set up a slide show to loop is to apply automatic transitions and then configure Slide Show settings.

How to Crop a Picture into a Circle in PowerPoint (Crop Image to Shape)

How to Crop a Picture into a Circle in PowerPoint (Crop Image to Shape)

if you want to crop an image into a circle in PowerPoint, you'll need to combine cropping options. Crop options appear on the Picture Format or Picture Tools Format tab in the Ribbon. You can use these tools to crop a picture into an oval and then crop again to change the aspect ratio so the oval changes to a circle. In PowerPoint, you can achieve some great effects by cropping images to different shapes.

How to Stop Word from Changing Formatting Automatically

How to Stop Word from Changing Formatting Automatically

You can stop Word from changing formatting automatically in your documents by turning off AutoFormat As You Type settings in the AutoCorrect dialog box. If text or formatting is changing, there are several options you can turn off.

How to Find and Replace in Word (and Use Wildcards)

How to Find and Replace in Word (and Use Wildcards)

You can find and replace in Word using the Find and Replace dialog box as well as the Navigation Pane. If you use the dialog box, you can find and replace text and numbers and use wildcards for more advanced find and replace tasks. Wildcards are useful when you are not able to find an exact match. You can display the Find and Replace dialog box using a keyboard shortcut or the Home tab in the Ribbon.

How to Hide and Unhide Slides in PowerPoint (with Shortcuts)

How to Hide and Unhide Slides in PowerPoint (with Shortcuts)

You can hide slides in PowerPoint presentations so that they do not appear during a slide show unless you want to display them. Typically, you hide slides in Normal View or Slide Sorter View and then run your slide show. During a slide show, you can unhide slides or you can return to Normal View or Slide Sorter View and unhide them.

5 Ways to Insert or Type the Delta Symbol in PowerPoint (Δ or δ)

5 Ways to Insert or Type the Delta Symbol in PowerPoint (Δ or δ)

You can insert or type the Delta symbol in PowerPoint presentations using built-in commands or keyboard shortcuts. The Delta symbol is the fourth letter of the Greek alphabet and corresponds to the letter D. Delta can be entered in uppercase (Δ)  or lowercase (δ) in placeholders or text boxes on PowerPoint slides.

How to Hear a Word Document Using Speak (Text to Speech)

How to Hear a Word Document Using Speak (Text to Speech)

In Microsoft Word 2010 and later versions, you can have word speak or read a document aloud to you. You will need to add the Speak command to your Quick Access Toolbar or the Ribbon to use this feature. Once you've added the command, simply click Speak and Word will read the selected text aloud.

How to Select All in Word (6 Ways with Shortcuts)

How to Select All in Word (6 Ways with Shortcuts)

In Microsoft Word, you can save lots of time if you can quickly select characters, words, lines, paragraphs and blocks of text in your documents. You can use keyboard shortcuts or mouse shortcuts to select text.

3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells

3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells

You can apply strikethrough to text or values in Excel to cross out or create a line through a cell or part of a cell. There are 3 common ways to apply strikethrough in your Excel worksheets – using a built-in keyboard shortcut, using the Font dialog box, or by adding a command to the Quick Access Toolbar.

How to Lock the Position of a Slicer in Excel

How to Lock the Position of a Slicer in Excel

Slicers are a great tool in Excel to filter tables or pivot tables. You can lock the position of a slicer in an Excel worksheet using a two-step process. First, select the slicer or slicers and Disable resizing and moving in the Format Slicer task pane (and choose other options based on your preferences). Second, protect the sheet using the Review tab in the Ribbon. There are a few important options you'll need to select to get this to work.

How to Use Morph in PowerPoint to Design Engaging Presentations

How to Use Morph in PowerPoint to Design Engaging Presentations

If you have PowerPoint 2019 or 365, you can use the amazing Morph transition to morph one object into another (or multiple objects into other objects). Although you can apply Morph to create movement, you can also use other tricks like changing the size or formatting of text, shapes, pictures, SmartArt, WordArt and charts. Because it's a transition, not an animation, you'll need to create two slides to use Morph.

Why You Can't Group in PowerPoint (3 Common Issues)

Why You Can't Group in PowerPoint (3 Common Issues)

It's common to group objects in PowerPoint so you can move the objects together and apply formatting and animation to the group. However, you can't group certain objects. In this article, we'll discuss several situations where you can't group in PowerPoint as well as some solutions.

How to Insert a Nonbreaking Space in Word

How to Insert a Nonbreaking Space in Word

You can keep text together in several ways in Word. If you want to keep words or characters together, you can use nonbreaking spaces or nonbreaking hyphens or dashes and insert them using a dialog box or a keyboard shortcut. If you want to keep lines or paragraphs together on the same page, you can apply settings in the Paragraph dialog box (which can be built into styles if you use styles).

How to Create Headings in Word (Using Heading Styles)

How to Create Headings in Word (Using Heading Styles)

You can create headings in Microsoft Word documents by applying Word's built-in heading styles (such as Heading 1 or Heading 2). After you have applied styles, you can modify them and change the font, size, color, and other formatting attributes so the entire document will update. Once you have applied heading styles, you'll be able to navigate to the headings using the Navigation Pane and create a table of contents.

How to Update All Figure Numbers in Microsoft Word

How to Update All Figure Numbers in Microsoft Word

If you have inserted figure numbers for images or drawings in a Microsoft Word document, you can update them throughout the document and the figures will renumber automatically. This is helpful if you have moved or inserted new images. In order to renumber figures, the figure titles and numbers must be inserted as captions (using the References tab in the Ribbon). Since captions are fields, they can be updated in a couple of steps.

How to Insert Formulas and Functions in Word Tables

How to Insert Formulas and Functions in Word Tables

You can insert formulas in Word tables to perform basic calculations. These formulas can include functions such as SUM or AVERAGE or basic operators. When you insert formulas in Word tables, you are really inserting fields so the fields will need to be updated if the data in the table changes. For more complex calculations, it's usually best to create formulas in Excel where they will update automatically.

How to Change the Thumbnail for a Video in PowerPoint (using the Poster Frame Tool)

How to Change the Thumbnail for a Video in PowerPoint (using the Poster Frame Tool)

If you have inserted a video on a PowerPoint slide, you can display a custom thumbnail (or Poster Frame) for the video during a slide show. The thumbnail will display when you run a PowerPoint slide show and disappears when you start the video. For most videos, the thumbnail that displays is the first frame of the video clip. You can use the Poster Frame command to display a different frame in the video clip or a picture from another source as a thumbnail. A picture thumbnail could be either an image or an icon.

How to Add Audio in PowerPoint Presentations

How to Add Audio in PowerPoint Presentations

You can add audio in PowerPoint from a file on your PC or from a shared drive. Audio is played during a slide show and you can insert music, sound clips, or voice recordings. Since audio files are copied into PowerPoint presentations by default, they can increase file size and may need to be compressed. To play audio, your computer must be equipped with a sound card and speakers.

How to Highlight Text in PowerPoint (5 Ways)

How to Highlight Text in PowerPoint (5 Ways)

You can highlight text in PowerPoint in many different ways. If you have PowerPoint 2019 or 365, Text Highlight Color is available on the Home tab in the Ribbon. For those with older versions (without a Highlight command in the Ribbon), you'll need to use other strategies to highlight text. In this article, we'll review 5 ways to highlight text in PowerPoint. Most of these strategies will work in all versions.

How to Show Table Gridlines in Microsoft Word

How to Show Table Gridlines in Microsoft Word

If you work with tables in Microsoft Word, it's a good idea to show gridlines. Table gridlines don't print but borders do print. If borders are removed from a table, users may not recognize the table if gridlines are not displayed.

How to Search for Text in Word

How to Search for Text in Word

You can search for text in Word documents using the Navigation Pane or the Find and Replace dialog box. There are several advanced options for searching for text including using wildcards and matching upper and lower case.

How to Turn Off Automatic Bullets and Numbering in Word

How to Turn Off Automatic Bullets and Numbering in Word

You can stop automatic bullets or numbering in Word by changing AutoFormat As You Type Options in AutoCorrect settings. Automatic bullets and numbering are turned on by default but you can turn these options off or on when needed.

How to Turn Off Autofit in PowerPoint to Stop Automatic Formatting

How to Turn Off Autofit in PowerPoint to Stop Automatic Formatting

You can turn off Autofit to stop PowerPoint from changing font size automatically in placeholders, text boxes and shapes containing text. Depending on your preferences, you can turn Autofit off for objects in the current presentation or in all new presentations.

How to Remove Comments in Word (3+ Ways to Delete Comments)

How to Remove Comments in Word (3+ Ways to Delete Comments)

You can remove comments in Word by right-clicking, using the Review tab in the Ribbon or using the Inspector. The problem with comments is that they may be hidden if markup is not displayed. It's a good idea to display markup and then remove comments.

How to Change Slide Size or Dimensions in PowerPoint

How to Change Slide Size or Dimensions in PowerPoint

You can change slide size or aspect ratio in Microsoft PowerPoint from widescreen to standard or vice versa. Widescreen (16:9 aspect ratio) is the default in 2013 and later versions of PowerPoint and standard (4:3 aspect ratio) is the default in 2010 and earlier versions.

How to View Document Statistics in Microsoft Word

How to View Document Statistics in Microsoft Word

Microsoft Word automatically tracks statistics about your documents. These statistics appear in Word Properties and include the file name, directory, template, author, editing time, last print date and the user who last modified the document.

Where to Find Free Pictures for PowerPoint Presentations (10 Great Stock Image Sites)

Where to Find Free Pictures for PowerPoint Presentations (10 Great Stock Image Sites)

You can find beautiful free pictures that you can use in your PowerPoint presentations online. There are plenty of great stock photo sites that offer high-quality images at no charge. Images can make a big difference for audience engagement and can help your presentations look more professional. You can search for images on these sites by keyword and download images at different resolutions. Most of them allow personal and commercial use of images based on their license terms.

How to Create Templates in Microsoft Word

How to Create Templates in Microsoft Word

You can create, save, use and edit templates in Microsoft Word for frequently-used documents such as letters, reports, proposals and manuals. Templates include basic character, paragraph and page formatting and may include text, custom styles, tables, images, macros, sections, headers and footers.

To request this page in an alternate format, email our staff at info@avantixlearning.ca
Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.

Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca

Pin It on Pinterest