To bring currency symbol in MS Excel, select cells either through keyboard or mouse.
How to bring currency symbol in MS Excel?
The other way to do this is select the first cell and press 'CTRL+C' and then use 'SHIFT+↓' (Down Arrow Key) to select other cells and then press 'CTRL+D'.Copy (CTRL+C) the first cell where you have written the formula, now press 'SHIFT+↓' (Down Arrow Key) to select other cells and then press Enter key.Copy the first 'Total' cell that has the formula and hold the bottom-right corner of the cell from the mouse and drag to other cells.Īll the dragged over cell will be filled wit the formula and sum will be displayed like below.To copy the same formula to other corresponding rows of the records in the range, we can do any of following The same can be achieved by press Auto sum icon from Editing group on the Ribbon as shown below. This will automatically insert SUM function with range of numberic data in that row. Go to G4 cell and press 'CTRL+=' key, hit ENTER key. How to quickly insert SUM function in MS Excel? Similarly to go to the last cell from the range of data press 'CTRL+END', to go to the starting cell from the range of data press 'CTRL+HOME'. To jump to the last row within range press 'CTRL+↓' (CTRL+Down Arrow Key) To jump to the last column within range press 'CTRL+→' (CTRL+Right Arrow Key) Many a times when you may have loads of rows and columns in your spreadsheet and you want to quickly jump to the last row or last column of your data, scrolling column by column or row by row is a tough task. How to quickly move to the last column and last row of range of data in Excel? To select right columns, hold SHIFT key and press → key. A column data in this range) press 'CTRL+SHIFT+↓' (CTRL+SHIFT+Down Arrow Key). To select entire column of range of data (eg. To select downwords rows, hold the SHIFT key and press ↓ key. Select the A3 cell by clicking on it and then press 'CTRL+SHIFT+→' (CTRL+SHIFT+Right Arrow Key). Let's assume that we have to select the header row of below data. To know basic selection of cells, rows and columns read here. How to select entire row of the ranage of data in Excel? To select the entire spreadsheet, press 'CTRL+A' twice. Place your mouse in any cell of data (In this case, my cursor is in A3), now press 'CTRL+A' this will select the entire range of data as shown below. How to select entire range of data in Excel sheet? This helps in improving the productivity of the user. Keyboard shortcuts are a way to perform frequently used activities quicker with the combination of keys rather than following few steps through mouse. In this post we shall learn about Keyboard shortcuts in Excel. In the previous post, we learnt about Named range and Named constant.