MS Word 2016
Master Documents and Subdocuments in MS Word 2016
One of the most useful features of MS Word is the management of large documents and their subsections, which allows users to collaborate documents by separating sections into different files. Subdocuments make it easy to update and export parts of a large document.
The tool is also great for smaller documents that have independent sections. In MS Word 2016, you don’t have to create subdocuments when you first create your Master Document. You can identify a document as the Master Document and then proceed to identifying the subdocuments within it, which can be split or merged with other subdocuments. Here’s a “how to” article to help you: https://www.addictivetips.com/microsoft-office/how-to-create-a-master-document-and-subdocuments-in-ms-word-2016/
To keep the column or row names static while you scroll through the data, you can freeze the panes to help keep track on the data you’re looking at.
To freeze panes, click on the cell below the column heading and to the right of the label for each row, then to go View > Freeze Panes > Freeze Panes to make the column headings stay still so you can see them at all times.
Create a Backup Copy of a Sheet
- Left-click and hold on the sheet you want to copy.
- Press and hold the Ctrl key. A plus symbol will appear in the sheet mouse icon.
- Drag the sheet to the right until the down arrow appears to the right of the sheet.
- Release the left mouse button. Then release the Ctrl key.
- It sounds like a lot, but once you get the hang of it you will wonder how you ever lived without this trick. It’s much faster than right-clicking the tab and going to the Move or Copy… menu.
You can also first select multiple sheets with the Shift key, then use the same method to copy multiple sheets at the same time.
Ctrl+Enter To Fill Multiple Cells
This keyboard shortcut can save time when entering the same formula in multiple cells.
- Select the cells that the formula will be inserted in.
- Type or insert the formula or text in the active cell.
- Hold the Ctrl key and press Enter. The formula or text will be copied to all the selected cells.
Bonus tip: If you have a single cell selected, then Ctrl+Enter can be used to keep that cell selected after you edit the formula. Typically, the next cell will be selected after hitting Enter. Press Ctrl+Enter to keep the same cell selected.
Apply Special Formatting to Numbers and Currency in Cells
If you need to apply a specific currency value or determine the decimal place for
numbers in your spreadsheet, you can use the Numbers tab within the Format Cells dialog to do so.
Select the numbers you would like to format, right click the selection then select the Numbers tab. Select Currency in the Category list, then choose the number of decimal places and currency format.
Use the Quick Access Toolbar
The Quick Access Toolbar (QAT) is located at the very top of the PowerPoint window. It gives you the possibility to keep access to your favorite features at all time. Features in the QAT will be actionable whatever tab you are currently on. By default, it contains the Save, Undo, Repeat and Start from beginning commands.
To customize your QAT, the easy way is to just click on the drop-down arrow at the right of the QAT. You can then click More commands. You will view two lists of PowerPoint commands. The list on the left is the exhaustive list commands, while the list on the right is the list of commands in the QAT. Select your favorites from the left list and click on Add to add them to the QAT. They will now be accessible at the top of the PowerPoint window anytime.
The 10/20/30 Rule
It’s called it the 10/20/30 Rule of PowerPoint. According to the 10/20/30 rule, a PowerPoint presentation should have ten slides, last no more than twenty minutes, and contain no font smaller than thirty points.