Lesson 1, Topic 1
In Progress

1.6. Use MS Excel to adjust settings to customise the view and preferences to suit the solution created for the given problem

ryanrori February 3, 2021

[responsivevoice_button rate=”0.9″ voice=”UK English Female” buttontext=”Listen to Post”]

After completing this section, the learner will be able to adjust settings to customise the view and preferences of the spreadsheet application to suit the solution created for the given problem, by successfully completing the following:
⦁ Switch toolbar menus off and on
⦁ Enlarge and make the view of the spreadsheet smaller
⦁ Change the way that the spreadsheet is viewed
⦁ Freeze cells to prevent scrolling
⦁ Change the default file location
⦁ Add a user name to the file

Microsoft Office 2010 continues the dedication to both making Microsoft Office products more available to people with disabilities, as well as helping all users create more accessible content. In addition to many features that you might be familiar with, Office 2010 includes several new and updated accessibility features.
Office 2010 has applied the Fluent user interface, or the ribbon, to all Office applications, providing a consistent look across applications. Additionally, to aid users who move through the ribbon by using their keyboard, it is now possible to jump from Group to Group by pressing Ctrl + Right/Left Arrow on a ribbon tab to move to the next/previous Group.
Additionally, you can now customise your ribbon, making it even easier to find the functions you use most often. Word 2010, Excel 2010, and PowerPoint 2010 include an Accessibility Checker to help you create more accessible content. Accessibility Checker runs automatically while you author your file, identifying areas that might make it challenging for users who have disabilities to view or use it. Through the Accessibility Checker task pane, opened from the Backstage view , you can review and fix potential problems with your content.

Switch toolbar menus off and on
The new design in Microsoft Office 2010 that returned the File tab When you click the File tab, you see the same basic commands that were available like Open, Save, and Print. Some commands, such as Import, have been moved to the ribbon.
The ribbon is designed to help you quickly find the commands that you need to complete a task. Commands are organised in logical groups that are collected together under tabs. Each tab relates to a type of activity, such as writing or laying out a page. To reduce screen clutter, some tabs, known as contextual tabs, are shown only when they are needed. When the ribbon is minimised, you see only the tabs.
You can minimise the ribbon to make more space available on your screen or customise the ribbon to personalise the ribbon the way that you want it. For example, you can create custom tabs and custom groups to contain your frequently used commands.


Full ribbon

Minimised ribbon

To always keep the ribbon minimised
⦁ Right-click the ribbon, and then click Minimise the Ribbon.
Keyboard shortcut  To minimise the ribbon, press CTRL+F1.

To use the ribbon while it is minimised, click the tab you want to use, and then click the option or command you want to use.
For example, with the ribbon minimised, you can select text in your Microsoft Excel document, click the Home tab, and then in the Font group, click the size of the text that you want. After you click the text size that you want, the ribbon goes back to being minimised.

Keep the ribbon minimised for a short time
⦁ To quickly minimise the ribbon, double-click the name of the active tab. Double-click a tab again to restore the ribbon.
Keyboard shortcut  To minimise or restore the ribbon, press CTRL+F1.

To minimise the ribbon, click Minimise the Ribbon. The Minimise the Ribbon button is in the upper-right corner of the program window.

Restore the ribbon
⦁ Right-click the ribbon, and then click Minimise the Ribbon.
⦁ To restore the ribbon, click Expand the Ribbon. The Expand the Ribbon button is in the upper-right corner of the program window.

You can still use the keyboard shortcuts while the ribbon is minimised.