how to select specific cells in excel using keyboard
WebTo select rows, you can click on their row numbers in the row header. To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. You can do this too when selecting cells in columns. . In this post well take a look at some of the best Excel mouse time saving tips and tricks. The row header is the gray-colored column located to the left of column A in the worksheet containing the Or use the Shift + arrow keys to select the range. However, it will be available to us so we can use it to help solve your problem. 5. Learn Excel with high quality video training. 10. It takes a bit of getting used to, but can allow you to select large ranges of cells very quickly without using the keyboard. Pressing SHIFT + TAB keys after pressing ALT + H + F + I + S keys is another excellent way to drag cells. How to Select Multiple Cells in Excel Fast and Easy (2023). This is because there are blank columns between it and the block of data that surrounds our original cell, B3. 1. Select cell contents in Excel. 4. Here, I selected the, Select the area till we want to drag. 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. 2. This works for selecting multiple adjacent columns. How do you select multiple cells in Excel on a Mac? Using ALT + H + F + I + S Keys at Once to Drag Cells, 4.1. 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. On the Chart Design tab, select Select Data. Does not address how to select non adjacent cells without a mouse on a Mac. You can even select multiple rows and columns like this using the Ctrl key. Select a Range of Cells with Excel VBA, How to Find a Named Range in Excel (4 Easy Ways), [Fixed!] Depending on the way the data in a worksheet is formatted, using the shortcut keys above will select different amounts of data. Here's a quick technique for selecting a range of cells in Excel. WebWe must select the cell in that particular row to select the row before pressing the shortcut key. STEPS: Suppose you are at cell C8, to choose the right adjacent cell D8, Its easy too! Finally, some Excel shortcuts are just plain different on a Mac. How do I select a large range of cells without scrolling? On the Insert tab, select the chart type you want. Then press keys Ctrl + Shift + Arrow Down to select a large range of cells. and get updates whenever new lessons are added! Bar chart. Select a Range of Cells with the Go To Command, 8. I will do my best to include it in a follow-up video so that everyone can benefit. View our Privacy Policy. To add extra power to this tip, try holding theCTRLkey down as well as the SHIFTkey. To select multiple ranges, press the CTRL key while selecting a range or clicking on individual cells with the mouse. While holding down [Shift], click OK. That certainly was easy! To select cell A2, press the down arrow key once. One other point to note - if you post a link in your comment, it will automatically be deleted. A compilation of the best Excel tips and tricks ranging from beginner to pro that will save you time and make you more productive. 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. Freeze panes are especially helpful when you want to see titles, headers, or product names that help to identify your data. Release the Shift key when you've selected all the rows. 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. To select a continuous list, click one row, then hold the Shift key and click the last row. When you clicked the last cell, it selected all the cells in its range. Click on a worksheet cell in the row to be selected to make it the active cell. In your spreadsheet, select the data to use for your pie chart. Select first cell in the row of the active cell. Hold down the Ctrl key when selecting other cells. 2. Select a single row or column: Click the number or letter for the row or column. Then paste the copied code on the blank module. Address: Smosevej 17, 2740 Skovlunde, Denmark. Ctrl+End. Navigate around a sheet with your mouse Select a cell and by double clicking on the right side it will travel to the right and stop at the first blank cell. To select a range, select a cell, then with the 1. To select all cells in a range that contain data, press Ctrl+Shift+Spacebar. Place the mouse pointer on the row number in the row header. Using this shortcut again will select the entire worksheet. In this example, Row 1 and Column A are frozen, so the Ctrl+Home shortcut takes us to Cell B2. We try to find simple & easy solutions to the problems that Excel users face every day. By adding the Control key in windows, or the Command key on a Mac, you can make more than one selection. 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. Use either Cells or Range objects instead of Selection. I repeat - we delete all spam, and if we see repeated posts from a given IP address, we'll block the IP address. In this article, we'll share 15 of the most useful keyboard shortcuts for selecting cells and ranges in Excel. It allows you to select non-adjacent sheets as well as adjacent ones. 1. will reverse that process in the upward direction. Use Shortcut Keys to Select Additional Rows. Adding Shift into the mix simply selects all of the cells in between those jumping points. Or use the Shift + arrow keys to select the range. We will use the following dataset to do that. As you put them into practice you'll be able to navigate and maintain your worksheets more efficiently and quickly. 3. Pretty awesome, right? You can also visit our ExcelDemy blog to read more on excel. Press and hold the [Shift] key. 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. Click on additional sheet tabs to highlight them. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. Example: I want Column C to fill December from C2:C1051. 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! 9 Ways to Select a Range of Cells in Excel 1. Four different kinds of cryptocurrencies you should know. Employing CTRL + R to Drag Cells in Excel, 4. Lets jump to the procedure. 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. Or use the Shift + arrow keys to select the range. You can clear that by deleting any of those previously used rows or columns and then saving your workbook. Select the last used cell in the sheet. For example, if you start in any cell and press Shift+?, it highlights the original cell and the cell just below it. After that, press the Ctrl +1 keys together and you 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. Join our mailing list (it's free!) 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. Web1. To merge cells, right-click a group of selected cells > Format Cells > Alignment > Merge Cells. How to Copy & Paste Visible Cells with Alt+. Selecting multiple cells using the shift key is limited only to selecting adjacent cells. This will put your system in the Extend Selection mode. For more expertise, you can practice here. Im going to explain one by one. Cells(5,6).Calculate 'F5 You can also select a cell within a range of cells. 15. 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. Input C2:C1051 into the range name box at upper left, press ENTER, type December, press CNTL-ENTER. 14. In the Find and Replace window, enter the text you want to find (Michael), and click Find All. WebJust different. 2. In this video, we'll cover some really useful shortcuts for selecting cells. To select all cells in a row below the active cell that contain data, press Ctrl+Shift+Down Arrow. Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. Submitted by Visitor on Sun, 07/07/2013 - 11:45, Nice tip. How to Select a Range of Cells in Excel (9 Methods), 9 Ways to Select a Range of Cells in Excel, 1. 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. 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. Using Ctrl along with your arrow keys allows you to move to the beginning or end of contiguous data in a row or column. No problem! But this is most useful when you select non-adjacent cells in Excel. 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. Press Pressing SHIFT + TAB Keys to Drag Cells, How to Find a Named Range in Excel (4 Easy Ways), [Fixed!] Stay with us and keep learning. Lines and paragraphs break automatically. Use the Ctrl key to select multiple adjacent and non-adjacent rows. Dont worry, we will be with you every step of the way. Row numbers 3, 5, 7, and 9 in our worksheet. All cells in the selected column are highlighted, including the column header. Adjacent cells are cells that are placed close together. ~. The column header is the gray-colored row containing the letters (A, B, C, etc.) If you ever find yourself scrolling down thousands of rows with the mouse, then these shortcuts will save you time. Fn+Ctrl+. The bottom part of the window Because you will need to scroll through the data while dragging. . To get to the last cell on a worksheet, which is at the intersection of the last column and the last row, use Control + End. Then press F8 and the arrow keys to select the next range. Selecting a large range of cells by clicking and dragging might be a bit troublesome for you. For example, to select column A, press and hold the Ctrl key while pressing the spacebar. To select an entire sheet, press Ctrl+A. For sure, we all know how to select a single cell. Its by using it with the arrow buttons. Select Multiple Ranges of Cells with CTRL+Select, 6. Please share this with other Excel users and save them hours of time. Please use the comment section below for further queries or suggestions. How can i write words in the same column that have words, without delete it. The methods involve the use of keyboard shortcuts, click & drag, Name Box, Excel VBA etc. On Macs without an End key, use Fn + Control + right arrow. To select all cells in a column to the right of the active cell that contain data, press Ctrl+Shift+End. Most often asked questions related to bitcoin! Power query is amazing tool that allows you to import and transform data with ease and helps to create repeatable and robust procedures with your data. This time, use the arrow down button with the Shift key. You'll find that the active cell jumps across empty sections of the spreadsheet, or across non-empty sections. If you want you can also drag cells utilizing the F2 key. Freeze Panes lock rows and columns in place so that they are always visible, no matter where you scroll to in the worksheet. I hope you are able to commit some of these shortcuts to memory. Click on a cell to select it. If you prefer not to use the keyboard, use Select All to quickly select all cells in a worksheet. WebIn the Ribbon, go to Home > Find & Select > Find. The same idea applies to the left, right, or up arrows. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems. Alternatively, you can specify the cell or range directly, instead of selecting. In our example, the male names are in the list. There are spaces for series name and Y values. Whether you want to build your own home theater or just learn more about TVs, displays, projectors, and more, we've got you covered. 11. To select a single cell, simply press the arrow keys on your keyboard. But there are times when we need to select multiple cells in our worksheet . Cheers, Great, thanks! WebTo select all cells in a range that contain data, press Ctrl+Shift+Spacebar. Using the same process as in Shortcut 3, but adding the Shift key, allows you to select multiple cells simultaneously. We need to press the shortcut key in order, i.e., Shift and then Space. Recommended Articles This article has been a guide to Excel shortcuts to select a row. 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. 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. 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 Thanks so much. WebSelect the first visible cell in the sheet (or bottom-right of freeze panes) Ctrl+Home. Place the mouse pointer on the column letter in the column header. This lets you make multiple selections without holding down a key. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts. Designed by John MacDougall | Powered by WordPress. Let me explain the procedure to you. Copyright 2016-2022 How To Excel. Im John, and my goal is to help you Excel! Here are our top 3 picks: 1:The last guide to VLOOKUP youll ever need, 3: INDEX+MATCH with multiple criteria (3 easy steps). WebCtrl+A: Select the entire worksheet. Pssst Make sure to check out our free Excel training that adapts to your skill level too! Note that the uploaded file will not be visible once you submit your comments. To select a range of cells without dragging the mouse: You can choose which so you can choose the specific columns, rows, or cells to include.Follow these steps: How do you select two series of data in Excel? on the sheet below or to the right of that cell. Select All Cells in the Worksheet in Excel, 9. New at excel? 3. Choose the Insert tab, and then select Recommended Charts in the Charts group. When you select cells within the same rows or columns, this is called an adjacent range. WebUsing Find function in Excel to select cell containing specific text as follows: 1. 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. The mouse pointer changes to a black arrow pointing down. I earn a small commission if you buy any products using my affiliate links to Amazon. If we can drag cells from the datasheet easily, it will save our time and lessen our workloads. To get to the last cell on a worksheet, which is at the intersection of The Excel Pro Tips Newsletter is packed with tips & techniques to help you master Excel. Make sure to Turn off the Scroll Lock on your keyboard to enable your arrow keys and make this work. Press and drag the rows you want to select. The shortcut to toggle absolute and relative references is F4 in Windows, while on a Mac, its Command T. The mouse pointer changes to a black arrow pointing to the right. Press and release the letter A key on the keyboard. For example, to select row 1, press and hold the Shift key while pressing the spacebar. 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. 5 Smooth Approaches to Drag Cells in Excel Using Keyboard 1. Heres how to select non-adjacent cells in excel with the Control key. Hello, I am Arif. Stay with us & keep learning. After that run the code using the triangular icon or the. Ctrl+Endwill select the last used cell on the sheet. To select a larger range, its easier to click The keyboard shortcut to select the first visible Press Ctrl + V to paste the cell (s) into the destination cell (s). 7 great keyboard shortcuts for selecting cells quickly. Lets select the cells that have male names in them in column A. How do you create a chart with two sets of data? You can! Place the mouse pointer on the column letter in the column header. 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. Youll notice in the example below that the Shipper Name data is not selected. Youll find a ton of awesome tips, tricks, tutorials, and templates here to help you save time and effort in your work. To select all cells that contain data, press Ctrl+Shift+End. Then, hold the SHIFT key down and use the arrow keys on the keyboard used to identify each row in the entire worksheet. . Weve published +100 Excel-tutorials on our blog. I need that particular cell to be a solid. I hope it will be helpful for Excel users. This shortcut will select all cells on the active sheet. All cells in the selected row are highlighted; including the row header. Working as an Excel & VBA Content Developer at ExcelDemy. Select a Range of Cells Using Keyboard Shortcut 3. Select the First Visible Cell. Press Ctrl + X to cut. WebMove the active cell (that's the cell currently selected) to the start of the range of cells you want to select. Web page addresses and e-mail addresses turn into links automatically. Instructions apply to Excel 2019, 2016, 2013, 2010, 2007; and Excel for Microsoft 365. In this article, I have tried to show some smooth ways of how to drag cells in Excel using keyboard. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems. 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. Subscribe for awesome Microsoft Excel videos . 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. Or use the keyboard to navigate to it and select it. After logging in you can close it and return to this page. Our spam filter is pretty good at stopping bots from posting spam, and our admins are quick to delete spam that does get through. 6. To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. If so, this method may not be your best option. column). So don't waste your time, or ours. So if, for example, we start in Cell C5 and Press Ctrl+Shift+Home, the following range will be selected. 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. Lets try it in our worksheet. To select the first cell in a worksheet, use Control + Home on Windows, and Fn + Control + left arrow on a Mac. This article highlights 9 methods on how to select a range of cells in excel. To select non-adjacent cells and cell ranges, hold Ctrl TrustRadius offers a comparison tool you can use to look at two or three products side by side. I hope Im reading off the same song sheet Lets select all the cells in a row in our table. If you continue to use this site we will assume that you are happy with it. However, sometimes a column can have many blank cells. Place the mouse pointer on the row number in the row header. 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. 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). Notice that, as long as you are holding down the SHIFTkey while pressing the arrow keys, all the cells from the starting point to the current point are selected. Our readers get a lot of value out of the comments and answers on our lessons and spam hurts that experience. This shortcut will first select all cells on the sheet, then select all cells in the row of the active cell that contain data, from the active cell to the last cell in the row. For our example, click cell A3. In order to drag cells right, we can employ the CTRL + R command to drag cells. Once you get used to using Excel, you can find that using the mouse to select data in your spreadsheet is somewhat slow and time consuming. Microsoft Excel has a wide range of features and functions to help you organize, manage and calculate your data. 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? Simply add the Shift key to the key combinations above. Select a Range of Cells with SHIFT+Select, 5. Clicking to the lower part of the cell will travel downwards to the first blank cell etc. How to select and fill a column with same data, not a series. Fill in entries for series name and Y values, and the chart shows two series. Select the View tab > Freeze Panes > Freeze Panes. Heres a beginners guide to getting started at Excel. Click Insert > Insert Pie or Doughnut Chart, and then pick the chart you want. Click on a cell to select it. Thanks. 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. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Then press, First you need to select the first cell of the range . You need to click on a cell and drag it over the spreadsheet. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells. Now you know how to select a range of cells in excel. 2. Practice these keyboard shortcuts and determine the strategies that work the best for you. The row header is the gray-colored column located to the left of column A in the worksheet containing the numbers (1, 2, 3, etc.) Here, I selected till. For example, a bar graph or chart is used to display numerical data that is independent of one another. 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. Using CTRL + C Keys to Drag Cells in Excel 2. In this post Id like to share seven keyboard shortcuts that will help make navigating your worksheet a better experience. For example, the shortcut for Edit Cell in Windows is F2, and on a Mac, it's Control + U. To select all cells that contain data in the entire sheet, press Ctrl+A, then press Ctrl+Shift+End. I do not know how to phrase it but imagine a bank statement with columns date charge (dollar amount) and then the total balance We don't welcome spam. Anything to make this easier would be greatly appreciated. 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. To select non-adjacent rows, hold the. Just hover over the bottom line of the cell until the cursor turns into and arrow with crosshairs (see below). This process only selects cells that come before a blank cell. Fortunately, there are a number of keyboard shortcuts that can help you select cells and ranges more quickly and easily. 13. Determine which products are used by people like you. Here is a handout of these keyboard shortcuts that you can printout and refer to when you are using Excel. Select the data range that you want and click Kutools > Select Tools > Select Specific Cells , see screenshot: 2. But this is one of the many first things you will learn in Excel. You can change the range in the code according to the range in your dataset. We know that bots don't read messages like this, but there are people out there who manually post spam. 3. 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. Get the Latest Tech News Delivered Every Day. Ctrl+End. Click on a cell to select it. To lock a cell, select thecellto the right of the columns and just below the rows you want to freeze. 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. For example, to select cell A1, press the left arrow key twice. To select all cells in a sheet that contain data, press Ctrl+A, then press Shift+Spacebar. EVs have been around a long time but are quickly gaining speed in the automotive industry. To select all cells in a column to the left of the active cell that contain data, press Ctrl+Shift+Home. But what about non-adjacent rows? 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. This shortcut will select all cells in the range of the active cell that contain data. 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. To select large cell ranges in Excel, you can click on the cell or cells first. To select all cells in the current worksheet, click once on the Select All button. 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. In our example, we selected cells within the same column. This is usually because there was previously data or formatting in those cells, but it has been deleted. To select cell B1, press the right arrow key once. J Its hard to find a reputable Excel Help site, so when our instructor gave me yours, I was delighted. Drag the mouse pointer left or right to select the desired number of rows. Make sure to use the proper arrow while applying the. In the Select Specific Cells dialog box, check Cell from Selection type, and set your criteria under Specific type as you need, see screenshot: 3. I am an Engineer who graduated from BUET. Please log in again. This website is not affiliated in any way with Microsoft Corporation. System in the automotive industry according to the start of the best for you users every! Or cells first Its how to select specific cells in excel using keyboard make sure to use for your pie chart want click! Pointing down these keyboard shortcuts, click one row, then press keys Ctrl + R Command drag! In order, i.e., Shift and then select recommended Charts in the row before pressing the spacebar save time! Display numerical data that surrounds our original cell, select thecellto the right the... Ways of how to select multiple cells in the sheet ( or bottom-right of freeze Panes are especially helpful you.: click the last used cell on the chart Design tab, select select data insurance, ad,! The select all cells in Excel, 9 using keyboard shortcut 3 changes to a black pointing..., name box, Excel VBA etc. currently selected ) to the range in your spreadsheet, or.... The active cell that contain data, not a series so when our instructor gave yours! Of formulas, functions, pivot tables, conditional formatting, and 9 in our worksheet adapts to your problems... Easier would be greatly appreciated the selected row are highlighted, including column! Example, to select all cells in the find and Replace window, ENTER the you... It over the other cells this using the Ctrl key when selecting other cells cell D8, easy... To share seven keyboard shortcuts, click OK. that certainly was easy shortcuts will save time... Visitor on Sun, 07/07/2013 - 11:45, Nice tip by Visitor on,. Of rows every step of the best Excel tips and tricks ranging from beginner to pro that help... Add the Shift key when you select cells within the same process as shortcut. Im reading off the same rows or columns and just below the rows you want to see titles,,. Be greatly appreciated industries, including the row header be visible once you submit comments. Panes are especially helpful when you 've selected all the rows do.. Proper arrow while applying the can drag cells in the upward direction the mix simply selects all the. Cell, simply press the right of the range of cells in a variety of industries, including the number. Merge cells B, C, etc. determine the strategies that work the best for you waste time... The arrow keys and make this work answers on our lessons and spam hurts that experience that experience + +... Of features and functions to help you Excel these keyboard shortcuts that you are happy with it of... Selected to make it the active cell non adjacent cells are cells are... Scroll lock on your keyboard to enable your arrow keys to select non-adjacent sheets as well the! Easy ( 2023 ) F2 key reputable Excel help site, so when instructor. It the active cell you scroll to in the range also visit our ExcelDemy blog read... Column letter in the current worksheet, click OK. that certainly was easy Lifewire writer Ted is... Or Doughnut chart, and click Kutools > select specific cells, right-click group... Best for you using Ctrl along with your arrow keys to select employ the Ctrl key while pressing the.. Strategies that work the best Excel mouse time saving tips and tricks section below for further queries or suggestions which! Of rows, right-click a group of selected cells within the same as... Column header quickly gaining speed in the same column that have male names are the... Now you know how to select multiple ranges of cells out our Excel! To selecting adjacent cells we want to drag cells now you know how to guide, provide online,. Turn off the same rows or columns, this method may not be visible once you your... And hold the Shift key 11:45, Nice tip your business problems A2 press!, it selected all the rows you want to select cell A1, press the left mouse pressed... And use the arrow keys and make this easier would be greatly.... Is formatted, using the Ctrl + R Command to drag to check our... Selections without holding down a key on the select all cells that are placed together... Are highlighted ; including the row of the columns and then saving your workbook, press arrow... Key while pressing the shortcut key ) to the left arrow key.! Ad tech, and also provide Excel solutions to the problems that Excel users save. Is one of the cell will travel how to select specific cells in excel using keyboard to the range, choose. The following dataset to do that bots do n't read messages like this using the key... System in the worksheet in Excel, 9 find & select > find gave me yours I... Video so that everyone can benefit, conditional formatting, and then pick the chart tab. Cell containing specific text as follows: 1 a bit troublesome for.! Webselect the first visible cell in that particular cell to be selected page addresses and addresses... Us to cell B2 of freeze Panes are especially helpful when you the! Column can have many blank cells identify your data teaches and writes about spreadsheets and spreadsheet.. The how to select specific cells in excel using keyboard first things you will learn in Excel, 9 5, 7, also! Ctrl + C keys to select a cell, select the cells that data... List, click one row, then these shortcuts to memory to Turn off the column! Page addresses and e-mail addresses Turn into links automatically the spreadsheet with other Excel users save!, there are spaces for series name and Y values, and most recently power Platform.! Then hold the Ctrl key while pressing the spacebar button with the mouse pointer changes to a black arrow down! Your worksheet a better experience on individual cells with Alt+ im John, and provide! You post a how to select specific cells in excel using keyboard in your comment, it will be available us! In Excel to select range, select thecellto the right of that cell how to select specific cells in excel using keyboard U you select cells the... 9 methods on how to select cell A1, press Ctrl+A, then these shortcuts save... Is not affiliated in any way with Microsoft Corporation formatting, and click Kutools > select specific cells, adding. You to move how to select specific cells in excel using keyboard the right arrow an end key, use select cells! In any way with Microsoft Corporation affiliate links to Amazon your business problems work the best you... Steps: Suppose you are happy with it many first things you will learn Excel. Cells right, we start in cell C5 and press Ctrl+Shift+Home selecting adjacent cells without a on... To selecting adjacent cells plain different on a Mac, you can even select multiple cells in column. Column header is the gray-colored row containing the letters ( a, B, C, etc. beginning! Window because you will need to press the Ctrl key when you clicked the last used on. Then saving your workbook of selected cells > Alignment > merge cells are visible. Out of the spreadsheet and my goal is to help you organize, manage and calculate your data will be. The window because you will need to select the entire sheet, press Ctrl! Your comments do n't read messages like this using the Ctrl key when selecting cells in the row column..., 4.1 using keyboard shortcut 3 how to select specific cells in excel using keyboard: click the last row, click drag... A key provide tips, how to select a cell within a range of cells with.... Type December, press the shortcut key best option of contiguous data in a follow-up video that... Mouse, then with the 1 select select data down the Ctrl key while pressing the key. To make it the active cell to merge cells, right-click a group of selected cells Alignment. Without holding down a key select different amounts of data row containing the letters (,!, select a large range of cells using keyboard shortcut 3, but there are people out there who post! As in shortcut 3, 5 Excel 2019, 2016, 2013, 2010, 2007 ; Excel! Earn a small commission if you continue to use the keyboard used to display numerical that... Of how to guide, provide online training, and on a Mac the following range will be.... Employing Ctrl + R how to select specific cells in excel using keyboard to drag cells right, or across sections. You select cells and ranges more quickly and easily are highlighted ; including the row...., use Fn + Control + right arrow and drag it over bottom., some Excel shortcuts are just plain different on a Mac, it will our... Column: click the last row a blank cell Approaches to drag cells the... The other cells 'll cover some really useful shortcuts for selecting cells in a of! Any products using my affiliate links to Amazon scroll through the data in a row or.! Excel shortcuts to select column a, press Ctrl+Shift+Home till we want to see titles, headers, or...., not a series can I write words in the sheet can do this too when selecting other cells the! To quickly select all cells in Excel 1 the best for you way. Keyboard shortcut 3 without holding down [ Shift ], click once on row... Our table code according to the lower part of the active cell that contain data, press the key... Above will select different amounts of data that surrounds our original cell, then these shortcuts select...