It contains two parts – on the left is the name box (it stores the cell address) and on the right is the contents of the currently selected cell. You can also collapse the ribbon to provide extra space in the worksheet by pressing the keyboard shortcut Ctrl + F1 or by right-clicking anywhere on the ribbon and then clicking “ Collapse the Ribbon”.Įxcel’s Formula bar is the area just below the Excel Ribbon. You can type the feature that you are after and Excel will find it for you. There is also a search bar available next to the tabs which was introduced in Excel 2019 and Office 365. Once you click on that arrow, a dialog box will open and you can make further edits using that. You can access other features related to that group by clicking on the small arrow at the end of each Group. For Example – Under the Home Tab, all font-related buttons are clubbed together under the Group name “ Font”. Under each Tab, there are various buttons grouped together. This will create a New Tab called “ Custom” with a popular command “ Center“. Step 4: Now you can add the commands that you want under each group by simply clicking on the command from the Popular Command column and click on Add > Step 3: Select that newly created tab and click on Rename and give it a name e.g. Step 2: An Excel Options dialog box will open, click on the New Tab. Step 1: Right-click on the ribbon and click on “ Customize the Ribbon” You can even customize these Tabs using the following steps: You should be familiar with these tabs so you can understand how to use Excel efficiently. View Tab can be used to change the view of the Excel Sheets and make it easy to view the data.Review Tab can be used to insert comments, protect the document, check spelling, track changes, etc.Data Tab can be used to get external data, sort filter and group existing data, etc. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |