Tuesday, April 14, 2015

Microsoft Office Changing the Look of Excel Cosmetic changes

Cosmetic changes
When the preview version of Microsoft Office 2013 became available, there was a minor uproar
About its appearance. Compared to previous versions, the applications looked “flat” and many complained about the overall white colour.

When the final version was released, Microsoft added two alternative Office themes: light gray and dark gray. To switch to a different theme, choose FileOptions to display the Excel Options dialog box. Click the General tab and use the Office Theme drop-down list (see Figure 1-1). The theme
choice affects the appearance of the title bar, row and column borders, task panes, the taskbar, and a few other items. The theme you choose applies to all other Office 2013 applications. 

Figure 1-1: Selecting a different Office theme.

Figure 1-1 shows another option: Office Background. Use this drop-down list to select a background image that appears in the Excel title bar. Fortunately, one of the options is No Background.

Hiding the Ribbon
To hide the Ribbon, click the Ribbon Display Options drop-down menu in the Excel title bar. You’ll see the choices shown in Figure 1-2.
                                                                     Figure 1-2: Choosing how the Ribbon works. 

Using options on the View tab
The View tab, shown in Figure 1-3, has three groups of commands that determine what you see on-screen.
Workbook Views group: These options control the overall view. Most of the time, you’ll use
Normal view. Page Layout view is useful if you require precise control over how the pages
are laid out. Page Break Preview also shows page breaks, but the display isn't nearly as nice.
     The status bar has icons for each of these views. Custom Views enable you to create named
     views of worksheet settings (for example, a view in which certain columns are hidden).
Show group: The four check-boxes in this group control the visibility of the Ruler (relevant
     only in Page Layout view), the Formula bar, worksheet gridlines, and row and column
Zoom group: These commands enable you to zoom the worksheet in or out. Another way to
zoom is to use the Zoom slider on the status bar. 
                                                                                 Figure 1-3: Controls on the View tab. 

Hiding other elements
To hide other elements, you must make a trip to the Advanced tab of the Excel Options dialog box (choose FileOptions). Figure 1-4 shows workbook display options and worksheet display options. These options are self-explanatory. 
                                            Figure 1-4: Display options on the Advanced tab of the Excel Options dialog box. 

Hiding the status bar
You can also hide the status bar, at the bottom of the Excel window. Doing so, however, requires VBA

1.  Press Alt+F11 to display the Visual Basic Editor.
2.  Press Ctrl+G to display the Immediate window.
3.  Type this statement and press Enter:
Application.DisplayStatusBar = False

The status bar will be removed from all open workbook windows. To redisplay the status bar, repeat those instructions, but specify True in the statement. 

No comments:

Post a Comment