MS OFFICE TIPS AND TRICKS

ExcelImage result for excel

Create a Backup Copy of a Sheet

This is great when you want to duplicate a sheet, so you can make changes without screwing up the original.
  1. Left-click and hold on the sheet you want to copy.
  2. Press and hold the Ctrl key. A plus symbol will appear in the sheet mouse icon.
  3. Drag the sheet to the right until the down arrow appears to the right of the sheet.
  4. Release the left mouse button. Then release the Ctrl key.
  5. 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.

Image result for powerpoint

PowerPoint

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 SaveUndoRepeat 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.

CCC full logo-white

  • Web Outreach, Message and Content
  • Digital Marketing, SEO and Social Media
  • Responsive and Mobile Friendly

5335 Wisconsin Avenue, NW, Suite 640 Washington, DC 20015

202-785-8000 x101
info@cccsolutions.com

Copyright 2016 © All Rights Reserved