google search

Monday, February 25, 2019

Microsoft Excel Office Button

The Office button

This button appears at the top of the Excel window, left-clicking the button, a menu appears.
  • You can select and create a new spreadsheet from this menu, open existing spreadsheet files, save spreadsheet files in a different way, (e.g. saving your workbook in the default file format, or saving the workbook in the XML-based and macro-enabled file format, or saving in a binary file format optimized for fast loading and saving, or saving in a compatible with excel 97-2003) and also print spreadsheet File.
  • It also allows you to add security features, publish your work, send files, and also close files.

You want to change the default Excel Options

  • Click the Excel Options button. (A dialog box will appear)
  • To access a variety of Excel options, Select a category on the left.
  • Modify any of the default settings and click on
  • OK.
As a beginner, it is best to leave the default settings. But there will be time when you may want to change some settings as you learn more about the program and become more proficient at it 

Want to learn how to Create a workbook?

Want to learn how to insert text and numbers into Excel workbooks to be able to use it to calculate, organize and analyze data.

In this article, you will learn how to create a new workbook, how to insert and delete text, how to navigate a worksheet, and also save an Excel workbook.






Creating a new blank workbook

  • Left click the Microsoft Office button.

  • Select and click New command, (the New Workbook dialog box appears, and Blank Workbook is highlighted by default.
  • Click Create. A new blank workbook appears in the window.
Opening Excel for the first time, the program opens to a new blank workbook.

How to Insert text in the New workbook created?

  • Left-click a cell to select it
Each rectangle in the worksheet is called a cell. As you select a cell, the cell address appears in the Name Box.
  • Enter text into the cell using your keyboard. Notice that the text appears in the cell and in the formula bar.

No comments:

Post a Comment