Quick Tips for Inserting Excel Rows and Columns

istock_marekuliasz_tips.jpg

istock_marekuliasz_tips
istock_marekuliasz_tips
3
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.

Please Login or Register to read the full article

To access all of the content on our site, register (it's free!) or login to your existing account.

Replies

Please login or register to join the discussion.

Don't forget about adding a Quick Access Toolbar icon to add rows or columns.

Thanks (0)

I agree, Paul! I discuss that specific technique on pages 2 and 3 of the article. I appreciate your feedback.

Thanks (0)

key board sa kesa ho short ket ma new row

Thanks (0)