google search

Monday, February 25, 2019

Want to Learn Excel Quickly?

How to modify/adjust columns, rows, and cells

 Saving your Work in Microsoft Excel 

 Learn to change page views in a worksheet


  •  Locate the Page View options in the bottom-right corner.
  • Notice that the Options there include the Normal view, Page Layout view, and Page Break view. Click any one of the option to select it.

     


Want to add commands to the Quick Access toolbar?

Follow this guide to add commands to the Quick Access toolbar

  • Click on the arrow to the right of the Quick Access Toolbar.
  • Select the command you wish to add from the drop-down list. It will appear in the Quick Access Toolbar.
For example, to add a New Command button to the Quick Access Tool bar, you have to see step above
  • Click on the arrow to the right of the Quick Access toolbar, A drop down list appear
  • Select the New Command button from the drop down list
  • Notice the New Command button added to the Quick Access Toolbar.

OR
  • Select More Commands from the menu, (a dialog box will appear)
  • Select the command you want to add.
  • Click the Add button.
  • Click OK.
The three commands, Undo, Redo and save commands appear by default in the Quick Access Toolbar. You may want to add other commands to use Excel features very convenient.

You probably Want to remove commands from the Quick Access toolbar?

·         Click on the arrow to the right of the Quick Access toolbar.
·         Select and click on the command that you wish to remove from the drop-down list. It will disappear automatically 

Want to minimize and maximize the Ribbon

  • Click the drop-down arrow next to the Quick Access Toolbar.
  • Select Minimize Ribbon from the list. The Ribbon disappears.
  • To maximize the Ribbon, click the arrow again, then select Minimize the Ribbon to toggle the feature off.
The new tabbed Ribbon system replaces menus in Excel 2007. 
It is created to be easy to use and responsive to your task, minimizing the Ribbon is a great ideal if you would prefer to use other menus or shortcuts keys.
  • By right-clicking anywhere in the main menu and selecting Minimize the Ribbon in the menu that appears means you are minimizing and maximizing the Ribbon.

No comments:

Post a Comment