RSS
 

Posts Tagged ‘Microsoft’

Microsoft Excel 2010 – Hide Worksheet Tabs, Scroll Bars if Not Needed

08 Aug

If you’re only using one worksheet in an Excel 2010 workbook, why display the worksheet tabs if you’ll never use them? Also learn how to hide one or both scroll bars if not needed.

While some complicated Microsoft Excel 2010 workbooks may have dozens, if not more worksheets, you may sometimes create workbooks that only require one worksheet tab. In this case, why show the worksheet tabs if you don’t need to use them? By hiding these tabs, and also the horizontal and / or vertical scroll bars, you can slightly increase the room onscreen used to display your workbook.

1. Open the workbook you wish to modify….

Read more at MalekTips.
New Computer and Technology Help and Tips – MalekTips.Com

 
Comments Off on Microsoft Excel 2010 – Hide Worksheet Tabs, Scroll Bars if Not Needed

Posted in Technology

 

Microsoft Outlook 2010 – Show Week Numbers in the Calendar

06 Aug

Add week numbers when viewing Outlook 2010 calendars to calculate meeting dates that must occur every 3 or 4 weeks instead of monthly.

It might prove useful when viewing calendars in Microsoft Outlook 2010 to show week numbers. Perhaps there is an ongoing project where participants convene for a status review every three weeks, or you might have a regular lunch networking group that meets every four weeks or so instead of monthly.

The following tip shows how to add week numbers when viewing calendars in Month view, or when displaying calendars in the To-Do Bar:…

Read more at MalekTips.
New Computer and Technology Help and Tips – MalekTips.Com

 
Comments Off on Microsoft Outlook 2010 – Show Week Numbers in the Calendar

Posted in Technology

 

Microsoft Publisher 2010 – Designing a Document for the Screen? Show Pixels in the Ruler

06 Aug

If you are designing a document in Microsoft Publisher 2010 that is meant for on-screen display rather than as a hardcopy, change the ruler measurement units to pixels.

Are you designing a document in Microsoft Publisher 2010 that is meant to be displayed onscreen rather than printed?

If so, the default ruler measurement units of inches or centimeters may not make much sense. With a simple tweak, you can change Publisher 2010’s on-screen rulers to show measurements in pixels….

Read more at MalekTips.
New Computer and Technology Help and Tips – MalekTips.Com

 
Comments Off on Microsoft Publisher 2010 – Designing a Document for the Screen? Show Pixels in the Ruler

Posted in Technology

 

Microsoft PowerPoint 2010 – Stop Asking to Save Ink Annotations!

06 Aug

Prevent PowerPoint 2010 from even asking to save ink annotations after a presentation.

When you give presentations with Microsoft PowerPoint 2010, you might choose to use the Pen or Highlighter tools. These can draw attention to a portion of a slide, draw shapes, write text, etc.

After exiting a presentation, PowerPoint 2010 asks if you want to save these ink annotations. However, if you give the same presentation to multiple audiences, the annotations may only be for the benefit of one group of people and do not need to be kept. So why have PowerPoint ask you this when you can configure an option that automatically discards them?…

Read more at MalekTips.
New Computer and Technology Help and Tips – MalekTips.Com

 
Comments Off on Microsoft PowerPoint 2010 – Stop Asking to Save Ink Annotations!

Posted in Technology

 

Microsoft Excel 2010 – Quick Tip: Add a Manual Line Break

24 Jul

A keyboard shortcut to manually add a line break inside a cell.

If you have a lot of text that needs to be placed inside a cell in a Microsoft Excel 2010 workbook, you could decrease the size of the font to fit more text inside, but do so too much and the text will become ineligible. You could increase the cell width, but this affects every cell in the column. And you could merge neighbor cells together so the text flows automatically to the right, but depending on your layout this may not be feasible.

Or, one other option is to wrap the text in a cell. But pressing ENTER while typing data into a cell moves the cell pointer down, so how can this be done? …

Read more at MalekTips.
New Computer and Technology Help and Tips – MalekTips.Com

 
Comments Off on Microsoft Excel 2010 – Quick Tip: Add a Manual Line Break

Posted in Technology

 

Microsoft Excel 2010 – Working on a Wide Worksheet? Make ENTER Move to the Right

20 May

