Top useful tips for MS Excel part 2 

To insert a new row or column, use Ctrl+Plus, this brings up the insert dialog box, you can select insert an entire row, an entire column,

 

To highlight an entire row, use Shift+Space, to highlight an entire column use Ctrl+Space.

 

To remove an entire column, Ctrl+Minus, but if you wanna avoid the dialog box, we're gonna highlight the entire column first, and then we're gonna do Ctrl+Minus. If you wanna drag an entire row and drop it somewhere else,

 

To hide a column use Ctrl+0, to hide an entire row, use Ctrl+9. When I first receive a new workbook from someone else, I wanna check if anything has been hidden in there or not. The shortcut key I use is Alt+; That highlights the visible cells only, and this way I get a visual indication that some rows and columns have been hidden. If nothing comes up, nothing is highlight, it means that no rows or columns have been hidden. For updating information herewe use the shortcut key Ctrl+;, and if we wanna add the time to it we gonna add a space and use Ctrl+: and press enter.

 

One bonus tip: when we receive a new file, and we wanna highlight all the constants in that file, we press F5, Alt+S, O, X, Enter. This highlights all the numbers that don't have formulas behind them,