Apply Formatting to multiple objects in PowerPoint Select all the items. Apply the new formatting (for example, change the color of the object, or resize) to one of the selected items. Any formatting changes will be applied to all the
Microsoft PowerPoint: Apply the Same Formatting to Multiple Items Read Post »
Create a named group of cells to be used in formulas or to quickly navigate back to the group. To do so, first, select the group of cells to be named. In this case, we will use a list of
Excel: Create a named group of cells Read Post »
When working in PowerPoint you may have a need to make sure that the font(s) used in a presentation are consistent. You can easily find and replace fonts by using the Replace Fonts feature.To use Replace Fonts:1. From the Home
Microsoft PowerPoint: Find and Replace Fonts in a Presentation Read Post »
To add a query in a 2016 Excel spreadsheet, click the Data tab, then click the drop down for New Query command. This will open a display box that allows you to choose the workbook you want to run the
New in 2016 – Queries are coming to Excel! Read Post »
Microsoft PowerPoint allows you to make one color in a .jpg file transparent. This is useful when you want to remove solid color backgrounds from logos or other graphics. To set transparent color: From the Picture Tools Section, click the
Making One Color Transparent in a JPEG in Microsoft PowerPoint Read Post »
In some large Excel workbooks a dependent cell may refer to a precedent cell on another worksheet or many rows or columns away. The Excel Watch Window lets you see the dependent cell adjust as you make changes to the
Excel Watch Window Read Post »
You can quickly advance to any slide during a PowerPoint slide show by simply typing in the number of the slide you want to display, and pressing enter. PowerPoint will skip any slides between the current slide and the target
Advancing Slides in a PowerPoint Slide Show Read Post »
Use Excel patterns as another way to color code your cells in Microsoft Excel. Select the cells you want to edit. Click on the drop down arrow in the bottom right corner of the font group under the Home Tab.
Fill Patterns in Excel Read Post »
PowerPoint automatically applies Hyperlink color formatting to email addresses, URLs and hyperlinks in PowerPoint. To change this color:1. Select the Design Tab. 2. In the Themes Group, click on the drop down next to the Colors button.3. Scroll to the
Changing the Color of the Hyperlink Formatting In PowerPoint Read Post »
One of the most common questions we get about Excel is how to print spreadsheets. Spreadsheet content tends to be irregularly shaped and doesn’t fit on an 8.5 x 11 sheet well. Excel has a few tools for controlling how
Excel Printing Guide Read Post »
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