If you’re editing a wide worksheet with the 10-key, you might find it more convenient to have the ENTER key move the cursor to the cell to the right.

By default, when editing a worksheet in Microsoft Excel 2010, you can press the Tab key to move the selection cursor to the cell to the right, and Enter moves to the below cell.

If you’re editing a wide worksheet with a 10-key, you might find it more convenient to have the Enter key move to the cell to the right, just like the Tab key. The following shows you how to make this change. In fact, you can have Enter move up or to the left, if desired:…

Read more at MalekTips.
New Computer and Technology Help and Tips – MalekTips.Com

 
Comments Off on Microsoft Excel 2010 – Working on a Wide Worksheet? Make ENTER Move to the Right

Posted in Technology

 

Microsoft Outlook 2010 – Display Formatting Marks When Editing Email

20 May

Display formatting marks for paragraphs, spaces, tabs, and other characters when editing e-mails and other items in Outlook 2010.

You may have Microsoft Word 2010 configured to show formatting marks when editing documents. Examples of these marks include dots to signify spaces (to help ensure you don’t have too many between words), right arrows to signify tabs (to differentiate between tab characters and just a group of spaces), and pilcrows to signify new paragraphs.

If you are accustomed to seeing these marks you can enable them in Microsoft Outlook 2010 when editing e-mails, even when doing so in plain-text mode:…

Read more at MalekTips.
New Computer and Technology Help and Tips – MalekTips.Com

 
Comments Off on Microsoft Outlook 2010 – Display Formatting Marks When Editing Email

Posted in Technology

 

Microsoft PowerPoint 2010 – Change Default AutoRecover and Presentation File Locations

20 May

Change the default directory where PowerPoint 2010 presentations are saved as well as where AutoRecover files are kept.

By default, as with other Office 2010 applications, Microsoft PowerPoint 2010 defaults to the user Documents directory to save presentations. AutoRecover files, useful if PowerPoint 2010 or your system crashes before a document is saved, are placed in the user’s AppData directory. For example, on standard Windows 7 installations, documents default to the C:\ Users\ YOUR_USER_NAME\ Documents folder, and AutoRecover files are stored at C:\ Users\ YOUR_USER_NAME\ AppData\ Roaming\ Microsoft\ PowerPoint.

If you have multiple hard drives and/or partitions, you may have one designated to keep data files and documents separate from programs and your operating system. Thus, moving these default locations to the other hard drive or partition might prove quite useful. And here’s how to do so:…

Read more at MalekTips.
New Computer and Technology Help and Tips – MalekTips.Com

 
Comments Off on Microsoft PowerPoint 2010 – Change Default AutoRecover and Presentation File Locations

Posted in Technology

 

Microsoft Word 2010 – Prevent Paste Options Button from Appearing

20 May

When pasting text into a Word 2010 document, hide the Paste Options button that tends to appear.

For the most part, when you paste text into a Microsoft Word 2010 document (unless the text has no formatting information), you will see a Paste Options button appear, labeled with “(Ctrl)”. Press the Ctrl key or click this button to access formatting options such as keeping the source formatting, merging the formatting, pasting only the text, and setting the default paste options.

If you do not frequently have to make formatting changes to pasted text, you might find this button annoying and wish it disabled. To do so:…

Read more at MalekTips.
New Computer and Technology Help and Tips – MalekTips.Com

 
Comments Off on Microsoft Word 2010 – Prevent Paste Options Button from Appearing

Posted in Technology

 

Microsoft Publisher 2010 – Hide Recent Publications List or Show More

02 May

For privacy, configure Publisher 2010 not to show the list of your recent publications. Or, show more of them.

By default, Microsoft Publisher 2010 displays a list of your recent publications when selecting “Recent” from the Backstage View. This lets you quickly access publications that you have previously edited, especially useful if you save documents on a wide array of folders and/or network locations.

If you find this feature useful and work on a large number of publications, you may wish Publisher 2010 to show more recent documents. On the other hand, if you are concerned about privacy you may wish Publisher 2010 to not show this information. To make either configuration change:…

Read more at MalekTips.
New Computer and Technology Help and Tips – MalekTips.Com

 
Comments Off on Microsoft Publisher 2010 – Hide Recent Publications List or Show More

Posted in Technology