Microsoft Office Articles | Avantix Learning
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)
You can double space in Word using the Ribbon, the Paragraph dialog box, a keyboard shortcut or 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)
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
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)
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 δ)
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 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 °)
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 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)
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 (£)
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 Convert Text to Numbers in Excel (5 Ways)
Here are 5 different ways to quickly convert numbers stored as text to numbers in a Microsoft Excel worksheet. You can use a Smart Tag, Paste Special or …
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
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)
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)
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.
4 Ways to Insert or Type the Euro Symbol in Word (€)
You can insert the euro symbol or sign (€) in a Word document using built-in Word commands or keyboard shortcuts (including Alt code, AutoCorrect or built-in 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.
How to Use Kerning in Microsoft Word to Adjust Letter Spacing
Kerning can be used in Microsoft Word to increase or decrease the spacing between characters. You have the option of turning on automatic kerning or you can manually control kerning by expanding or condensing spacing.
How to Insert or Type the Division Symbol in Word (5 Ways to Insert ÷ with Shortcuts)
You can insert the division symbol in a Word document using Insert Symbol, a keyboard shortcut, an AutoCorrect entry or an Alt shortcut. The division sign or symbol is different from the division operator used in calculations in a Word table or in Excel (/).
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 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 Insert the Mu or Micro Symbol in Word (µ)
How to Insert or Type the Delta Symbol in Word (Δ)
How to Copy Formatting in Word (3 Easy Ways with Shortcuts)
You can insert the square root or radical symbol (√) in a Word document using built-in Word commands or keyboard shortcuts.
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