How to Select Multiple Columns & Rows in Microsoft Excel


Microsoft Excel is a commonly used spreadsheet application that allows users to input data into a grid divided into rows and columns and made up of a series of cells. The program is infinitely useful in keeping track and managing information and has countless uses. Learning how to select multiple rows and columns in the program can help speed up your productivity in the program, allowing you to edit as many cells, rows, or columns as you want in a cluster, rather than individually.

  • Click the row or column you want to start with. Rows are numbered; columns are lettered.

  • Hold the shift key while clicking click the final row or column you want in the group, which will highlight all the rows or columns in between. If you select a column, hold shift and select a row, it will select all rows between that row and the column bar. If you select a row, hold shirt and select a column, it will select all rows between that column and the row bar.

  • Hold the "Ctrl" key while clicking individual rows or columns to select only those rows/columns without choosing the ones in between.

  • Select all rows and columns in a certain area by clicking the block marking the intersection point of the row bar and column bar.

Related Searches


  • Photo Credit BananaStock/BananaStock/Getty Images
Promoted By Zergnet



You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!