Mar 22nd 2013
Spreadsheet users frequently insert rows and columns into spreadsheets, but for most users, it's a multiple-step process. Even savvy users who rely on keyboard shortcuts have to use two different shortcuts in sequence. In this article, I'll explain how you can create your own custom shortcut to insert rows or columns with a single keyboard shortcut or mouse click. There are several ways to add rows or columns to a spreadsheet:
- Excel 2007 and later: As shown in Figure 1, on the Home tab, choose Insert and then Insert Sheet Rows or Insert Sheet Columns.