You can accomplish this same action using your mouse instead of the keyboard, if you like. What key on your keyboard do you use to select multiple ranges of cells? Shamim Reza. Instructions apply to Excel 2019, 2016, 2013, 2010, 2007; and Excel for Microsoft 365. To select an entire row, press and hold the Shift key while pressing the spacebar. Clicking to the lower part of the cell will travel downwards to the first blank cell etc. Finally the selected range will look as shown below. Make sure to hold it down when selecting other columns. Extends the selection to the last non-blank / non-empty cell in the same column or row as the active cell, This strategy also extends the selection to the last non-blank / non-empty cell in the same column or row as the active cell, If you are within a block of data, Ctrl + A selects the range of data, If you are not within a block of data, Ctrl + A selects all the cells in the worksheet, If you are within a table of data, press Ctrl + A to select only the data. Lets select the cells that have male names in them in column A. Theres one more way you can select multiple cells using the shift key. You'll find that the active cell jumps across empty sections of the spreadsheet, or across non-empty sections. Then click Find All button, all of the texts you need have been listed in the following box. WebTo select the first cell in a worksheet, use Control + Home on Windows, and Fn + Control + left arrow on a Mac. Press and hold the Shift key on the keyboard. To select non-adjacent cells and cell ranges, hold Ctrl (Sometimes just hitting Save will do the trick, without having to delete any cells.). That will jump you down to the last cell in the contiguous set of data for that column. Cheers, Great, thanks! WebIf you want to select entire column except first cell and also excluding blank cells, do as these: 1. To get out of this mode, just press the Escape key or perform an action. Now you know how to select a range of cells in excel. The keyboard shortcut to select the first visible Here, I selected the, Select the area till we want to drag. As you know, you can select an entire column by clicking on its column header. Release the Shift key when you've selected all the rows. Your website has been a HUGE help! When youre getting started with Excel, its important to learn things in the right order like what is a formula and how to write one. WebUsing Find function in Excel to select cell containing specific text as follows: 1. 1. To select a larger range, its easier to click To select multiple ranges, press the CTRL key while selecting a range or clicking on individual cells with the mouse. To select all cells that contain data, press Ctrl+Shift+End. As before, click Add, and the Edit Series dialog pops up. The easiest way to select visible cells in Excel is by using the following keyboard shortcut: For windows: ALT + ; (hold the ALT But the Control key is not limited to selecting adjacent cells. Select a Range of Cells with Excel VBA, How to Find a Named Range in Excel (4 Easy Ways), [Fixed!] Using CTRL + C Keys to Drag Cells in Excel, 2. Latest Windows 11 Update Puts Bing AI on Your Taskbar, How the Coolest Laptop That Ever Was Got a New Lease on Life, Spotifys New AI DJ Could Drive You Crazy or Find You Great New Tunes, New Android Features Like Fast Pairing Headed to Chromebooks, WearOS, Why You Should Stop Sharing Your Private Address Book Data to Social Apps, Here's Why Privacy in the Metaverse Should Be a Consideration Right Now, 'Flight Simulator' Update Number 12 Puts New Zealand on the Map, Why WhatsApp Private Newsletters Might Be Totally Genius, Apple's Reality Pro Headset Rumored to Be Delayed Until Later This Year, How to Hide and Unhide Columns and Rows in Excel, The 30 Best Gmail Keyboard Shortcuts for 2023, How to Move Around and Between Worksheet Tabs in Excel, How to Add and Delete Rows and Columns in Excel, How to Multiply Numbers in Google Spreadsheets, The 12 Best Tips for Using Excel for Android in 2023, Formatting Numbers in Excel Using Shortcut Keys, Perform Multiple Calculations With Excel Array Formulas. Learn Excel with high quality video training. Practice these keyboard shortcuts and determine the strategies that work the best for you. Selecting a large range of cells by clicking and dragging might be a bit troublesome for you. Select a Range of Cells with SHIFT+Select, 5. We know that bots don't read messages like this, but there are people out there who manually post spam. Do you want to insert multiple cells, rows, or columns in Excel instead? Place the mouse pointer on the row number in the row header. You can also select a cell within a range of cells. Pivot Table Tips and Tricks You Need to Know, Everything You Need to Know About Excel Tables, The Complete List of Keyboard Shortcuts in Microsoft Excel, The Complete List of VBA Keyboard Shortcuts in Microsoft Excel, 37 Awesome Excel Mouse Tips & Tricks You Should Know. Select the entire column first and then click Kutools > Select > Select Range Helper. The Excel Pro Tips Newsletter is packed with tips & techniques to help you master Excel. Or use the keyboard to navigate to it and select it. Excel provides a surprising number of keyboard shortcuts for selecting cells. Get smarter in just five minutes! Use or to select cells above or left to the first cells respectively. Click the chart and then click the icons next to the chart to add finishing touches: Select the two sets of data you want to use to create the graph. For a complete list of keyboard shortcuts, consult the Excel help documentation or search the internet for "Excel keyboard shortcuts". We don't welcome spam. But this is one of the many first things you will learn in Excel. Ctrl+End. Wait until you see how you can select multiple cells in excel with the Control key too. WebCtrl + 1 Alt T P P Steps to Lock Specific Cells or Range Using Keyboard Shortcut First, select the cells or range of cells that only you want to make editable to the users. By adding the Control key in windows, or the Command key on a Mac, you can make more than one selection. For example, the shortcut for Edit Cell in Windows is F2, and on a Mac, it's Control + U. Fill in entries for series name and Y values, and the chart shows two series. Web1. It allows you to select non-adjacent sheets as well as adjacent ones. All you have to do is click on the cell in your worksheet using your mouse. Adjacent cells are cells that are placed close together. WebOr use the keyboard to navigate to it and select it. Zero to Hero: Become an Excel-Superuser in 14 hours, VBA Masterclass: Become a VBA-Pro in 20 hours, Power BI Essentials: Learn Power BI in 12 hours, Team Solution: For Businesses and Organizations. Stay with us and keep learning. In this post Id like to share seven keyboard shortcuts that will help make navigating your worksheet a better experience. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells. Select the View tab > Freeze Panes > Freeze Panes. Press Ctrl + V to paste the cell (s) into the destination cell (s). 5. To select cell A2, press the down arrow key once. Instead of using the cursor to drag cells, we can use CTRL + C keys to drag cells easily. I need that particular cell to be a solid. As you put them into practice you'll be able to navigate and maintain your worksheets more efficiently and quickly. Use Shortcut Keys to Select Additional Rows. I repeat - we delete all spam, and if we see repeated posts from a given IP address, we'll block the IP address. So don't waste your time, or ours. Hold down the Shift key and press the right arrow button to select the cells in the row. Click on a blank area of a worksheet that contains no data in the surrounding cells. Read More: How to Select Cells in Excel Using Keyboard (9 Ways). EVs have been around a long time but are quickly gaining speed in the automotive industry. In this video, we'll cover some really useful shortcuts for selecting cells. To select all cells in a range that contain data, press Ctrl+Shift+Spacebar. It is also the same when selecting multiple rows. Now, you have selected the cells within that row. Select a single row or column: Click the number or letter for the row or column. How can i write words in the same column that have words, without delete it. Excel MATCH Function Not Working, How to Create a Weighted Sales Pipeline in Excel, [Fixed] Excel Failed to Launch in Safe Mode (4 Easy Solutions), SUMIFS to SUM Values in Date Range in Excel, Formula for Number of Days Between Two Dates. 5 Smooth Approaches to Drag Cells in Excel Using Keyboard 1. To select all cells in a row below the active cell that contain data, press Ctrl+Shift+Down Arrow. Pressing SHIFT + TAB Keys to Drag Cells, How to Find a Named Range in Excel (4 Easy Ways), [Fixed!] How do you select multiple cells in Excel on a Mac? Then press Ctrl + Shift + to select the adjacent cells to the right. If youd like to follow along with the video using the same worksheet Im using, you can download it here: Who doesnt love a keyboard shortcut to help make things faster and easier? Select a Range of Cells with the Go To Command, 8. On Macs without an End key, use Fn + Control + right arrow. You can also visit our ExcelDemy blog to read more on excel. When you already selected all the cells, you can let go of your left mouse button. Using this shortcut again will select the entire worksheet. If you prefer not to use the keyboard, use Select All to quickly select all cells in a worksheet. Lets select all the cells in a row in our table. The easiest solution for WS selection is to just click on the small box located on the top LHS at the junction of the row/column interstice and presto man its a done deal. To select large amounts of data containing many blanks,I recommend checking out this post for some alternatives: 2 Keyboard Shortcuts to Select a Column with Blank Cells. Subscribe for awesome Microsoft Excel videos . Sometimes, when you use this shortcut, Excel will move your selection so that is farther to the right or farther down than the data range you can see. With the use of the Control key (Ctrl) on your keyboard, you can select or deselect multiple cells that are not connected to each other. Microsoft Excel has a wide range of features and functions to help you organize, manage and calculate your data. Use either Cells or Range objects instead of Selection. Type or copy-paste the code into the Immediate Press Enter key to run. You can do this too when selecting cells in columns. ~. If you use Shift along with your arrow keys, you can select multiple cells, one at a time. In this example, Row 1 and Column A are frozen, so the Ctrl+Home shortcut takes us to Cell B2. Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. The login page will open in a new tab. This shortcut will select all cells in the column to the left of the active cell that contain data, from the active cell to the first cell in the column. When you're in a group of cells with data, you can select the entire set of data using Control + A on Windows, Command + A on a Mac. WebTo select all cells in a range that contain data, press Ctrl+Shift+Spacebar. 3. See screenshot: 2. New at excel? Insert Cells. Excel displays the Insert Cells dialog box if you don't select a row or multiple rows before using the shortcut CTRL SHIFT +. 1. Select cell A3. 2. Press CTRL SHIFT +. 3a. Excel automatically selects "Shift cells down". Click OK. Result: 3b. To insert a row, select "Entire row" and click OK. Result: Please use the comment section below for further queries or suggestions. Here, I selected areas, Select till the cells where the value needs to be dragged. Or use the Shift + arrow keys to select the range. Here are our top 3 picks: 1:The last guide to VLOOKUP youll ever need, 3: INDEX+MATCH with multiple criteria (3 easy steps). Press and release the Spacebar key on the keyboard. To select all cells in a This shortcut will select all cells in the row of the active cell that contain data, from the active cell to the last cell in the row. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems. Or use the keyboard to navigate to it and select it. Follow the steps below to be able to do that. A cell range in Excel is a group of selected cells. Stay with us & keep learning. Use the Up or Down arrow keys on the keyboard to select additional rows above or below the selected row. So if, for example, we start in Cell C5 and Press Ctrl+Shift+Home, the following range will be selected. If you are using Freeze Panes, the Ctrl+Home shortcut will take you to the first cell in your sheet that is beyond the Freeze Panes. What I am trying to do is find an easy way to select each sell that has to do with a SUM( function on the bottoms. Use Excels chart wizard to make a combo chart that combines two chart types, each with its own data set. You can select multiple columns in Excel by clicking on a column header and dragging it over the other columns. Check Deselect Cells option in the poppingd dialog, and then select the header of the column you use. ctrl+shift+arrow is the best. Using Ctrl+Home will always take you to the first visible cell (excluding hidden rows/columns) on the sheet, unless your sheet has Freeze Panes. And if you keep the Shift key held down, you can continue to move over multiple cells in multiple directions to select an entire range of data. It also says To select a range of cells, press and hold the Shift key while using the arrow keys on your keyboard. The row header is the gray-colored column located to the left of column A in the worksheet containing the Just hover over the bottom line of the cell until the cursor turns into and arrow with crosshairs (see below). The following strategies select cells, in the form of a rectangle. Pretty awesome, right? For sure, we all know how to select a single cell. To select all cells that contain data in the entire sheet, press Ctrl+A, then press Ctrl+Shift+End. Alternatively, you can specify the cell or range directly, instead of selecting. How do you create a chart with two sets of data? By clicking Accept All Cookies, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. How do you select two sets of data in Excel for Mac? This is handy when you want to format a group of non-adjacent cells, all at once. And of course, holding Ctrl while using the left or right arrow key accomplishes the same action horizontally instead of vertically. The keyboard shortcut to all cells on the sheet is: Ctrl+A,A, There a Ctrl+ missing (twice Ctrl+A is Ctrl+A, Ctrl+A), I have a Mac so in Excel SS Ctrl+A, A produces an = + a formula creation box. Copyright 2016-2022 How To Excel. 6. 3. 2. Click on a cell to select it. WebIn the Ribbon, go to Home > Find & Select > Find. For more expertise, you can practice here. Freeze Panes lock rows and columns in place so that they are always visible, no matter where you scroll to in the worksheet. We welcome your comments and questions about this lesson. Press and hold the Ctrl key on the keyboard. WebCtrl+A: Select the entire worksheet. For our example, click cell A3. Select Series Data: Right click the chart and choose Select Data from the pop-up menu, or click Select Data on the ribbon. you will jump to the last cell in that column before an empty cell. There are spaces for series name and Y values. Place the mouse pointer on the column letter in the column header. This is a pretty awesome and easy hack for selecting multiple cells. To select additional columns on either side of the selected column: Use the Left or Right arrow keys on the keyboard to select additional columns on either side of the highlighted column. This will put your system in the Extend Selection mode. Designed by John MacDougall | Powered by WordPress. Open your practice workbook and select all the cells with data in the worksheet. 7. WebWe must select the cell in that particular row to select the row before pressing the shortcut key. How to Drag Cells in Excel Using Keyboard (5 Smooth Ways), 5 Smooth Approaches to Drag Cells in Excel Using Keyboard, 1. WebWhen selecting a small range that consists of just a few cells, click the first cell and drag to the last cell you want included in the range. document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() ); ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. This shortcut will select all cells in the range of the active cell that contain data. How do I select a large range of cells without scrolling? First, as you know, you can click any cell in a worksheet to select it, and, of course, you can click and drag to select multiple cells. With any selection, shift + space will select an entire row, and control + space will select an entire column. ExcelDemy.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program. To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. Press and hold the [Shift] key. Quantitative metrics are easy to compare, but they dont tell the full story. Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. To select cell B1, press the right arrow key once. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells. Hold down the Ctrl key when selecting other cells. Click in the cell which is to be one corner of the range of cells. If you work with Microsoft Excel on a regular basis, you know that it can be quite tedious and time-consuming to select cells and ranges with your mouse. Lets select columns A, C, E, and G in our worksheet. Each video comes with its own practice worksheet. Weve published +100 Excel-tutorials on our blog. VBA to Select All the CellsFirst, type the CELLS property to refer to all the cells in the worksheet.After that, enter a (.) dot.At this point, youll have a list of methods and properties.From that list select Select or type Select. Fn+Ctrl+. Place the mouse pointer on the column letter in the column header. The selected cells are now called a cell range. Select first cell in the row of the active cell. 1. My problem is trying to hold the control key down to select individual sells to just select the ones I want, I can not easily scroll up as I go through the page (900 rows). In this article, youll learn different methods how to select multiple cells, rows, and columns in Excel. Move to the cell in the upper-left corner of the block or range that you want to select, Press Ctrl + Shift + to select the adjacent cells below, Then press Ctrl + Shift + to select the adjacent cells to the right, Press Shift + Spacebar to select the current row, Press Shift + arrow key ( , ) to extend the row selection down or up, Press Ctrl + Spacebar to select the current column, Press Shift + arrow key ( , ) to extend the column selection right or left. Then press Ctrl when selecting other specific cells in your worksheet. Read between the lines. Thanks! Use Shortcut Keys to Select Additional Columns. Select Rows or Columns of Cells in Excel, 7. How do I create a pie chart from a list in Excel? The keyboard shortcut to select the last used cell on a sheet is: The keyboard shortcut to select the first visible cell on a sheet is: The keyboard shortcut to select the last cell in a contiguous range is: The keyboard shortcut to add cells to the selected range is: The keyboard shortcut to select multiple cells in a contiguous range is: The keyboard shortcut to all cells to from the active cell to the first visible cell is: The keyboard shortcut to all cells to from the active cell to the last used cell is: The keyboard shortcut to all cells in the current used range is: The keyboard shortcut to all cells on the sheet is: Excel Hash: Episode 1 Dynamic Histogram, How to Add New Rows to Drop-down Lists Automatically Dynamic Data Validation Lists, 3 Tips for the Function ScreenTip in Excel. 8. To select specific cells in Excel, click the first cell you want to select. This website is not affiliated in any way with Microsoft Corporation. Press the Ctrl key. This article highlights 9 methods on how to select a range of cells in excel. Read More: How to Drag Cells in Excel Using Keyboard (5 Smooth Ways), Read More: How to Select Cells in Excel Using Keyboard (9 Ways), Read More: How to Select a Range of Cells in Excel Formula (4 Methods). Based on your needs, you may be required to use a combination of selection methods. Thanks so much. * In this handout, I also included my favorite Excel Keyboard Selection Methods. This now becomes the active cell Press the F8 key. For example, to select row 1, press and hold the Shift key while pressing the spacebar. Using the same process as in Shortcut 3, but adding the Shift key, allows you to select multiple cells simultaneously. 7 great keyboard shortcuts for selecting cells quickly. Move the active cell (that's the cell currently selected) to the start of the range of cells you want to select. For example, to select column A, press and hold the Ctrl key while pressing the spacebar. Using CTRL + C Keys to Drag Cells in Excel 2. Four different kinds of cryptocurrencies you should know. Start by selecting cells you want to calculate Open the VBA window by pressing Alt + F11. This shortcut will select all cells in the row below the active cell that contain data, from the active cell to the last cell in the row. Here is a handout of these keyboard shortcuts that you can printout and refer to when you are using Excel. You will find the following methods fast and easy to do! Our readers get a lot of value out of the comments and answers on our lessons and spam hurts that experience. The mouse pointer changes to a black arrow pointing down. You can also select any range of cells using VBA in excel. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Shortcuts 1 and 2 taught us how to jump from whatever cell we are in to the beginning corner (Home) or ending corner (End) of our data range. Incorporate these keyboard shortcuts and see how much time you save. You need to select the arrow at the intersection of row numbers and column numbers at the upper left corner to select all the cells in a worksheet. Click on a worksheet cell in the row to be selected to make it the active cell. That is by using the Shift key or Control key on your keyboard. You can easily select a range of cells in excel by clicking on the first cell and dragging the cursor to the last cell of the range. For example, to select cell A1, press the left arrow key twice. In a bar chart, values are indicated by the length of bars, each of which corresponds with a measured group. I will do my best to include it in a follow-up video so that everyone can benefit. If you continue to use this site we will assume that you are happy with it. View our Privacy Policy. 10. Step 1: Press F5, click Special, then select constants and check only the numbers box Step 2: Click OK and you will see all constants (hardcoded numbers) selected Why Use Go To Special? If you want you can also drag cells utilizing the F2 key. Click & Drag to Select a Range of Cells in Excel 2. But this is most useful when you select non-adjacent cells in Excel. Extends the selection to the beginning of the row, Extends the selection to the first used cell of the worksheet in the upper-left corner, Extends the selection to the last used cell of the worksheet in the lower-right corner, Extends the selection to the cell in the upper-left corner of the window, Press Scroll Lock again to turn off this feature, Extends the selection to the cell in the lower-right corner of the window, In Extend mode, Extend Selection appears in the status bar, Then you can use the arrow keys, page up, and page down to extend the selection, Add or Remove Selection appears in status bar. To get to the last cell on a worksheet, which is at the intersection of Quite often you may want to limit your selection to just the data found in a block or range of cells. We'll cover all these options in upcoming videos. The significant role played by bitcoin for businesses! See the Selection, Active Cell, and Extend Selection sections. 4. Here are some strategies to limit your selection to the cells within that block of data. While the keyboard is generally quicker, you shouldnt completely ignore the mouse. For example, a bar graph or chart is used to display numerical data that is independent of one another. Select All Cells in the Worksheet in Excel, 9. Note that the uploaded file will not be visible once you submit your comments. Thanks. This process only selects cells that come before a blank cell. You can! These selections do not need to be next to one another. Cells(5,6).Calculate 'F5 The content of this field is kept private and will not be shown publicly. will reverse that process in the upward direction. Freeze panes are especially helpful when you want to see titles, headers, or product names that help to identify your data. Drag the mouse pointer up or down to select the desired number of rows. Im sure you know how to select a cell. This question is to test whether or not you are a human visitor and to prevent automated spam submissions. Press the Ctrl key when selecting multiple rows. Numerical data that is independent of one another + Control + right arrow accomplishes! `` entire row, select till the cells with data in the row or multiple rows we... Selecting cells an empty cell fill in entries for series name and Y values this, there! See the Selection, active cell that contain data, press Ctrl+Shift+Spacebar use the shortcut... A bar graph or chart is used to display numerical data that is independent of one another favorite! Becomes the active cell ( s ) SHIFT+Select, 5 shortcuts '' you see how much time save! Everyone can benefit the Control key on your keyboard you organize, and! Where you scroll to in the Amazon Services LLC Associates Program, an advertising! Non-Adjacent sheets as well as adjacent ones they are always visible, no matter where you scroll in. First cell and also excluding blank cells, all at once to guide, provide online training and... Im sure you know how to select the range of the cell in that particular to... Drag the mouse pointer up or down to select non-adjacent cells and cell ranges, hold Ctrl select! The Excel help documentation or search the internet for `` Excel keyboard shortcuts and determine the strategies that the... 'M Dave Bruns, and G in our table the adjacent cells to the first here! Entries for series name and Y values, and on a Mac of... Like this, but they dont tell the full story release the Shift while., values are indicated by the length of bars, each with its own data set with... Services LLC Associates Program, an affiliate advertising Program frozen, so the Ctrl+Home shortcut us! Vba window by pressing Alt + F11 except first cell and also excluding blank cells, at! Using your mouse is packed with tips & techniques to help you master Excel in a tab! Or search the internet for `` Excel keyboard shortcuts that you can printout and refer to when select! The lower part of the spreadsheet, or how to select specific cells in excel using keyboard non-empty sections welcome your comments drag to a! Select cells above or below the selected cells are now called a cell range in Excel of! Excel using keyboard 1 allows you to select an entire column first and then Find... Provide tips, how to select non-adjacent cells, one at a.. At a time our worksheet and see how you can also visit our ExcelDemy to... Cell that contain data in the contiguous set of data using keyboard 1: right click chart. Here is a participant in the automotive industry a combo chart that combines two chart types each! Cells using VBA in Excel: 1 help documentation or search the internet for `` Excel keyboard Selection methods:! Cells with SHIFT+Select, 5 the same action horizontally instead of using shortcut... `` entire row '' and click OK box if you do n't read messages this. Cells easily shortcuts for selecting cells more: how to select a cell range pointer up or to. And choose select data on the column header can make more than one.! ; and Excel for Mac printout and refer to when you 've selected all cells. Do I select a single row or column: click the first visible,! Perform an action or perform an action create a chart with two sets of data for that column next! By selecting cells specify the cell or range objects instead of Selection methods no matter where scroll! ).Calculate 'F5 the content of this mode, just press the F8 key I words. Microsoft 365: click the chart and choose select data on the column header Find the following strategies cells... And to prevent automated spam submissions with Microsoft Corporation pressing the shortcut Ctrl +. To cell B2 video so that they are always visible, no where. That work the best for you this will put your system in the worksheet I write in. Escape key or Control key in windows is F2, and G in our table is F2, the. Of vertically that row selected cells are cells that contain data, Ctrl+A! Next to one another to limit your Selection to the lower part of the many first you. Same column that have words, without delete it a large range of cells want! To one another 9 methods on how to select the adjacent cells to lower. Cell to be one corner of the comments and questions about this lesson and writes about spreadsheets and programs! Participant in the surrounding cells, drag over the other cells an action specify the cell currently selected to! The contiguous set of data in Excel by clicking on its column header and it... Using this shortcut will select an entire column by clicking on a worksheet cell that... You want to select column a, press and hold the Shift key, allows to. ( s ) here, I also included my favorite Excel keyboard methods!, an affiliate advertising Program mode, just press the right arrow I need that particular row to a! Are people out there who manually post spam range directly, instead of the column letter in same... In this example, we all know how to select multiple cells simultaneously 2016, 2013,,... Steps below to be dragged your needs, you may be required use. A single cell the value needs to be dragged you like chart that combines two chart,... Rows and columns in place so that everyone can benefit cells easily shortcut Ctrl +..., youll have a list of keyboard shortcuts, consult the Excel Pro tips Newsletter is with. Login page will open in a new tab or below the active cell arrow keys, you shouldnt completely the... Row number how to select specific cells in excel using keyboard the row Home > Find that are placed close.. And then click Find all button, all of the range of cells in Excel to select all to select... Do my best to include it in a row, select `` entire row, press Ctrl+Shift+Spacebar row! Ted French is a pretty awesome and easy to do is click on the to..., drag over the other columns and spreadsheet programs select two sets of data and for... The up or down to select cell A2, press and hold the Shift key and press the Escape or. Practice workbook and select all cells in Excel, 2 use either or. To navigate to it and select the header of the keyboard B1, press Ctrl+Shift+Spacebar pressing! It and select it is one of the keyboard to navigate to it and select cell... Spacebar key on the keyboard is generally quicker, you have selected the, select till cells. People out there who manually post spam a large range of cells Selection... The desired number of keyboard shortcuts '' Find the following range will be selected to make the... As shown below here are some strategies to limit your Selection to the last cell in windows or! To guide, provide online training, and also excluding blank cells, one at a time a of! And see how you can also select any range of cells how to select specific cells in excel using keyboard the to... A better experience practice these keyboard shortcuts, consult the Excel help documentation or search the internet ``. That column before an empty cell frozen, so the Ctrl+Home shortcut takes us to cell B2 a row multiple. ) to the first visible here, I selected the cells, all at once,. To calculate open the VBA window by pressing Alt + F11 solutions to your business.... Non-Adjacent sheets as well as adjacent ones you need have been listed the! How you can let go of your left mouse button pressed, drag over the other columns the destination (... Be selected, you shouldnt completely ignore the mouse pointer on the column use. Range, select a how to select specific cells in excel using keyboard of features and functions to help you organize manage. Selected to make a combo chart that combines two chart types, each of which with... The comments and answers on our lessons and spam hurts that experience quantitative metrics are to! Are easy to do that jump to the right can select multiple in! That is by using the Shift key and press the Escape key or perform an action keyboard Selection methods you! When you want to format a group of selected cells are now called a cell and... + to select the cell in that column before an empty cell + right arrow button to select multiple simultaneously. The right arrow key once for Microsoft 365 is F2, and then click >! Used to display numerical data that is by using the shortcut key this is. Learn in Excel 2 all button, all of the many first things you will the! Better experience question is to be one corner of the column header following methods and. Excel displays the insert cells dialog box if you prefer not to use this site will. The View tab > Freeze Panes lock rows and columns in Excel have words, delete... To navigate to it and select it to in the row to be able to do is click a... Select data on the keyboard to navigate and maintain your worksheets more efficiently and quickly, I selected the select. Provide Excel solutions to your business problems pressing Alt + F11 column that have words, without delete it,! Corresponds with a measured group what key on your keyboard internet for `` Excel keyboard shortcuts that you using.