Microsoft Office Tips & Tricks

Microsoft Word

Function	Instructions
Selection Techniques	Select a sentence – Control + Click Nonadjacent selection – Control + drag to highlight Vertical selection – Alt + Drag Selection bar Select a line – Click once Select a paragraph – Click twice Select the entire document – Click three times Open page setup dialog box – Double-click ruler
Formatting	Format Painter – Clipboard group-click once or click twice to use multiple times Increase or Decrease Font – Control + Shift + < or > Clear formatting – Tool in Font group. Control + Q (paragraph formatting) Control Spacebar (character formatting) Ligature font – Gabriola, Style set 6 or 7
Best Shortcut Ever	Displays the save dialog box – F12
Undo	Control + Z
Redo	Control + Y
Insert Page Break	Control + Enter
Character Format	Bold – Control + B Italic – Control + I Underline – Control + U
Repeats an Action	F4
Create Random Text	Generate random text =rand() or number of paragraphs and lines =rand(10,5)
Table of Contents	Apply headings from the Home Tab. References > Table of Contents

Function	Instructions
Remove Duplicates	Data > Remove Duplicates
Freeze Headings	View > Freeze Panes > Freeze Top Row or First Column
Print Titles	Page Layout > Print Titles
Data Validation (drop down)	Data > Data Validation
Copy by Example (Flash Fill)	Control + E or Data > Flash Fill
Format Multiple Worksheets	Select Multiple Tabs (control + click); changes are made to all selected sheets
Linking Worksheets	Click in cell. Type = Switch to sheet that contains data to link and press Enter

Functions	Instructions
Set Transparent Color	Click on image. Picture Format > Color > SetTransparent Color
Remove Background	Click on image. Picture Format > Remove Background
Fill Text with Graphic	Insert Text Box, enter text. Increase font. Click on Text Box. Shape Format > Text Fill > Picture Choose desired picture.
Using WordArt to Fill Text with Segmented Graphic	Insert > WordArt > Choose a Text Style Enter approximately 12 hyphens. Select the Text Box and increase font size to approximately 200. Shape Format > Text Effects > Transform Choose desired Warp option. Shape Format > Text Fill > Picture Choose desired picture.
Video Behind Text	Insert > Video > Online Videos Choose desired video for background. Insert > Text Box > Draw large rectangle Enter your text. Insert > Shape Draw large rectangle over Text Box, size to same dimensions. Select Text Box and Shape (use Shift for multiple selections) Shape Format > Merge Shapes > Combine