How to enter data in Excel Select a cell with a single click where you want to enter data; cell B3 is selected in the image given below. Then double click in the cell to enter data. You can enter text, numbers and formulas in the cell. After entering data, you can press Tab key…
Read more
Moving across the worksheet in Excel There are multiple options to move across the worksheet using mouse and keyboard. You can scroll the work sheet up or down by rolling mouse wheel or using vertical scroll bar. In a similar way, you can use horizontal scroll bar to move the work sheet horizontally towards left…
Read more
Worksheet, Rows, Columns and Cells in Excel Worksheet Worksheet is also called spreadsheet. It is made up of rows, columns and cells. Rows Rows run horizontally across the worksheet and ranges from 1 to 1048576. A row is identified by the number that is on left side of the row, from where the row originates.…
Read more
Title Bar, Help Button, Zoom Control and View Buttons Title Bar It lies next to the quick access toolbar or on top of the excel window. It displays the name of the open document. Help Button It lies on top right corner of the excel window beside the option to minimize the window. It is…
Read more
Mini Toolbar in Excel It is a floating toolbar that appears above the shortcut menu when you right click a cell or other objects like a shape or chart. It displays commonly used formatting commands like Bold, Italics, Font Size and Font Color.
Quick Access Toolbar in Excel It is a customizable toolbar located beside the quick access button and above the home tab. When you click the down arrow at the end of quick access toolbar it displays more commands. You can add any of these commands to quick access toolbar by a left click on the…
Read more
Features of the Tabs in Excel There are many tabs available in Microsoft Excel: Home, Insert, Page Layout, Formula, Data, Review and View. Each tab has different features. The features of the Home tab are: Clipboard, Font, Alignment, Number, Cells and Editing The features of the Insert tab are: Tables, Illustrations, Charts, Links, Text The…
Read more
Ribbon and Tabs in Excel Ribbon is on the top of worksheet, below the title bar or name of the excel file. It contains seven tabs: Home, Insert, Page Layout, Formulas, Data, Review and View. Each tab has its own specific groups of related commands. These groups have several additional commands that can be viewed…
Read more
Office Button in Excel It is on the top left-corner of excel. When the office button is clicked, you will find a number of options to perform various tasks that are listed below: New: To create a new file. Open: To open an existing file on the computer. Save: To save changes made in the…
Read more
Excel vs. Google Sheets Microsoft Excel MS Excel is the spreadsheet program developed by Microsoft that helps in doing data storage, data manipulation, and data mining and to bring out the information which can help in the strategic decision-making process. Google Sheet It is similar to MS Excel, and Google Sheet is also a spreadsheet…
Read more