To delete rows with duplicated data, follow these steps:
To quickly total a column or a row, in the last cell, hit |Alt + =| (equal to sign). You will find this box right next to the fFormula Bar 4 Total a Column or a Row You can see the name box highlighted in the red box. Press F2 to edit the formula in your first cell.In the name box, type in the address of the last cell of the range, where you want to fill data or formula and hit |Shift + Enter|.Go to the first cell that you would like to copy or fill in other cells.When tip #2 doesn’t work because there’s a blank cell between your starting cell and the end cell of your range or you don¢t want to drag a formula down to 1000 rows, try this: Hover to the bottom-right corner of the cell with the formula (you will notice that the cursor has turned to a thick black plus sign).|Ctrl + minus sign|: will give you Delete optionsįor a complete list of keyboard shortcuts, visit: 2 Copy Formula Down.|Shift + Space|: will select row(s) of your active cell(s)v.|Ctrl + Space|: will select column(s) of your active cell(s).|Shift + Space|: will select row(s) of your active cell(s).|Ctrl + Down Arrow|: will take you to the last cell of your active column.|Ctrl + Up Arrow|: will take you to the first cell of your active column.|Ctrl + Home|: will take you to the first cell of your data.
|Ctrl + End|: will take you to the last cell of your data.|Ctrl + V|: will paste the copied data (or object).|Ctrl + C|: will copy the selected data (or object).|Ctrl + A|: will select all of the data.You will save tons of time and make moves like a ninja once you master the keyboard shortcuts. Look no further: in this article you will see 15 tips and tricks in Excel to save time and get known by your peers as an Excel ninja. Have you been looking for Excel Advanced Tips and Tricks to make you faster and save your time?
0 kommentar(er)
