From the course: Excel 2016: Advanced Formatting Techniques

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Work with rows, columns, and sheets

Work with rows, columns, and sheets

From the course: Excel 2016: Advanced Formatting Techniques

Start my 1-month free trial

Work with rows, columns, and sheets

- One of the most common features needed by Excel users is the ability to add new rows, add new columns, and sometimes add cells or take out cells, either from columns or from rows. Many, many times the best way to use these features is with the right mouse button. Now, on the Home tab there certainly are commands here for Insert and Delete, go to Cells, Rows, Columns, even a Sheet. Same idea with Delete. But there are faster techniques than using the ribbon menu system. In this worksheet here called Insert Delete Row Column, those are abbreviated here, second sheet in this workbook, we need to have a new column because we're going to put in the new salaries for the upcoming year. So, right-clicking column F, probably the fastest way to get there. Right-click always means a shortcut menu. Right-click column F and Insert. And because we have selected a column, Insert means new column. We'll put in the heading, eventually put in the new data. And similarly, we might need a new row here.…

Contents