Microsoft Products Articles

Article / Updated 10-03-2022

The most common kind of view you create in a SharePoint app is a public, Standard view. A public view can be used by anyone to view the contents of an app. Standard views have the following traits: They’re accessible by all browsers, including Firefox, Chrome, and Safari. They have the most configuration options, such as filtering, grouping, and editing options. They’re available for all apps. They don’t require any special columns for configuring the view. Other view formats, such as a Calendar view, require date columns. To create a new Standard view: Browse to the app where you want to create the new view. Click the List or Library tab of the Ribbon to access options for managing views. In a Calendar app, click the Calendar tab to manage the app’s views. Click the Create View button. A list of view format options appears. Click the Standard View link to create a view that looks like a web page. After selecting your view format, the Create View page displays your options for creating the new view. In the View Name field, type the name you want to call this view. Give the page a name that's easy to remember. For example, if your view will group products by department, entering the name GroupByDepartment creates a web page named GroupByDepartment.aspx. You can change the friendly name after the filename has been created. The View Name field has two purposes: It provides the friendly name that can be selected to display the view. It provides the filename for the web page, which is part of the web address. To set this view as the default view for the app, select the Make This the Default View check box. If this isn’t the default view, users can select the view from a drop-down list on the Ribbon. In the View Audience field, select the Create a Public View radio button. Optionally, you can create a private view that only you can see. You must have at least Designer or Owner permissions to create a public view. In the Columns section of the page, select the Display check box next to any columns you want to display. You can also indicate the relative order that columns appear on the screen by selecting the appropriate number in the Position from Left drop-down lists. (Optional) In the Sort section, use the drop-down lists to select the first column you want to sort by and then select the second column to sort by. The default sort option is ID, which means that items will be sorted by the order they were entered in the list. Select the remaining options to configure your view, such as the columns you want to filter or group on. Some of the options you can choose from are Select Tabular View to include check boxes next to items for bulk operations. Select the style that the view will take. For example, Boxed, Shaded, Newsletter, Preview Pane, or Basic style. In the Totals section, select which columns to aggregate using Count, Average, Minimum and Maximum functions. In the Folders section, specify whether items should appear inside folders or flat as if the folders don’t exist. Item Limit allows you to limit the items displayed on a single page. This can improve the performance of the view. Click OK to create the view. The new view appears in the browser. If you created a public view, SharePoint creates a new web page using the name you specified in Step 5. Users can select this view from the drop-down list in the Manage Views section of the Ribbon. Experimenting with all these options is the best way to discover what works for your site. Item Limits, for example, is great for when you want to control the amount of space a web Part takes up on a page.

Article / Updated 10-03-2022

With the keyboard shortcuts shown here, you can switch among various views in Word 2016. Other key combinations enable you to save time with simple tasks, such as copying text from one place and pasting it somewhere else in your document. Switch to this view With the keyboard Print Layout Alt+Ctrl+P Outline Alt+Ctrl+O Draft Alt+Ctrl+N

Article / Updated 10-03-2022

By touching a couple of keys in combination, you can save time with simple tasks in Word 2016, such as copying text from one place and pasting it somewhere else in your document. With these keyboard shortcuts, you can speed up text editing and formatting in Word 2016. To do this With the keyboard Start a new line in the same paragraph Shift+Enter Insert a page break Ctrl+Enter Insert a column break Ctrl+Shift+Enter Clear formatting Ctrl+spacebar Make text subscript Ctrl+= Make text superscript Ctrl+Shift++ Delete one character to the left Backspace Delete one word to the left Ctrl+Backspace Delete one character to the right Delete Delete one word to the right Ctrl+Delete

Article / Updated 10-03-2022

In Word 2016 you can insert common symbols by using these keyboard shortcuts. Use these keyboard shortcuts instead of the Insert→Symbol command to insert common typographical symbols. Symbol Shortcut Em dash Alt+Ctrl+minus sign En dash Ctrl+minus sign Copyright Alt+Ctrl+C Registered trademark Alt+Ctrl+R Trademark Alt+Ctrl+T Ellipsis Alt+Ctrl+period

Article / Updated 10-03-2022

In Excel 2016, use the following keyboard shortcuts instead of the Number drop-down list on the Home tab to apply number formatting to Excel worksheet cells. To apply this number format Use this key combination General Ctrl+Shift+~ Currency with two decimal places, negative numbers in parentheses Ctrl+Shift+$ Percentage, no decimal places Ctrl+Shift+% Scientific, two decimal places Ctrl+Shift+^ Date format with day, month, and year Ctrl+Shift+# Time format with hour and minute, AM or PM [email protected] Number format, two decimal places, thousands separator, minus sign for negative values Ctrl+Shift+!

Article / Updated 09-30-2022

