Services
Printing in Excel
In previous versions of Excel, the Print command and the Print Preview window were two separate options. In Excel 2010, the Print tab in Backstage View provides access to print settings and a preview pane. If you are looking for a specific print option, click here to review the Print tab in Excel 2010.
The most frequent questions with Microsoft Excel are always about printing. Electronic spreadsheets have always proven difficult to print. This week, take a look at the Print tab in Backstage view in Excel 2010. All of the previous Excel print options are available but they hide behind a group of drop-downs. Click here to learn more about printing in Excel 2010.
One of the valuable new features included with Office 2010 is the capability to restore unsaved documents (in Word) and workbooks (in Excel).
This is a question that users have posed for years. If keystrokes are stored in temporary memory while we type then the computer should be able to find that information after an unexpected close or shut-down. Microsoft has finally provided an answer to that dilemma. The secret is the Save settings under Options. Be certain you have AutoRecover set for a specific number of minutes. Once an unsaved workbook is open past the specified AutoRecover timeframe, the data will be recoverable. Click here to learn how to verify your Save settings are correct.
Microsoft made big changes in naming conventions and nomenclature with the launch of Office 2010. Apparently, they listened to folks who were frustrated that the menus disappeared in Office 2007 and they made one concession. They returned the File tab in place of the Office Button. At the same time, they changed the naming convention. This is no longer the File menu but the File navigation bar. And when you make a selection from the File navigation bar, the Backstage view opens. All of this nomenclature does affect the way we work. Click the File tab to open the navigation bar then select an option. When you have completed your work in Backstage view, press the <Esc> key or click the Home tab to close Backstage view. To learn more about the changes to the Recent option in Backstage view, click here.
One more Excel 2007 tip for May: using Print Titles. The Print Titles feature can now be accessed from a Command Button on the Page Layout Ribbon in the Page Setup group. This command allows you to select one or more rows that should be printed at the top of each page of a printed worksheet. You can also use the Print Titles command to select one or more columns that should be printed at the left of each page of a printed worksheet. Click here to learn to use this command button in Excel 2007.
Click here to learn how.
In previous versions of Microsoft Excel, the Format menu provided options for column widths and row heights. Those commands have been moved to the Home Ribbon in the Cells group. If you are having problems using AutoFit to widen multiple columns, click here to discover a shortcut that might help.
Click here to learn how.
Some menu commands and toolbar buttons from earlier versions of Excel are difficult to locate on the Ribbon. The Clear All command has always been accessible from the Edit menu. In Excel 2007, the command has been moved to the Editing group on the Home Ribbon. The Select Objects button was always available from the Drawing toolbar. It, too, is located in the Editing group in both Word and Excel. Click here to see how to locate both commands.
Click here to learn how.
Office 2007 applications introduced several new features with the Recent Documents list. First, the list may be expanded to include up to 50 recently-used files. Second, files may be pinned to the Recent Documents list to prevent them from scrolling out of the list. The Recent Documents updates apply to Word, Excel, and PowerPoint. Click here to find out how to use these new features.
Click here to learn how.
In Office 2007 applications, the spell check feature uses a Main dictionary to check commonly misspelled words. It also relies on a Custom dictionary where you control the words that are added. Many users add words when running spell check in a document, spreadsheet, presentation or even an Outlook email. Occasionally, a misspelled word is added by mistake. This week’s tip tells you how to access the Custom dictionary in order to remove unwanted words.
Click here to learn how.
Microsoft Office 2007 applications have added a new Zoom Slider feature to the application window. If you are familiar with Adobe products, you have used Zoom slider buttons. In Microsoft Word 2007, a new icon has been attached to the top of the vertical scroll bar. This icon will automatically display the vertical and horizontal rulers or hide them from view. Click here to learn more about both of these new features.
click here
In Microsoft Word 2007, the Spacing Before and Spacing After commands have been conveniently added to the Page Layout Ribbon in the Paragraph command group. Unfortunately, users are disappointed when they select a group of paragraphs and attempt to use the Spacing Before or Spacing After commands on the Ribbon. By default, when Word 2007 is installed, a new setting has been applied to paragraph formats. It is necessary to open the Paragraph dialog box to remove the setting in order for Spacing Before or Spacing After to apply to multiple paragraphs of the same style. Click here to see where the setting appears and how to disable it.
click here
Through the years, Microsoft has assigned various names to text entries that may be stored for playback. In the early versions of Microsoft Word under DOS, we used a Gallery to store frequently-used words, technical phrases, or entire blocks of text. This Gallery nomenclature has resurfaced in Office 2007. Microsoft now uses the term Building Blocks to refer to portions of text such as a Cover Page. When you want to build your own phrases or store text, use the Quick Parts feature that is part of the gallery. Click here to learn to build your own Quick Parts in Word 2007.
click here
Setting Default Font and Paragraph Style in Word Tip of the Week April 4
One frequently-asked question about Microsoft Word 2007 and 2010 is: How do I change the default font? How do I reset paragraphs so they will be single-spaced? How do I remove the spacing that appears after paragraphs? For both questions, changing the Default Font and Paragraph settings will resolve these issues. In Word 2007, the default font style is Calibri 11-point. Very few corporate standards use the Calibri font or multi-line paragraph spacing. Follow these directions to set the defaults for Microsoft Word to match your standards.click here
Building a Jump List Tip of the Week March 28
Recent documents may also be accessed from an application icon on the Start menu in Windows 7. But first, the application icon must be pinned to the Start menu. Click here for instructions on building a Jump List for an application. click here
Windows 7 Recent Documents Tip of the Week March 21
In Windows XP, recent Documents could be accessed from the Start menu. There is no longer a Documents option on the Windows 7 Start menu. Is there a way to restore that option? Recent documents are now accessed from an application icon pinned to the Taskbar or to the Start menu. Click here to learn how to pin an application to the Taskbar. click here
Windows 7 File Properties Tip of the Week March 14
File properties in Windows 7 are readily available at the bottom of the Windows Explorer window. Once tags or author names are added to a file, files may be arranged using those field. To learn to add tags, author names or categories to File Properties, click here.
Microsoft Excel 2007 Tip of the Week Feb 21
Did you know Excel 2007 contains a Show Formulas command button? It is conveniently located on the Formulas Ribbon and will display all formulas in a worksheet. Look in the Formula Auditing group on the right side of the Formulas Ribbon. The keyboard shortcut to display all formulas is still Ctrl ~.
Tip of the Week: February 14
Microsoft Word and Excel 2007 Shortcuts
Familiar keyboard shortcuts and function key actions have not changed in Microsoft applications. Microsoft Word function key assignments were first created in the DOS version of Word. These shortcut keys are even more expedient in Office 2007 applications without drop-down menus.
For a list of keyboard shortcuts and function key actions in Microsoft Word 2007, click here:
For a list of keyboard shortcuts and function key actions in Microsoft Excel 2007, click here:
Tip of the Week: February 7
Microsoft Office 2007
Very few revisions were made to dialog boxes from earlier versions of Excel, Word and PowerPoint. To access familiar dialog boxes, click on the Dialog Box Launcher diagonal arrow on selected groups on the Ribbon. The diagonal arrow is located on the bottom right of the Ribbon under the last command button in each group.
Click here to find out how..
Tip of the Week: January 31
Microsoft Office 2007
Customize the Quick Access Toolbar to restore your commonly used command buttons from the Standard and Formatting toolbars from earlier versions of Word, Excel and PowerPoint. Move the Quick Access Toolbar below the Ribbon to allow room for as many command buttons as you like.
Click here to find out how.
