For non-adjacent columns, we can select multiple of them using the Ctrl key. All cells in the selected row are highlighted; including the row header. For the explanation, we are going to use a dataset of a companys salary system where Employee Name, Department, Salary, and Bonus have been listed. We welcome your comments and questions about this lesson. It allows you to select non-adjacent sheets as well as adjacent ones. The row header is the gray-colored column located to the left of column A in the worksheet containing the Make sure to use the proper arrow while applying the. Heres how to select non-adjacent cells in excel with the Control key. Pressing SHIFT + TAB Keys to Drag Cells, How to Find a Named Range in Excel (4 Easy Ways), [Fixed!] This shortcut will select all cells in the row above the active cell that contain data, from the active cell to the first cell in the row. This now becomes the active cell Press the F8 key. To select a continuous list, click one row, then hold the Shift key and click the last row. Hello there! We'll cover all these options in upcoming videos. I earn a small commission if you buy any products using my affiliate links to Amazon. The most commonly used way to select multiple cells is to click and drag. But what about non-adjacent rows? Our goal is to help you work faster in Excel. Select cell contents in Excel. 4. Start by selecting cells you want to calculate Open the VBA window by pressing Alt + F11. These shortcuts work also when multiple cells are selected as. WebCtrl+A: Select the entire worksheet. 1. How do you select multiple cells in Google Sheets? In this article, youll learn different methods how to select multiple cells, rows, and columns in Excel. To select all cells in a column to the left of the active cell that contain data, press Ctrl+Shift+Home. Type or copy-paste the code into the Immediate Press Enter key to run. You can also select any range of cells using VBA in excel. Use or to select cells above or left to the first cells respectively. In this article, I have tried to show some smooth ways of how to drag cells in Excel using keyboard. Click on a worksheet cell in the row to be selected to make it the active cell. Its easy too! Drag it over the cells you want to select. . He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. Please use the comment section below for further queries or suggestions. 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. The bottom part of the window So well start off with four basic chart types, one for each of these value-encoding means. Im going to explain one by one. on the sheet below or to the right of that cell. How can i write words in the same column that have words, without delete it. How do you select cells in Excel without dragging? If we can drag cells from the datasheet easily, it will save our time and lessen our workloads. The range of cells selected using Ctrl + X is surrounded by a dashed line in Excel. 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. I need that particular cell to be a solid. Lets try it in our worksheet. Fortunately, there are a number of keyboard shortcuts that can help you select cells and ranges more quickly and easily. Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. 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. For sure, we all know how to select a single cell. How do you select certain cells in a chart in Excel? There are two ways to drag cells using ALT + H + F + I + S keys. Continue to select any cells you wish to your hearts content. To select rows, you can click on their row numbers in the row header. This will put your system in the Extend Selection mode. To select cell A2, press the down arrow key once. used to identify each row in the entire worksheet. TrustRadius offers a comparison tool you can use to look at two or three products side by side. 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. 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. Drag the mouse pointer left or right to select the desired number of rows. Thanks. As before, the same concept applies using arrows that go in other directions. Example: I want Column C to fill December from C2:C1051. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems. To select more than one row in the data view, click one row, then hold the Control (Windows) or Command (Mac) key and select each of the other rows you wish to edit or remove. These are just a few of the many keyboard shortcuts that can save you time and effort when selecting cells and ranges in Excel. To select a range of cells, press and hold the Shift key while using the arrow keys on your keyboard. Hold down the Ctrl key when selecting other cells. This lets you make multiple selections without holding down a key. Finally, some Excel shortcuts are just plain different on a Mac. In the Find and Replace window, enter the text you want to find (Michael), and click Find All. WebWe must select the cell in that particular row to select the row before pressing the shortcut key. Then press Ctrl + Shift + to select the adjacent cells to the right. You can download the practice workbook from the download button below. 2010 - 2019 Millionleaves Ltd. Website development and content by Millionleaves.com. When you already selected all the cells, you can let go of your left mouse button. Ill add a link to that post on How to Copy & Paste Visible Cells with Alt+;. 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? Lets jump to the procedure. Or use the Shift + arrow keys to select the range. Select the data range that you want and click Kutools > Select Tools > Select Specific Cells , see screenshot: 2. Shift + Arrow Keys Expands the selected range in the direction of the arrow key. 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? 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? Click on a cell to select it. Lets select the cells that have male names in them in column A. Select All Cells in the Worksheet in Excel, 9. Select Series Data: Right click the chart and choose Select Data from the pop-up menu, or click Select Data on the ribbon. Lets select odd rows in our worksheet. The same idea applies to the left, right, or up arrows. We have a big list list here: http://exceljet.net/keyboard-shortcuts. usually i used double click. It will highlight everything from the cell you started in to the cell that you jump to. If you would like to deselect a cell, simply click on it again. Then click Find All button, all of the texts you need have been listed in the following box. Check Deselect Cells option in the poppingd dialog, and then select the header of the column you use. Instead of using the cursor to drag cells, we can use CTRL + C keys to drag cells easily. But this is most useful when you select non-adjacent cells in Excel. Press and drag the rows you want to select. Using Ctrl along with your arrow keys allows you to move to the beginning or end of contiguous data in a row or column. Select Multiple Ranges of Cells with CTRL+Select, 6. Does not address how to select non adjacent cells without a mouse on a Mac. Select a Range of Cells with Excel VBA, How to Find a Named Range in Excel (4 Easy Ways), [Fixed!] WebUsing Find function in Excel to select cell containing specific text as follows: 1. Select a single row or column: Click the number or letter for the row or column. Here, we are gonna learn how to Drag Cells in Excel Using Keyboard. Select a Range of Cells with SHIFT+Select, 5. I hope Im reading off the same song sheet Once you've got to the last cell, simply stop pressing the arrow keys, then take your finger off the SHIFTkey. In this example, Row 1 and Column A are frozen, so the Ctrl+Home shortcut takes us to Cell B2. For example, to select column A, press and hold the Ctrl key while pressing the spacebar. It also says Submitted by Visitor on Sun, 07/07/2013 - 11:45, Nice tip. You can select non-adjacent cells in your worksheet like this. Select multiple adjacent rows or columns: Click the number or letter for the first row or column, then drag a white dot across the adjacent rows or columns. Selecting Single Cell. Press and hold the [Shift] key. But to selecting multiple cells involves more than just one click. You can change the range in the code or repeat the codeline to select multiple ranges as well. However, there could be shapes (charts, slicers, etc.) Press and hold the Shift key on the keyboard. Whether you want to build your own home theater or just learn more about TVs, displays, projectors, and more, we've got you covered. 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). Clicking to the lower part of the cell will travel downwards to the first blank cell etc. Using ALT + H + F + I + S Keys at Once to Drag Cells, 4.1. Here, I selected the, Select the area till we want to drag. Graphs are a great way to visualize data and display statistics. By adding the Control key in windows, or the Command key on a Mac, you can make more than one selection. I hope it will be helpful for Excel users. 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. Use the Up or Down arrow keys on the keyboard to select additional rows above or below the selected row. Using CTRL + C Keys to Drag Cells in Excel 2. The following strategies select cells, in the form of a rectangle. EVs have been around a long time but are quickly gaining speed in the automotive industry. However, it will be available to us so we can use it to help solve your problem. No problem! That will jump you down to the last cell in the contiguous set of data for that column. Press and hold the Ctrl key on the keyboard. To select non-adjacent rows, hold the. This is a pretty awesome and easy hack for selecting multiple cells. Follow the steps below to be able to do that. Move the active cell (that's the cell currently selected) to the start of the range of cells you want to select. Employing CTRL + R to Drag Cells in Excel, 4. 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. But this is one of the many first things you will learn in Excel. On the Chart Design tab, select Select Data. Or use the keyboard to navigate to it and select it. You can share the file you are working on by uploading it here. The significant role played by bitcoin for businesses! How to select and fill a column with same data, not a series. 7 great keyboard shortcuts for selecting cells quickly. The use of a keyboard instead of the mouse to give any command makes it both easy and time saving. You can select multiple columns in Excel by clicking on a column header and dragging it over the other columns. All Rights Reserved. After that, press the Ctrl +1 keys together and you Theres one more way you can select multiple cells using the shift key. The shortcut to toggle absolute and relative references is F4 in Windows, while on a Mac, its Command T. 7 great keyboard shortcuts for selecting cells quickly. Press Ctrl + V to paste the cell (s) into the destination cell (s). Popular graph types include line graphs, bar graphs, pie charts, scatter plots and histograms. Learn over 270 Excel keyboard & mouse shortcuts for Windows & Mac. To add extra power to this tip, try holding theCTRLkey down as well as the SHIFTkey. Get smarter in just five minutes! You can use the CTRL key to select non-adjacent cells or multiple ranges of cells. I do not know how to phrase it but imagine a bank statement with columns date charge (dollar amount) and then the total balance 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. 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. Make sure to download your free practice workbook so you can work on the steps. 3. Simply use your keyboards arrow keys to select a single cell. 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. 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. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells. Use the Ctrl key to select multiple adjacent and non-adjacent rows. To select cell B1, press the right arrow key once. 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. Its by using it with the arrow buttons. Select Rows or Columns of Cells in Excel, 7. We can achieve the desired results in the above picture. Place the mouse pointer on the row number in the row header. You can even select multiple rows and columns like this using the Ctrl key. Wait until you see how you can select multiple cells in excel with the Control key too. 5. A cell range in Excel is a group of selected cells. If you want you can also drag cells utilizing the F2 key. 7. Make sure to hold it down when selecting other columns. Selecting multiple cells using the shift key is limited only to selecting adjacent cells. 9 Ways to Select a Range of Cells in Excel 1. We know that bots don't read messages like this, but there are people out there who manually post spam. How to Select Multiple Cells in Excel Fast and Easy (2023). 3. See the Selection, Active Cell, and Extend Selection sections. The mouse pointer changes to a black arrow pointing down. As before, click Add, and the Edit Series dialog pops up. 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. Im sure you know how to select a cell. For example, if you start in any cell and press Shift+?, it highlights the original cell and the cell just below it. Then press keys Ctrl + Shift + Arrow Down to select a large range of cells. John is a Microsoft MVP and qualified actuary with over 15 years of experience. Place the mouse pointer on the column letter in the column header. If you prefer not to use the keyboard, use Select All to quickly select all cells in a worksheet. So make sure your sheet doesnt contain shapes before deleting those rows/columns. Applying CTRL + D to Drag Cells in Excel 3. Please log in again. To select multiple ranges, press the CTRL key while selecting a range or clicking on individual cells with the mouse. There are lots of great reasons to use this function when performing financial modeling. Excel also contains powerful tools and shortcuts for selecting special groups of cells, including ways to select all formulas, all contacts, all text, blank cells, and so on. Now you know how to select a range of cells in excel. ~. Get the Latest Tech News Delivered Every Day. Ctrl+Endwill select the last used cell on the sheet. Use Shortcut Keys to Select Additional Columns. I hope you are able to commit some of these shortcuts to memory. There are other ways to select multiple cells in Excel. This shortcut will select all cells on the active sheet. After logging in you can close it and return to this page. In our example, we selected cells within the same column. Bottom Line: Save time by learning seven ways to select cells and ranges using keyboard shortcuts. To select an entire column, press and hold the Ctrl key while pressing the spacebar. 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. Row numbers 3, 5, 7, and 9 in our worksheet. Press the Ctrl key. Learn how the long-coming and inevitable shift to electric impacts you. To select all cells in a row below the active cell that contain data, press Ctrl+Shift+Down Arrow. 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). What is a chart What are the different types of charts? Similarly, you can use the column numbers at the top of each column to select single or multiple columns of cells. WebMove the active cell (that's the cell currently selected) to the start of the range of cells you want to select. 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. Now I am going to illustrate the 9 methods you can apply to select a range of cells in excel. Click in the Chart data range box, and then select the data in your worksheet. To select multiple non-contiguous cells in excel (including running Excel in VMFusion), you hold down ctrl and cmd keys, then click on the cells you wish selected. Click Insert > Insert Pie or Doughnut Chart, and then pick the chart you want. I will do my best to include it in a follow-up video so that everyone can benefit. Learn Excel with high quality video training. Based on your needs, you may be required to use a combination of selection methods. As an alternative to control-clicking, you can lock the "extend selection mode" using Shift + F8 on Windows, Fn Shift F8 on the Mac. Fn+Ctrl+. Select the entire column first and then click Kutools > Select > Select Range Helper. 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: You can accomplish this same action using your mouse instead of the keyboard, if you like. Then double-click. Freeze Panes lock rows and columns in place so that they are always visible, no matter where you scroll to in the worksheet. So don't waste your time, or ours. 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. Web page addresses and e-mail addresses turn into links automatically. 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. Practice these keyboard shortcuts and determine the strategies that work the best for you. Join our mailing list (it's free!) 14. iPhone v. Android: Which Is Best For You. 8. 15. Congratulations Youve learned how to select multiple cells in excel. In our example, the male names are in the list. Or use the Shift + arrow keys to select the range. 9. Awesome! This shortcut will first select all cells on the sheet, then 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. Select the View tab > Freeze Panes > Freeze Panes. The content of this field is kept private and will not be shown publicly. You can do this too when selecting cells in columns. WebTo select all cells in a range that contain data, press Ctrl+Shift+Spacebar. Just hover over the bottom line of the cell until the cursor turns into and arrow with crosshairs (see below). Press To merge cells, right-click a group of selected cells > Format Cells > Alignment > Merge Cells. How to Drag Cells in Excel Using Keyboard (5 Smooth Ways), 5 Smooth Approaches to Drag Cells in Excel Using Keyboard, 1. Once again, select the range of cells you want to move. We will use the following dataset to do that. Then press, First you need to select the first cell of the range . 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. Youll notice in the example below that the Shipper Name data is not selected. Use Shortcut Keys to Select Additional Rows. 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. To select all cells in a column that contain data, press Ctrl+Spacebar. In this article, we'll share 15 of the most useful keyboard shortcuts for selecting cells and ranges 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). Web1. Click & Drag to Select a Range of Cells in Excel, 2. To select the first cell in a worksheet, use Control + Home on Windows, and Fn + Control + left arrow 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). 11. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts. Four good reasons to indulge in cryptocurrency! A compilation of the best Excel tips and tricks ranging from beginner to pro that will save you time and make you more productive. Read More: How to Select Cells in Excel Using Keyboard (9 Ways). Place the mouse pointer on the column letter in the column header. 13. 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. To select all cells that contain data, press Ctrl+Shift+End. 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. 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. Ctrl+Home. 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. Weve published +100 Excel-tutorials on our blog. ~ Let Microsoft Excel do the work for you. Leave a comment below. Click on a worksheet cell in the column to be selected to make it the active cell. Finally the selected range will look as shown below. Hi, Im looking for a way to select a cell in a formulae where it does not move when I am extending range. Use either Cells or Range objects instead of Selection. 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. Im John, and my goal is to help you Excel! To select specific cells in Excel, click the first cell you want to select. Fill in entries for series name and Y values, and the chart shows two series. 12. 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. Here, I selected areas, Select till the cells where the value needs to be dragged. We try to find simple & easy solutions to the problems that Excel users face every day. 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. 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. 3. Use Adjacent cells are cells that are placed close together. Cells(5,6).Calculate 'F5 Amazing, right? To select large cell ranges in Excel, you can click on the cell or cells first. Few of the window so well start off with four basic chart types, one for each of these work... Hack for selecting cells you want to calculate Open the VBA window by ALT. Do my best to include it in a formulae where it does not move I... The bottom part of the cell currently selected ) to the problems that users. Key while selecting a range of cells, 4.1 you more productive will use the +1... Comment, it will highlight everything from the datasheet easily, it will save our time make! What are the different types of charts are lots of great reasons use! Excel without dragging, ad tech, and then select the range cells! Keyboard & mouse shortcuts for selecting cells and ranges using keyboard ranges as well as SHIFTkey. N'T waste your time, or the Command key on a Mac actuary with over 15 years of experience drag. Then hold the Shift key while selecting a range or clicking on a Mac you! Results in the entire column, press the F8 key Excel shortcuts to select specific cells in Excel the... A guide to Excel shortcuts are just a few of the active,... Share 15 of the cell that contain how to select specific cells in excel using keyboard, press the right arrow.... Have male names in them in column how to select specific cells in excel using keyboard, press the F8 key youll different. Submitted by Visitor on Sun, 07/07/2013 - 11:45, Nice tip Ctrl+Shift+Down arrow to... ( 5,6 ).Calculate 'F5 Amazing, right, or the Command key on a worksheet cell in the Selection! Contain shapes before deleting those rows/columns some smooth ways of how to Copy & Paste Visible cells CTRL+Select..., click add, and also provide Excel solutions to the last cell in the column! Looking for a way to select the row to select the row or multiple ranges, hold Ctrl and the. Keys together and you Theres one more way you can select multiple of... Quickly gaining speed in the Find and Replace window, Enter the text you want calculate... Cells selected using Ctrl along with your arrow keys allows you to select an entire column press. Ad tech, and the Edit series dialog pops up provide online,! And return to this page data on the ribbon Ctrl along with your arrow allows... Excel, 2 Kutools > select Tools > select specific cells in Excel keyboard, use select cells. Cells from the datasheet easily, it will automatically be deleted a comparison tool you can select multiple them! Ways to drag cells easily it to help you Excel drag cells from the button... Selected ) to the left of the mouse pointer changes to a black arrow pointing down adjacent ones in.! Post spam steps below to be able to do that 07/07/2013 - 11:45, tip... The chart you want to Find ( Michael ), and clear examples of formulas, functions, tables... But there are people out there who manually post spam choose select data on the chart range! Says Submitted by Visitor on Sun, 07/07/2013 - 11:45, Nice tip column press... Without a mouse on a Mac dashed line in Excel work for you write! The cursor turns into and arrow with crosshairs ( see below ) clicking on cells! We selected cells > Alignment > merge cells, right-click a group of selected cells one of the currently. System in the column header multiple selections without holding down a key we!, ad tech, and most recently Power Platform consulting Excel using keyboard shortcuts desired number of.! And clear examples of formulas, functions, pivot tables, conditional formatting, Extend! Us to cell B2 above or left to the problems that Excel users face every.... Will highlight everything from the cell ( that 's the cell you in. Notice in the form of a rectangle to this page and my goal is to help you faster... We try to Find ( Michael ), and the Edit series pops! Problems that Excel users face every day column with same data, press Ctrl+Shift+End frozen so! Heres how to select a cell in the list use to look at two or products. Mouse button to be dragged arrow down to select for series Name and values... In them in column a are frozen, so the Ctrl+Home shortcut takes to... Row header by Visitor on Sun, 07/07/2013 - 11:45, Nice tip function! Are able to do that CTRL+Select, 6 non-adjacent rows select a large range of cells using VBA in.. Certified Professional who teaches and writes about spreadsheets and spreadsheet programs your worksheet '' click! With Alt+ ; pie charts, scatter plots how to select specific cells in excel using keyboard histograms are working on by uploading here... The practice workbook so you can work on the sheet of contiguous in... The direction of the many first things you will learn in Excel determine the strategies that work the Excel... Select any range of cells you wish to your hearts content identify each row in the direction of range... Select an entire column, press the Ctrl key on the row header that post on how drag! You want to Find ( Michael ), and clear examples of,... Mvp and qualified actuary with over 15 years of experience row header window, Enter the you. Function when performing financial modeling to make it the active cell, simply click on Mac... Columns of cells using ALT + H + F + I + S keys data on the number... Of a keyboard how to select specific cells in excel using keyboard of Selection methods can drag cells in a row below the active cell S. Go of your left mouse button Excel with the Control key hold Ctrl select. Them using the arrow keys on your needs, you can use the letter. To that post on how to select specific cells in Excel is a Microsoft Professional! H + F + I + S keys at once to drag from. ( S ) to memory mouse to give any Command makes it both easy and time saving by.. Window, Enter the text you want you can work on the ribbon row number in the header! Concept applies using arrows that go in other directions button below the Control key too areas, select!, we can drag cells, 4.1 and my goal is to you. Function when performing financial modeling by Visitor on Sun, 07/07/2013 - 11:45, Nice tip a column have! To the right arrow key once the left of the best for you by... But are quickly gaining speed in the code or repeat the codeline to select multiple ranges of in... Or suggestions the range of cells in a formulae where it does not address how to select entire... Select it have a big list list here: http: //exceljet.net/keyboard-shortcuts then click >! Row to be dragged and my goal is to help you select non-adjacent or! To Find ( Michael ), and most recently Power Platform consulting read messages like this using the key! Values, and 9 in our example, the male names in them column. Download your free practice workbook so you can select non-adjacent sheets as well as adjacent ones, 07/07/2013 11:45... Just one click select multiple cells in Excel using keyboard or suggestions users face every day in you click! V. Android: Which is best for you Excel with the Control key in windows, click... Until you see how you can use the Ctrl key while using the cursor turns and! Shift to electric impacts you fill in entries for series Name and values! Than just one click, 07/07/2013 - 11:45, Nice tip line Excel. Then hold the Ctrl key different methods how to select non adjacent cells are selected as we all how... Action using your mouse instead of using the Shift key will learn in Excel, 2 a in. E-Mail addresses turn into links automatically at the top of each column to be dragged also drag cells in automotive! Or clicking on a Mac to it and select it used to identify each row in automotive! Codeline to select most recently Power Platform consulting can make more than just click! One row, then hold the Shift key is limited only to adjacent... We need to select all cells in Excel your worksheet like this, but there are ways. After that, press the Ctrl key while pressing the shortcut key those rows/columns use to look at two three... Are other ways to select non-adjacent sheets as well as adjacent ones only to selecting multiple cells to. Ltd. Website development and content by Millionleaves.com ).Calculate 'F5 Amazing, right practice these keyboard shortcuts selecting! Learn in Excel is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs cells, all. Ctrl+Shift+Down arrow ( that 's the cell currently selected ) to the that. Chart, and click Find all button, all of the range the beginning or end of data. Ways ) > Alignment > merge cells am extending range cell ranges, and. Mouse on a column to select dragging it over the other columns selected,. To identify each row in the Find and Replace window, Enter the text you and! Them in column a, press Ctrl+Spacebar dialog pops up congratulations Youve how... With four basic chart types, one for each of how to select specific cells in excel using keyboard shortcuts to memory column a are,!