In Excel 2016, you can use the following keyboard shortcuts to enter and format data. To do this Use the key combination Enter the current time Ctrl+Shift+: Enter the current date Ctrl+; Apply an outline border Ctrl+Shift+& Remove an outline border Ctrl+Shift+_ Display or hide formulas in cells Ctrl+` Display Format Cells dialog box Ctrl+1 Hides selected rows Ctrl+9 Hides selected columns Ctrl+0

Article / Updated 09-30-2022

By touching a couple of keys in combination in Office 2016 programs, you can save time with simple tasks, such as copying text from one place and pasting it somewhere else. The keyboard shortcuts included here work equally well in Word, Excel, and PowerPoint 2016. Both mouse and keyboard methods are provided here. To do this With the mouse With the keyboard Open a file File→Open Ctrl+O Create a new file File→New Ctrl+N Print active document File→Print Ctrl+P Save your work (first time), or resave with same settings File→Save Ctrl+S Save your work with different name, location, or type File→Save As F12 Copy selection to Clipboard Home→ Copy Ctrl+C Cut selection to Clipboard Home→ Cut Ctrl+X Paste selection to Clipboard Home→ Paste Ctrl+V Open the Paste Special dialog box Home→Paste→Paste Special Ctrl+Shift+V Display shortcut menu for selected item Right-click item Shift+F10 Left-align a paragraph Home→ Left Align Ctrl+L Center a paragraph Home→ Center Ctrl+E Right-align a paragraph Home→ Right Align Ctrl+R Make text bold Home→ Bold Ctrl+B Make text italicized Home→ Italic Ctrl+I Make text underlined Home→Underline Ctrl+U Make text larger Home→Increase Font Size Ctrl+> Make text smaller Home→Decrease Font Size Ctrl+< Undo previous action Undo button on Quick Access toolbar Ctrl+Z Redo previous Undo Redo button on Quick Access toolbar Ctrl+Y Insert hyperlink Insert→Hyperlink Ctrl+K Get help Type in Tellme what you want to do box F1 Close the active file File→Close Ctrl+F4 Close the application Close button on application window Alt+F4 Check spelling Review→Spelling F7

Step by Step / Updated 09-16-2022

You can add text comments to particular cells in an Excel 2013 worksheet. Comments act kind of like electronic pop-up versions of sticky notes. For example, you can add a comment to yourself to verify a particular figure before printing the worksheet or to remind yourself that a particular value is only an estimate. In addition to using notes to remind yourself of something you’ve done or that remains to be done, you can also use a comment to mark your current place in a large worksheet. You can then use the comment’s location to quickly find your starting place the next time you work with that worksheet. To add a comment to a cell, click on the cell to which you want to add the comment and follow these steps:

Step by Step / Updated 09-15-2022

In PowerPoint 2016, a hyperlink is simply a bit of text or a graphic image that you can click when viewing a slide to summon another slide, another presentation, or perhaps some other type of document, such as a Word document or an Excel spreadsheet. The hyperlink may also lead to a page on the web. Adding a hyperlink to a presentation is easy. Just follow these steps:

Article / Updated 09-14-2022

Previous versions of PowerPoint included a feature called WordArt that let you insert special objects that could incorporate fancy text effects, such as gradient fills or curved paths. For PowerPoint 2016, Microsoft has integrated WordArt into PowerPoint, so that you can apply WordArt formatting to any bit of text in your presentation just by highlighting the text and applying the WordArt formats. The figure shows an example of what you can do with WordArt in just a couple of minutes. You, too, can create fancy text effects like this using WordArt. Follow these steps to transform mundane text into something worth looking at: Select the text you want to apply WordArt formatting to. The text can be anywhere in your presentation. For example, you can apply WordArt formatting to a slide title or body text. Click the Drawing Tools Format tab. The Drawing Tools Format tab includes a WordArt Styles group, shown here. As you can see, this Ribbon group includes several pre-configured WordArt styles as well as buttons that let you control the text fill, outline style, and text effects such as shadows and glowing. The WordArt Styles group on the Drawing Tools Format tab. Click the More button found at the bottom of the scroll bar to the right of the predefined WordArt styles. The WordArt Quick Styles gallery appears, as shown here. The WordArt Quick Styles gallery. Select the WordArt style that most closely resembles the formatting you want to apply. Don't worry if none of the gallery choices exactly match the effect you want; you can tweak the text's appearance later. Fool around with other WordArt controls in the WordArt Styles group of the Drawing Tools Format tab. Buttons on the WordArt Drawing Tools Format tab Following are the other controls in the WordArt Styles group. Experiment with these controls as much as you want until you get the text to look just right. Text Fill: Sets the fill color. The fill can be a simple color, a gradient (which blends two or more colors), a picture, a pattern, or a texture. Text Outline: Sets the properties of the text outline. You can select a color, a pattern, and a thickness. Text Effects: Lets you apply fancy text effects such as shadows, reflections, glowing text, beveled text, 3-D rotations, and transforms. The Text Effects button is the key to creating fancy logos, such as text that wraps around circles or text that has a three-dimensional look. When you click this button, a menu with various text formatting options appears: Shadow: Adds a shadow to the text. The shadow can be directly behind the text, or it can appear beneath the text, which creates the impression that the text is floating above an invisible surface. Reflection: Creates a faint reflection on an invisible surface beneath the text. Glow: Adds a glowing effect to the text. Bevel: Adds a beveled effect to the text, which creates the impression that the text has been chiseled from a solid object. 3-D Rotation: Rotates the text around three dimensions. Transform: Transforms the overall shape of the text.