In this article, we will learn how to select an entire column in excel and how to select whole row or a table using keyboard shortcut keys. While preparing reports and dashboard in Excel, it’s time-consuming to select an entire column using the mouse. These excel shortcuts are useful to save time and help you do your work faster using the keyboard shortcut keys. How to select row with the Excel shortcut?
Selecting cells is a very common function in Excel. It performs many tasks like addition, deletion and width adjustment of multiple rows and columns while applying the formula on data in Excel. Shortcut keys to select all rows and columns can provide an easier and quicker method of using MS Excel 2016. We have a data set here, let’s understand with the example.
While navigating on an excel sheet with large data, excel column selection is very basic yet important task. Let’s see how easy is selecting columns in excel.
If you wish to select the adjacent columns with the selected column, use Shift + Left/Right arrow key(s) to select entire columns left or right of that column. You can go either way but can’t select both sides of column.
Let’s Select Entire Columns C to E
You can’t select columns A:E if you start from any column in between. I am repeating, you can only select entire columns in Excel from left or right of initial column.
This command is used for selecting rows in excel. This is also a shortcut to highlight a row in excel.
Selecting 3rd to 5th whole rows of the sheet can be done in two ways:
Select multiple rows and columns of a table with shortcut keys and perform your tasks efficiently.
Frequently Asked Question:
How to apply formula to entire column?
Easy, write a formula in the first cell of column and press CTRL + SPACE to select entire column and then CTRL+D to apply formula to entire column.
How to select all in excel?
To select all data press CTRL+A.
How to highlight a row in excel?
Just select any cell in the row you want to highlight and Press Shift+ Space.
How to select multiple cells in Excel mac?
Hold down the command key and scroll over the cells to select. If the cells are not adjacent then click on the cells while holding the command key.
Hope you understood how to select columns and rows with shortcuts in Excel. You can perform these tasks in 2013 and 2010. Explore more links on shortcut keys here. If you have any query, please mention in the comment box below. We will help you.
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.