How to add/delete a row or column in Excel with a command through typing via Keyboard. Lots of People use Excel everyday, but they don't know some simple commands. Even i also don't know . When i join a job as a Computer Operator before 4 years. Every people want to complete his/her work fast. Due to lack of some basic knowledge, and we delay our work. Lots of people add column and row by mouse right click . Now learn the command.
When you want insert/delete a Row:_
Go through arrow key where you want to insert/delete a row then press Shift+ Space all row will be selected then press Alt+ i + r (i for insert/r for row) the selected row will inserted, for delete a row press Alt+d+ r ( d for delete) the selected row will be deleted
When you want to insert/delete a Column
Go through arrow key where you want to insert/delete column then press Alt + Ctrl (Ctrl + Space bar) all column will be selected then Alt+ i + c (For insert column) Alt + d + c (for delete column)
When u learn this command everyone empress with you, and say how you do this. When you go to learn computer basic on computer centers they did not tell you this types of commands. You need this commands when you doing office work with M.S Excel. Hope you enjoy my post. Please comment.
When you want insert/delete a Row:_
Go through arrow key where you want to insert/delete a row then press Shift+ Space all row will be selected then press Alt+ i + r (i for insert/r for row) the selected row will inserted, for delete a row press Alt+d+ r ( d for delete) the selected row will be deleted
When you want to insert/delete a Column
Go through arrow key where you want to insert/delete column then press Alt + Ctrl (Ctrl + Space bar) all column will be selected then Alt+ i + c (For insert column) Alt + d + c (for delete column)
When u learn this command everyone empress with you, and say how you do this. When you go to learn computer basic on computer centers they did not tell you this types of commands. You need this commands when you doing office work with M.S Excel. Hope you enjoy my post. Please comment.
0 comments:
Post a Comment
Thanks