Quick Tips for Inserting Excel Rows and Columns

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.

Share this content

Replies

Please login or register to join the discussion.

avatar
By Paul Abke
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By David Ringstrom
Ed Henry
Jun 26th 2015 01:11

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

Thanks (0)
avatar
By saeed
Jun 26th 2015 01:12

key board sa kesa ho short ket ma new row

Thanks (0)