Quick Tips for Inserting Excel Rows and Columns

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

About David Ringstrom, CPA

David Ringstrom

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. His mantra is “Either you work Excel, or it works you.” David offers spreadsheet and database consulting services nationwide.

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
to 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)
avatar
Nov 14th 2017 11:58

We have used the excel sheets in order to perform various mathematical calculation. There are various in built formulas provided by the software. We can also perform the insert and delete option of rows and columns whenever necessary.bulk wholesale tablets

Thanks (0)
avatar
Dec 9th 2017 18:50

the best tool i found online https://convertir.github.io/outils/csv-inserer-colonne.html
i hope it will be helpful..

Thanks (0)