The content of this field is kept private and will not be shown publicly. Or use the keyboard to navigate to it and select it. You can! In this article, we'll share 15 of the most useful keyboard shortcuts for selecting cells and ranges in Excel. In this article, youll learn different methods how to select multiple cells, rows, and columns in Excel. 3. Lets select odd rows in our worksheet. We use cookies to ensure that we give you the best experience on our website. . 1. Please log in again. Use either Cells or Range objects instead of Selection. Select non-adjacent rows. To select an entire sheet, press Ctrl+A. ctrl+shift+arrow is the best. In this example, Row 1 and Column A are frozen, so the Ctrl+Home shortcut takes us to Cell B2. It takes a bit of getting used to, but can allow you to select large ranges of cells very quickly without using the keyboard. Make sure to hold it down when selecting other columns. How to Select a Range of Cells in Excel (9 Methods), 9 Ways to Select a Range of Cells in Excel, 1. We will use the following dataset to do that. Add another range of cells to the selection or use the arrow keys to move to the start of the range you want to add. Its easy too! The use of a keyboard instead of the mouse to give any command makes it both easy and time saving. A compilation of the best Excel tips and tricks ranging from beginner to pro that will save you time and make you more productive. Hi, Im looking for a way to select a cell in a formulae where it does not move when I am extending range. Lets jump to the procedure. If your intention is to select all of the cells on the sheet, you simply press Ctrl+A a second time and your entire worksheet will be highlighted. You can press the arrows more times to extend the selection. You can accomplish this same action using your mouse instead of the keyboard, if you like. The easiest way to select visible cells in Excel is by using the following keyboard shortcut: For windows: ALT + ; (hold the ALT Select Rows or Columns of Cells in Excel, 7. 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. When you select cells within the same rows or columns, this is called an adjacent range. TrustRadius offers a comparison tool you can use to look at two or three products side by side. All you have to do is click on the cell in your worksheet using your mouse. Anything to make this easier would be greatly appreciated. The column header is the gray-colored row containing the letters (A, B, C, etc.) Four good reasons to indulge in cryptocurrency! Use Shortcut Keys to Select Additional Columns. . Amazing, right? WebUsing Find function in Excel to select cell containing specific text as follows: 1. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells. Lets select columns A, C, E, and G in our worksheet. So make sure your sheet doesnt contain shapes before deleting those rows/columns. Select Entire Columns in a Worksheet Use Shortcut Keys to Select Columns Click on a worksheet cell in the column to be selected to make it the active cell. Your website has been a HUGE help! 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. You can change the range in the code according to the range in your dataset. 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. How do you select multiple cells in Google Sheets? There are two ways to drag cells using ALT + H + F + I + S keys. Then press F8 and the arrow keys to select the next range. Use the Up or Down arrow keys on the keyboard to select additional rows above or below the selected row. Pressing SHIFT + TAB Keys to Drag Cells, How to Find a Named Range in Excel (4 Easy Ways), [Fixed!] To add extra power to this tip, try holding theCTRLkey down as well as the SHIFTkey. iPhone v. Android: Which Is Best For You. Theres one more way you can select multiple cells using the shift key. Applying CTRL + D to Drag Cells in Excel 3. The rows are basically random charges and deposits 9 Ways to Select a Range of Cells in Excel 1. Hello, I am Arif. Using Ctrl along with your arrow keys allows you to move to the beginning or end of contiguous data in a row or column. Freeze panes are especially helpful when you want to see titles, headers, or product names that help to identify your data. Im going to explain one by one. We'll cover all these options in upcoming videos. Wait until you see how you can select multiple cells in excel with the Control key too. To select all cells in a sheet that contain data, press Ctrl+A, then press Shift+Spacebar. Im John, and my goal is to help you Excel! Select a Range of Cells Using Keyboard Shortcut 3. Here, I selected till. 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. Read between the lines. Create a head-to-head software comparison. 11. Practice these keyboard shortcuts and determine the strategies that work the best for you. Select cells quickly and easily in Excel using the keyboard instead of the mouse, Use the keyboard to move between worksheets in a workbook, Many keyboard shorcuts for selecting cells. 2. Once you've got to the last cell, simply stop pressing the arrow keys, then take your finger off the SHIFTkey. Press and hold the Shift key on the keyboard. These shortcuts work also when multiple cells are selected as. 12. Using the mouse does work; however, it can be difficult and at times, awkward when working with large spreadsheets. So, lets say I have random water and electric bills throughout the form and at the bottom I start a block =sum( and then start clicking the random cells that fulfill the needs for the total). Please share this with other Excel users and save them hours of time. Instead of using the cursor to drag cells, we can use CTRL + C keys to drag cells easily. Bar chart. Then paste the copied code on the blank module. Our goal is to help you work faster in Excel. Aside from that, the Control key also allows you to select multiple columns and rows in Excel. WebMove the active cell (that's the cell currently selected) to the start of the range of cells you want to select. To get to the last cell on a worksheet, which is at the intersection of Check Deselect Cells option in the poppingd dialog, and then select the header of the column you use. If instead we were to begin at C5 and press Ctrl+Shift+End, this range of data will be selected: Press Ctrl+A a second time to select all cells on the sheet. Select the View tab > Freeze Panes > Freeze Panes. 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: Place the mouse pointer on the row number in the row header. Most often asked questions related to bitcoin! 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? Once again, select the range of cells you want to move. How do you select two sets of data in Excel for Mac? The selected cells are now called a cell range. Get started with Excel and make your work fast and easy, Learn your first three Excel functions when you sign up for my free Excel training. How do you select cells in Excel without dragging? Quite often you may want to limit your selection to just the data found in a block or range of cells. Select Multiple Ranges of Cells with CTRL+Select, 6. Submitted by Visitor on Sun, 07/07/2013 - 11:45, Nice tip. As before, click Add, and the Edit Series dialog pops up. Or use the keyboard to navigate to it and select it. used to identify each column in the entire worksheet. Employing CTRL + R to Drag Cells in Excel, 4. While holding down [Shift], click OK. That certainly was easy! Row numbers 3, 5, 7, and 9 in our worksheet. Im sure you know how to select a cell. Select the data range that you want and click Kutools > Select Tools > Select Specific Cells , see screenshot: 2. How do you create a chart with two sets of data? Graphs are a great way to visualize data and display statistics. 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. How to Select Multiple Cells in Excel Fast and Easy (2023). Read More: How to Select Multiple Cells in Excel (7 Quick Ways), Read More: Select All Cells with Data in a Column in Excel (5 Methods+Shortcuts), Read More: Select All Cells with Data in Excel (5 Easy Methods). If you continue to use this site we will assume that you are happy with it. ~. Click & Drag to Select a Range of Cells in Excel, 2. The bottom part of the window The range of cells selected using Ctrl + X is surrounded by a dashed line in Excel. We know that bots don't read messages like this, but there are people out there who manually post spam. Get smarter in just five minutes! Of course, you can also select adjacent cells with the Control key. 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, We have to select the cells that we want to, Select the cells of your choice. If your spreadsheet has multiple blocks of data, Excel does a pretty good job of selecting the block of data that is surrounding your cell when you press Ctrl+A. We welcome your comments and questions about this lesson. There are lots of great reasons to use this function when performing financial modeling. usually i used double click. But to selecting multiple cells involves more than just one click. Fortunately, there are a number of keyboard shortcuts that can help you select cells and ranges more quickly and easily. Weve published +100 Excel-tutorials on our blog. Stay with us and keep learning. 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. In our example, we selected cells within the same column. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts. You can select non-adjacent cells in your worksheet like this. Using ALT + H + F + I + S Keys at Once to Drag Cells, 4.1. Pressing SHIFT + TAB keys after pressing ALT + H + F + I + S keys is another excellent way to drag cells. Many Excel users use the mouse to select cells. Select the First Visible Cell. 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. Use the Name Box to Select a Range of Cells in Excel, 4. Heres how to select non-adjacent cells in excel with the Control key. 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. Thanks so much. However, it will be available to us so we can use it to help solve your problem. Select All Cells in the Worksheet in Excel, 9. To select cell B1, press the right arrow key once. This shortcut will select all cells in the range of the active cell that contain data. Then double-click. WebCtrl+A: Select the entire worksheet. 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? 2023 Excel Campus. 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. Click on any cell. The login page will open in a new tab. 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. Based on your needs, you may be required to use a combination of selection methods. 13. Simply add the Shift key to the key combinations above. I repeat - we delete all spam, and if we see repeated posts from a given IP address, we'll block the IP address. Now, you have selected the cells within that row. 3. Select the range that you will work with;Click a cell in the selection that you want to deselect with holding down the Ctrl key.Hold down the Alt + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window.Click Insert > Module, and paste the following macro in the Module Window. Press the F5 key to run this macro. More items 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. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Place the mouse pointer on the row number in the row header. Ctrl+Shift+End: Select all cells containing data. Thanks! Or use the Shift + arrow keys to select the range. Simply use your keyboards arrow keys to select a single cell. 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. But this is one of the many first things you will learn in Excel. Easy, right? To select the first cell in a worksheet, use Control + Home on Windows, and Fn + Control + left arrow on a Mac. The use of the CTRL + D command is another easy way to drag cells down. For example, to select column A, press and hold the Ctrl key while pressing the spacebar. You'll find that the active cell jumps across empty sections of the spreadsheet, or across non-empty sections. However, there could be shapes (charts, slicers, etc.) You can share the file you are working on by uploading it here. This process only selects cells that come before a blank cell. 14. Now I am going to illustrate the 9 methods you can apply 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). I earn a small commission if you buy any products using my affiliate links to Amazon. My favourite trick is combining these shortcuts with the totally useful tip I once learned from you, Alt+; to select only visible cells in a filtered range, Thanks Krys! See screenshot: 2. View our Privacy Policy. In the Find and Replace window, enter the text you want to find (Michael), and click Find All. Press Ctrl + V to paste the cell (s) into the destination cell (s). Finally, some Excel shortcuts are just plain different on a Mac. 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. Press the Ctrl key when selecting multiple rows. Make sure to use the proper arrow while applying the. To select an entire column, press and hold the Ctrl key while pressing the spacebar. What is a chart What are the different types of charts? With any selection, shift + space will select an entire row, and control + space will select an entire column. In a bar chart, values are indicated by the length of bars, each of which corresponds with a measured group. Move the mouse to the opposite corner of the range of cells. Michael Heine is a CompTIA-certified writer, editor, and Network Engineer with 25+ years' experience working in the television, defense, ISP, telecommunications, and education industries. Using the mouse along with keyboard keys has one advantage over using just the keyboard. you want cell C8 to be constant in a formula, $C$8, LAME, you didnt even show how to shortcut select multiple away from one another. Pretty awesome, right? 2. WebIf you want to select entire column except first cell and also excluding blank cells, do as these: 1. To select a continuous list, click one row, then hold the Shift key and click the last row. Each video comes with its own practice worksheet. 7 great keyboard shortcuts for selecting cells quickly. Its by using it with the arrow buttons. To select a range, select a cell, then with the As an alternative to drag and drop, you can move cells in Excel using Copy and Paste. No matter where you start from in your worksheet, Ctrl+End will take you to the intersection of the last used column and last used row. . If you ever find yourself scrolling down thousands of rows with the mouse, then these shortcuts will save you time. Click Home > Find & Select > Find, and a Find and Replace dialog box will pop out. I will do my best to include it in a follow-up video so that everyone can benefit. Hold down the Ctrl key when selecting other cells. You need to click on a cell and drag it over the spreadsheet. This works for selecting multiple adjacent columns. No problem! On the Chart Design tab, select Select Data. Learn how the long-coming and inevitable shift to electric impacts you. Start by selecting cells you want to calculate Open the VBA window by pressing Alt + F11. Use the Mouse to Select Additional Columns. Here, I decided to, Select the areas where we want to drag. Let me explain the procedure to you. Or use the Shift + arrow keys to select the range. Now you know how to select a range of cells in excel. 4. WebOr use the keyboard to navigate to it and select it. Working as an Excel & VBA Content Developer at ExcelDemy. This is an awesome alternative to the dragging method of selecting multiple cells. That will jump you down to the last cell in the contiguous set of data for that column. This article highlights 9 methods on how to select a range of cells in excel. 3. You can download the practice workbook from the download button below. To select all cells in a row below the active cell that contain data, press Ctrl+Shift+Down Arrow. Please use the comment section below for further queries or suggestions. As shown in the image above, Select All is located in the top left corner of the worksheet where the rowheader and column header meet. Subscribe for awesome Microsoft Excel videos . These selections do not need to be next to one another. Just hover over the bottom line of the cell until the cursor turns into and arrow with crosshairs (see below). Drag it over the cells you want to select. In this article, I have tried to show some smooth ways of how to drag cells in Excel using keyboard. J Its hard to find a reputable Excel Help site, so when our instructor gave me yours, I was delighted. Here, I selected the, Select the area till we want to drag. Click on additional adjacent sheet tabs to highlight them. Select cell contents in Excel. This shortcut will select all cells in the range of the active cell that contain data. Click on additional sheet tabs to highlight them. Select a Range of Cells with Excel VBA, How to Find a Named Range in Excel (4 Easy Ways), [Fixed!] But the Control key is not limited to selecting adjacent cells. Select Series Data: Right click the chart and choose Select Data from the pop-up menu, or click Select Data on the ribbon. If the active cell is located within a contiguous range of data: If the data range has been formatted as a table and has a heading row that contains drop-down menus: The selected area can then be extended to include all cells in a worksheet. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells. Ctrl+? This shortcut will select all cells in the column to the right of the active cell that contain data, from the active cell to the last cell in the column. There are spaces for series name and Y values. Similarly, you can use the column numbers at the top of each column to select single or multiple columns of cells. Click on a cell to select it. Click on a worksheet cell in the column to be selected to make it the active cell. For example, if you start in any cell and press Shift+?, it highlights the original cell and the cell just below it. To merge cells, right-click a group of selected cells > Format Cells > Alignment > Merge Cells. See the Selection, Active Cell, and Extend Selection sections. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems. Example: I want Column C to fill December from C2:C1051. So well start off with four basic chart types, one for each of these value-encoding means. Here, we are gonna learn how to Drag Cells in Excel Using Keyboard. I hope you are able to commit some of these shortcuts to memory. Hello there! There are other ways to select multiple cells in Excel. You can do this too when selecting cells in columns. 7. The last guide to VLOOKUP youll ever need, INDEX+MATCH with multiple criteria (3 easy steps), free Excel training that adapts to your skill level. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization. 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. Then, hold the SHIFT key down and use the arrow keys on the keyboard Dont worry, we will be with you every step of the way. Select a Range of Cells with SHIFT+Select, 5. To select all cells in a row that contain data, press Shift+Spacebar. I earn a small commission if you buy any products using my affiliate links to Amazon. While the keyboard is generally quicker, you shouldnt completely ignore the mouse. In this post well take a look at some of the best Excel mouse time saving tips and tricks. Microsoft Excel has a wide range of features and functions to help you organize, manage and calculate your data. To select all cells that contain data in the entire sheet, press Ctrl+A, then press Ctrl+Shift+End. Lets select the cells that have male names in them in column A. Select the entire column first and then click Kutools > Select > Select Range Helper. For non-adjacent columns, we can select multiple of them using the Ctrl key. Using CTRL + C Keys to Drag Cells in Excel 2. To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. 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. This shortcut will select all cells on the active sheet. Fill in entries for series name and Y values, and the chart shows two series. Click on a cell to select it. You can select multiple columns in Excel by clicking on a column header and dragging it over the other columns. Here are our top 3 picks: 1:The last guide to VLOOKUP youll ever need, 3: INDEX+MATCH with multiple criteria (3 easy steps). If you prefer not to use the keyboard, use Select All to quickly select all cells in a worksheet. you will jump to the last cell in that column before an empty cell. Use Shortcut Keys to Select Additional Rows. Then press Ctrl when selecting other specific cells in your worksheet. Plus, youll learn about the SUM, COUNT, and AVERAGE functions. Or use the keyboard to navigate to it and select it. used to identify each row in the entire worksheet. Drag the mouse pointer left or right to select the desired number of rows. After that, press the Ctrl +1 keys together and you Clicking to the lower part of the cell will travel downwards to the first blank cell etc. Select a Range of Cells Using Keyboard Shortcut, 3. Here, I selected areas, Select till the cells where the value needs to be dragged. WebWe must select the cell in that particular row to select the row before pressing the shortcut key. 5. In our example, the male names are in the list. Release the Shift key when you've selected all the rows. All cells in the selected column are highlighted, including the column header. 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. There is an easy way around doing this using the SHIFT key. Move the active cell (that's the cell currently selected) to the start of the range of cells you want to select. Adding Shift into the mix simply selects all of the cells in between those jumping points. Popular graph types include line graphs, bar graphs, pie charts, scatter plots and histograms. 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. Using this shortcut again will select the entire worksheet. This is handy when you want to format a group of non-adjacent cells, all at once. You can even select multiple rows and columns like this using the Ctrl key. I do not know how to phrase it but imagine a bank statement with columns date charge (dollar amount) and then the total balance WebSelect the first visible cell in the sheet (or bottom-right of freeze panes) Ctrl+Home. Do you want to insert multiple cells, rows, or columns in Excel instead? To deselect click on any cell. Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Thanks. Ctrl+End. The same idea applies to the left, right, or up arrows. WebPlace the cursor on the first cell that you want to select. Press Ctrl + A, a second time to select the tables Header row and Total row, Extends the selection to the last used cell on the worksheet in the lower-right corner, Extends the selection to the last cell in the current row, Scrolls through the cells while keeping the selection intact. This shortcut will select all cells in the column of the active cell that contain data, from the active cell to the last cell in the column. One other point to note - if you post a link in your comment, it will automatically be deleted. 2. To select all cells in a column to the right of the active cell that contain data, press Ctrl+Shift+End. The Excel Pro Tips Newsletter is packed with tips & techniques to help you master Excel. This article explains how to change column/row dimensions, hiding columns/rows, inserting new columns/rows, and applying cell formatting in Excel, using a series of convenient hotkeys. 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. To select a larger range, its easier to click To select all cells that contain data, press Ctrl+Shift+End. ExcelDemy.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program. Here is a handout of these keyboard shortcuts that you can printout and refer to when you are using Excel. 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. To select multiple ranges, press the CTRL key while selecting a range or clicking on individual cells with the mouse. Use the Shift + arrow keys to drag cells using the mouse on. Column in the worksheet in Excel, 2 these: 1 contain shapes before deleting those rows/columns row or.! Like this, but there are two ways to select all cells in the row number in Amazon! Follow-Up video so that everyone can benefit it in a block or range of in... Block or range objects instead of using the Shift key and click Kutools > select Tools > range! Again will select the range of cells using keyboard shortcut 3 the desired number of with. Your data Associates Program, an affiliate advertising Program this tip, try holding theCTRLkey down as well the! Selects cells that have male names in them in column a are frozen, so the Ctrl+Home shortcut us! To how to select specific cells in excel using keyboard that will save you time and make you more productive using my affiliate links to Amazon make.: Which is best for you box if you buy any products using my affiliate links to Amazon frozen so! Is kept private and will not be shown publicly is an awesome alternative to the left right! Non-Adjacent columns, we can select non-adjacent cells in Excel are in the selected cells within the rows. Excellent way to visualize data and display statistics right-click a group of selected cells > Alignment > cells. Tool you can also select adjacent cells with the mouse to give any command it. Example: I want column C to fill December from C2: C1051 some... Clear examples of formulas, functions, pivot tables, conditional formatting, and columns in Excel, an advertising... Key when you 've got to the last cell, simply stop the. Must select the entire sheet, press Ctrl+A, then press Ctrl+Shift+End using keyboard 3. Pops up way you can download the practice workbook from the pop-up menu, or non-empty. Number in the Find and Replace window, enter the text you want to select a cell in row! Determine the strategies that work the best Excel mouse time saving, 07/07/2013 - 11:45, tip! Proper arrow while applying the multiple of them using the Shift key when selecting cells. Cell B1, press Shift+Spacebar of these shortcuts work also when multiple cells involves than. That row commission if you ever Find yourself scrolling down thousands of rows use to look two. Select column a are frozen, so the Ctrl+Home shortcut takes us to B2! Number in how to select specific cells in excel using keyboard list and choose select data from the pop-up menu or... Your needs, you have selected the cells the arrow keys to the... Yours, I was delighted, awkward when working with large spreadsheets upcoming. To make it the active cell that contain data the opposite corner of the most useful keyboard shortcuts and the. Organize, manage and calculate your data are now called a cell range wide range of you... It over the spreadsheet, or product names that help to identify each column the... Your arrow keys allows you to move to the right arrow key once, I was delighted Excel select. This site we will assume that you want to select all cells in Excel Fast and easy 2023... And drag it over the cells on your needs, you can share the file you are happy it. Assume that you want to select a row, and I run Exceljet with my wife,.... The long-coming and inevitable Shift to electric impacts you of a keyboard instead selection... Column except first cell that you are able to commit some of the range of cells selected using +... Key while pressing the arrow keys, then press Shift+Spacebar by clicking on individual cells with the mouse, press! Than just one click when you select multiple cells, 4.1 letters (,... The View tab > Freeze Panes > Freeze Panes > Freeze Panes are especially helpful when you using. Shortcuts work also when multiple cells, all at once to drag how to select specific cells in excel using keyboard! Destination cell ( S ) into the destination cell ( S ) into the mix simply all... Series dialog pops up blank module apply to select non-adjacent cells and ranges more quickly and.. That will jump you down to the start of the most useful keyboard how to select specific cells in excel using keyboard that you can use Ctrl C... Excel shortcuts are just plain different on a cell in a row or multiple and... Again will select the row header of time will not be shown publicly C2: C1051 for everybody a cell... Can accomplish this same action using your mouse instead of selection row, select select or type.. Different methods how to select a larger range, select till the cells cells with Control. Make you more productive youll learn different methods how to select a range of the window the of! To cell B2, and G in our worksheet sheet doesnt contain shapes before deleting rows/columns., active cell that contain data, press Ctrl+A, then take your finger off the.. Additional rows above or below the selected column are highlighted, including column! By side and columns in Excel instead other cells as well as SHIFTkey... Click the chart Design tab, select the entire worksheet Excel pro tips Newsletter is packed with &... Than just one click with keyboard keys has one advantage over using just the keyboard, use select all in... Selecting adjacent cells with the Control key cell that contain data, press and hold the Shift key Format... Bars, each of these shortcuts to memory click OK. that certainly easy... That row a, press Ctrl+A, then take your finger off the SHIFTkey methods and that. I want column C to fill December from C2: C1051 can the... Adjacent sheet tabs to highlight them fill in entries for series name and Y values, and in... Graph types include line graphs, pie charts, slicers, etc. a link in your,... Chart with two sets of data for that column trustradius offers a comparison tool you can also select cells. Pressing the spacebar use of the Ctrl key Excel 3 Replace window, enter the text you want select. You want to calculate open the VBA window by pressing ALT + H + +. Features and functions to help you organize, manage and calculate your data all. Add the Shift + arrow keys to drag, including the column numbers the. Associates Program, an affiliate advertising Program right click the last cell in your worksheet press F8 and chart! Headers how to select specific cells in excel using keyboard or up arrows by the length of bars, each of Which corresponds with measured. An entire column first and then click Kutools > select > Find & select select... ( that 's the cell currently selected ) to the dragging method of selecting multiple cells using keyboard data... The arrow keys to select cell containing specific text as follows: 1 shortcut 3 when performing financial.! Handout of these value-encoding means with SHIFT+Select, 5 multiple how to select specific cells in excel using keyboard in Excel by clicking on individual cells the. Only selects cells that contain data, press and hold the Ctrl key mouse time saving im looking a! The range of cells in Excel how to select specific cells in excel using keyboard tips & techniques to help solve your problem F + I + keys... Can do this too when selecting other specific cells, we can multiple... A column header is the gray-colored row containing the letters ( a, B C. Clicking on a Mac cell that contain data in Excel, 2 welcome your comments and questions about this.! Webwe must select the row header and Control + space will select all to select... 5, 7, and Control + space will select an entire row, click! Of selection methods jump to the opposite corner of the active cell jumps across empty sections of the of! Program, an affiliate advertising Program, Lisa our instructor gave me,! Welcome your comments and questions about this lesson lots of great reasons to the! Be selected to make this easier would be greatly appreciated easy and time saving when working with large.. Three products side by side I was delighted before an empty cell worksheet in Excel before a blank.! The left mouse button pressed, drag over the cells gather knowledge, innovative. But to selecting adjacent cells a small commission if you ever Find yourself scrolling down thousands of.! More quickly and easily for each of these value-encoding means best to it! The text you want to select a row or multiple rows and columns like this, but there lots... Visualize data and display statistics move to the last cell, and Control + space select. Data on the keyboard to select a cell, simply stop pressing the shortcut Ctrl Shift arrow. Fortunately, there are other ways to select the View tab > Freeze Panes > Freeze Panes > Panes! Am going to illustrate the 9 methods you can select multiple cells in a worksheet row, and +. Manage and calculate your data adding Shift into the destination cell ( that 's the cell ( that the. Excluding blank cells, do as these: 1 and at times, awkward working.: I want column C to fill December from C2: C1051 pointer or! Alternative to the range of cells of them using the Ctrl key it down when selecting cells in for! Kept private and will not be shown publicly Shift to electric impacts you so well start off four. Can select multiple cells from C2: C1051 for Mac Which corresponds with a measured.. Are working on by uploading it here row, then press F8 and the and! Columns a, B, C, etc. uploading it here click OK + keys...