Thursday, August 27, 2015

How to customize the Ribbon

You customize the Ribbon in the Customize Ribbon tab of the Excel Options dialog box (see Figure 3-1). The quickest way to display this dialog box is to right-click anywhere in the Ribbon and choose
Customize the Ribbon


Figure 3-1: The Customize Ribbon tab of the Excel Options dialog box. 

Customizing the Ribbon is very similar to customizing the Quick Access toolbar, which is described in Tip 2. The only difference is that you need to decide where to put the command within the Ribbon. Here’s the general procedure: 
1.  Right-click any part of the Ribbon, and choose Customize the Ribbon. Excel displays the 
Customize Ribbon tab of the Excel Options dialog box. 
2.  Use the drop-down list on the left (labeled Choose Command From) to display various 
groups of commands. 
3.  Locate the command you want in the list box on the left and select it. 
4.  Use the drop-down list on the right (labeled Customize the Ribbon) to choose a group of tabs. 
Main Tabs refers to the tabs that are always visible; Tool Tabs refers to the context tabs that appear when a particular object is selected. 
5.  In the list box on the right, select the tab and the group where you want to put the command. 
You must click the “plus sign” controls to expand the hierarchical lists. Remember that you cannot add commands to built-in groups, so you may need to use the New Tab or New Group buttons to add a tab or group. 
6.  Click the Add button to add the selected command from the left to the group on the right. 
When you are finished making your Ribbon changes, click OK to close the Excel Options dialog box

New tabs and groups are given generic names, so you’ll probably want to give them more meaning-
ful names. Use the Rename button to rename the selected tab or group. You can also rename built-in 
tabs and groups. 
Although you cannot remove a built-in tab, you can hide the tab by unchecking the check box next 
to its name. 
Figure 3-2 shows a part of a customized Ribbon. In this case, I added a group to the View tab. The 
new Text To Speech group has five commands. I inserted this new group between the Zoom and the Window groups. 



Customizing the Ribbon

Tip 2 describes how to customize the Quick Access toolbar by adding Ribbon commands, but some users prefer to make some changes to the Ribbon itself.
You can customize the Ribbon in these ways:
      
Add a new tab.
Add a new group to tab.
Add commands to a group.
Remove groups from a tab.
Remove commands from custom groups. Change the order of the tabs.
Change the order of the groups within a tab. Change the name of a tab.
Change the name of a group.
Reset the Ribbon to remove all customization's.
That’s a fairly comprehensive list of customization options, but you cannot do some actions:
      
You cannot remove built-in tabs — but you can hide them.
You cannot add commands to built-in groups.
You cannot remove commands from built-in groups.

You cannot change the order of commands in a built-in group. 

Note :

Unfortunately, you can’t customize the Ribbon (or Quick Access toolbar) by using VBA 
macros. However, developers can write Ribbon X code and store it in workbook files. 
When the file is open, the Ribbon is modified to display new commands. Writing 

Ribbon X is relatively complicated and is the subject of several complete books. 

Performing other Quick Access toolbar actions

Performing other Quick Access toolbar actions
Here are some other things you can do with your Quick Access toolbar:

 Rearrange the Quick Access toolbar icons. If you want to change the order of your Quick
     Access toolbar icons, you can do so on the Customization tab of the Excel Options dialog
    
box. Select the command and then use the up- and down-arrow buttons on the right to
     move the icon.
Display the Quick Access toolbar below the ribbon. To change the position of the Quick
     Access toolbar, choose the down-pointing arrow control and select Show below the Ribbon.
 Remove Quick Access toolbar icons. The easiest way to remove an icon from your Quick
     Access toolbar is to right-click the icon and choose Remove from Quick Access Toolbar. You
     can also use the Quick Access Toolbar tab of the Excel Options dialog box. Just select the
     command in the list on the right and click the Remove button.
 Share your Quick Access toolbar. Use the Import/Export button to save a file that contains
    
your Quick Access toolbar customization. You can then share this file with others.
    
Unfortunately, this file also contains any Ribbon customization's that you might have made
     (see Tip 3). In other words, you can’t share your Quick Access toolbar without also sharing
    
your Ribbon customization's.

 Reset the Quick Access toolbar. If you want to return the Quick Access toolbar to its default
     state, display the Quick Access Toolbar tab in the Excel Options dialog box and click the
    
Reset button and choose Reset Only Quick Access Toolbar. All your customization's disap-
     pear, and the Quick Access toolbar then displays its three default commands. 

Saturday, May 9, 2015

Customizing the Quick Access Toolbar

Customizing the Quick Access Toolbar

About the Quick Access toolbar
By default, the Quick Access toolbar is located on the left side of the Excel title bar, and it includes
three tools:

Save: Saves the active workbook.
       ➤ Undo: Reverses the effect of the last action.
       ➤ Redo: Reverses the effect of the last undo

Commands on the Quick Access toolbar always appear as small icons, with no text. When you hover your mouse pointer over an icon, you see the name of the command and a brief description.
As far as I can tell, the number of icons that you can add to your Quick Access toolbar is limitless. But
regardless of the number of icons, the Quick Access toolbar always displays a single line of icons. If
the number of icons exceeds the Excel window width, it displays an additional icon at the end: More
Controls. Click the More Controls icon, and the hidden Quick Access toolbar icons appear in a pop-up
window.

Adding new commands to the Quick Access toolbar
You can add a new command to the Quick Access toolbar in three ways:

Click the Quick Access toolbar drop-down control, which displays a down-pointing arrow
and is located on the right side of the Quick Access toolbar (see Figure 2-1). The list contains several commonly used commands. Select a command from the list, and Excel adds it to your Quick Access toolbar.
Right-click any control on the Ribbon and choose Add to Quick Access Toolbar. The control is
    
added to your Quick Access toolbar, positioned after the last control.
Use the Quick Access Toolbar tab of the Excel Options dialog box. A quick way to access this
    
dialog box is to right-click any Quick Access toolbar or Ribbon control and choose Customize
     Quick Access Toolbar. 

Figure 2-1: The Quick Access toolbar drop-down menu is one way to add a new command to the Quick Access
toolbar


Figure 2-2 shows the Quick Access Toolbar tab of the Excel Options dialog box. The left side of the dialog box displays a list of Excel commands, and the right side shows the commands that are now on the Quick Access toolbar. Above the command list on the left is a drop-down control that lets you filter the list. Select an item from the drop-down list, and the list displays only the commands for that item.

Figure 2-2: Use the Quick Access Toolbar tab in the Excel Options dialog box to customize the Quick Access
toolbar.


Some of the items in the drop-down list are described here:

Popular Commands: Displays commands that Excel users commonly use.
Commands Not in the Ribbon: Displays a list of commands that you cannot access from the
     Ribbon.
All Commands: Displays a complete list of Excel commands. Macros: Displays a list of all available macros.
File Tab: Displays the commands available in the back stage window.
Home Tab: Displays all commands that are available when the Home tab is active. In addition, the drop-down list contains an item for every other tab.
Sometimes, you need to do some guessing to find a particular command. For example, if you want to
add the command that displays the Excel Options dialog box, you can find it listed as Options, not
Excel Options. 

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
     headings.
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
code.

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.