How to move data in Excel Select the data you want to move, right click on it then select the cut option then select the cell where you want to shift the data. Right click on the selected cell and select paste option. Data will be moved to the desired location.
How to delete data, rows and columns in Excel How to Delete Data Select the data you want to delete, right click on it then select delete option from the menu. You can also delete it by pressing Delete key on the keyboard. See the image: How to Delete a Row Select the row by…
Read more
How to select data in Excel There are various options to select data. The most common way is a left click on the cell then dragging the mouse over the data you want to select. Start from the upper-left cell of the data, as cell B3 in the image given below:
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