Controlling rows and columns


show more Controlling rows and columns provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts show less
please wait ...

Controlling rows and columns

Every proficient use of Excel knows how to quickly insert columns and rows into worksheets and keep it a one- click process, not two clicks. If we want a new row here above row 5, simply right-click on the 5 and then Insert. Now, keep in mind too this is probably not a great idea as we scroll rightward here in this worksheet. We introduce gaps in the data to the right. Press Ctrl+Z. What should we have done in this case? Selected this data first and then right- click and Insert, but this time we will get a dialog box and of course we went to in this case Shift cells down, and just as easily at a later time, it would be sensitive about this.

If we decided we really didn't need this empty space here, we do not want to get rid of the row, because what happens if we right-click on row 5 here and delete? No questions asked, but the entire row has been deleted and we have lost some data over here, not a great idea. Press Ctrl+Z. So a quick reminder here, the best way to insert rows and colum...

Controlling rows and columns
Video duration: 5m 50s 3h 43m Intermediate

Viewers:

Controlling rows and columns provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts

Subject:
Business
Software:
Excel
Author:
please wait ...