We at theapptimes.com have written numerous app tips this year to help both novices and power users working with the popular Office 2010 application. In this post, let’s re-look some of the top Office 2010 tips we shared this year with our readers. You can take a print out and pin it up your dashboard for a quick reference too.
Top Office 2010 Tips in:
Microsoft PowerPoint 2010
How to Remove a SmartArt Animation
Select the SmartArt graphic, on the Animations tab, in the Animation group, click No Animation.
How to Copy Animations from One SmartArt Graphic to Another
Select the object, on the Animations tab, in the Advanced Animation group, click Animation Painter. Navigate to the slide you want to apply the copied animation and click the object you want to apply the animation effect.
How to Change Clip Art Colors in PowerPoint 2010
Select the Clip Art image. In the Picture Tools Format contextual tab, in the Adjust group, click Color and from the gallery, select a color option.
How to Play PowerPoint Slide Show Continuously
On the Slide Show tab, in the Set Up group, click Set Up Slide Show. In the Set Up Show dialog box, in the Show options section, check the Loop continuously until ‘Esc’ check box and click OK.
Resize Multiple Objects in a PowerPoint Slide Simultaneously
To resize multiple objects in a slide simultaneously, select the objects by Shift-clicking and then drag the corners of the objects to resize them uniformly. Keep the Shift key depressed to ensure that the individual aspect ratios of the objects are maintained.
How to Moving Objects in a PowerPoint Slide
To move an object in a PowerPoint slide, select the object and press Ctrl+ Any arrow key.
How to Change the Orientation of a Slide in PowerPoint
Select the Design tab, in the Page Setup group, click Slide Orientation and select Portrait or Landscape.
Microsoft Outlook 2010
Display Several Days Side by Side in Outlook Calendar
In the Calendar view, in the left pane, in the Calendar, select the first date, then Ctrl+click the other days you want to view.
How to Change the Time Interval in Outlook Calendar
In Calendar view, on the View tab, in the Arrangement group, click Time Scale. From the drop-down list, select the desired time interval you want to display in the calendar.
How to Delete an RSS Feed
Simply select the folder you no longer wish to read and press Delete. In the Microsoft Outlook message box, click Yes to confirm the deletion.
How to Move to A Calendar View from Another View
If you frequently use the Outlook 2010 calendar, a quick way to get there from the Mail view is to press Ctrl+2. You can actually press Ctrl+A from any view to display the Outlook calendar.
How to Go to a Specific Date In Outlook 2010 Calendar
Press Ctrl+G to find a specific date in the Calendar. Pressing Ctrl+G will open the Go To Date dialog box, from which you can choose a date and a calendar view.
Keyboard Shortcut to View Specific Days in the Outlook Calendar
If you want to check five days beginning May 15th on your Outlook calendar, select May 15th and then press Alt+5. The Outlook calendar will display May 15th through 20th.
How to Switch Between the Weeks and Month View in Outlook 2010 Calendar
If you want to navigate between the Weeks view and the Month view in Outlook 2010, all you need to do is press Alt+- (the character to the right of the zero key.) and Alt+=. Alt+- will take you to the Weeks view and Alt+= will take you to the Month View.
Keyboard Shortcut for Advanced Find Feature in Outlook 2010
To use the Advanced Find feature in Outlook 2010, press Ctrl+Shift+F.
How to Search for Text Within an Open Item in Outlook
Press F4 to search for text within an open item in Outlook 2010.
How to Quickly Send a Message in Outlook 2010
If you have composed an email message, you can press Alt+S or Ctrl+Enter to send the message to the recipient.
How to Resend an Email from Office Outlook 2010
Open the message you want to resend. In the Move group, click Actions and select Resend This Message.
Microsoft Word 2010
How to Add an Automatic Border to Your Word Document
On the Home tab, in the Paragraph group, you can click the Border button to select the border you want to insert in your document.
How to Move Text Up or Down a Paragraph
Lets assume that on page 1, you want to move the fourth paragraph above the third paragraph. You can do this by clicking within the fourth paragraph, holding down Alt+Shift and pressing the Up arrow key. You can continue to press the arrow keys to move up or down one level. You can also use this shortcut to move rows of text within tables, or move bulleted/numbered lists.
How to Select Text Vertically
Simply press Alt and drag down to select the text.
How to Position the Cursor Above a Table in a Word Document
Place the cursor in the first row and first cell of the table and press Enter.
How to Check Formatting Inconsistencies in Word 2010
If you want Word to auto-check your documents for inconsistencies in formatting, select the File tab and choose Options. In the Word Options dialog box, select Advanced. In the Advanced tab, in the Editing options section, check Keep track of formatting and Mark formatting inconsistencies check boxes and click OK.
How to Automatically Update the Date in a Word Document
If you have a letter template that needs to reflect the current date every time you use the template, select the Insert tab, and in the Text group click Date & Time. In the Date and Time dialog box, check the Update automatically check box.
How to Change the Casing of Words
Press SHIFT+F3 to change the case of selected text from lower case to sentence case. Press SHIFT+F3 again to change the case to All Caps.
How to Insert a Bullet in Between a Sentence In Word 2010
To insert a bullet in between a sentence, hold down Alt and press 0183.
Microsoft Excel 2010
How to Change the Standard Font Of Excel Text
The standard font set for Excel text is the Body Font. If you wish to change the default font in Excel, simply navigate to the File tab, choose Options, and in the When creating new workbooks section, from the Use this font drop-down list, select the desired font and click OK.
How to Change the Default Number of Worksheets
You probably know that when you open a workbook, three worksheets are displayed by default. To add or reduce the number of worksheets displayed, select the File tab and choose Options. In the When creating new workbooks section, choose the number of worksheets you want to set as the default number by moving the up or down arrow and click OK.
How to Join Two or More Cell Values in Excel
To join 2 cells in Excel simply use the formula, =A1&A2. If you need a space between the two values, then use the formula =A1&” “&A2.
How to Convert All Text in Excel to Lowercase
Using this simple Excel formula =LOWER(Cell Reference) will convert the text in your cell to lowercase.
How to Convert All Text in Excel to Proper Case
=PROPER(A1) will convert the text in your cell to proper case.
How to Quickly Add a Border to Selected Cell
If you want to add an outline border around selected cells in your Excel sheet, press Ctrl+Shift+7.
How to Insert a New Worksheet in Excel 2010
Press Shift+F11 to insert a new worksheet in a workbook. You could also click the Insert Worksheet button on the worksheet tab.
How to Set Options to Manually Calculate Formulas
There may be instances when you want to change a cell value in one or more formulas, but you do not want Excel to automatically recalculate the changes as a result thereof. In such instances, you can set the option to manually calculate figures, by selecting the File tab and choosing Options. In the Excel Options dialog box, select the Formulas tab. In the Calculation options section, select manual update. You can check the Recalculate workbook before saving option if required and click OK.
Change the Behavior of the Enter Key in Excel 2010
Select the File tab and choose Options. In the Excel Options dialog box select Advanced. In the Editing Options section, from the Direction drop-down list, select an option and click OK.
Daily App Tips is a one- or two liner that displays a quick way of accomplishing a task. You can check out all our tips in the Daily App tips section on our blog. If you have a tip or two that you’d like to share with our readers, drop us a line at editor@theapptimes.com and we’d be happy to post them on our blog.
About Adeline
