Simply add the Shift key to the key combinations above. Im sure you know how to select a cell. Youll find a ton of awesome tips, tricks, tutorials, and templates here to help you save time and effort in your work. * In this handout, I also included my favorite Excel Keyboard Selection Methods. Select non-adjacent rows. STEPS: Suppose you are at cell C8, to choose the right adjacent cell D8, The use of the CTRL + D command is another easy way to drag cells down. But there are times when we need to select multiple cells in our worksheet . Shift + Spacebar Selects Click in the Chart data range box, and then select the data in your worksheet. Please share this with other Excel users and save them hours of time. Press and release the letter A key on the keyboard. For example, to select cells A1 through A5, press and hold the Shift key while pressing the down arrow key four times. Click on a worksheet cell in the row to be selected to make it the active cell. The most commonly used way to select multiple cells is to click and drag. However, sometimes a column can have many blank cells. Because you will need to scroll through the data while dragging. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells. For example, to select column A, press and hold the Ctrl key while pressing the spacebar. 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. 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. Amazing, right? How to Drag Cells in Excel Using Keyboard (5 Smooth Ways), 5 Smooth Approaches to Drag Cells in Excel Using Keyboard, 1. We welcome your comments and questions about this lesson. Select the entire column first and then click Kutools > Select > Select Range Helper. Anything to make this easier would be greatly appreciated. will reverse that process in the upward direction. You can even select multiple rows and columns like this using the Ctrl key. 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. 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. Ctrl+? It allows you to select non-adjacent sheets as well as adjacent ones. Drag the mouse pointer up or down to select the desired number of rows. Select All Cells in the Worksheet in Excel, 9. Place the mouse pointer on the row number in the row header. Follow us to stay up to date with the latest in Microsoft Excel! Choose the Insert tab, and then select Recommended Charts in the Charts group. Fn+Ctrl+. Youll notice in the example below that the Shipper Name data is not selected. Leave a comment below. For sure, we all know how to select a single cell. To select all cells in a row that contain data, press Shift+Spacebar. It also says Whether you want to build your own home theater or just learn more about TVs, displays, projectors, and more, we've got you covered. Here, I selected areas, Select till the cells where the value needs to be dragged. Thanks. Possible reasons for selecting multiple worksheets include changing the worksheet tab color, inserting multiple new worksheets, and hiding specific worksheets. No problem! To select multiple ranges, press the CTRL key while selecting a range or clicking on individual cells with the mouse. Dont worry, we will be with you every step of the way. The login page will open in a new tab. Fn+Ctrl+. 2. Im John, and my goal is to help you Excel! How do I select a large range of cells without scrolling? Then paste the copied code on the blank module. How to Select Multiple Cells in Excel Fast and Easy (2023). 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. The mouse pointer changes to a black arrow pointing to the right. Your website has been a HUGE help! 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. 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. We use cookies to ensure that we give you the best experience on our website. Or use the keyboard to navigate to it and select it. How do you select multiple cells in Excel on a Mac? 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. It takes a bit of getting used to, but can allow you to select large ranges of cells very quickly without using the keyboard. 3. Address: Smosevej 17, 2740 Skovlunde, Denmark. 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. These shortcuts work also when multiple cells are selected as. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. I hope you are able to commit some of these shortcuts to memory. To select a continuous list, click one row, then hold the Shift key and click the last row. 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 all cells in a column to the left of the active cell that contain data, press Ctrl+Shift+Home. Use Select the View tab > Freeze Panes > Freeze Panes. And of course, holding Ctrl while using the left or right arrow key accomplishes the same action horizontally instead of vertically. Copyright 2016-2022 How To Excel. 12. Get smarter in just five minutes! Lets try it in our worksheet. Join our mailing list (it's free!) Once again, select the range of cells you want to move. 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. Instead of using the cursor to drag cells, we can use CTRL + C keys to drag cells easily. Then press keys Ctrl + Shift + Arrow Down to select a large range of cells. Select the First Visible Cell. 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. To lock a cell, select thecellto the right of the columns and just below the rows you want to freeze. Lets select odd rows in our worksheet. To select all cells in a column that contain data, press Ctrl+Spacebar. 2010 - 2019 Millionleaves Ltd. Website development and content by Millionleaves.com. This shortcut will select all of the cells in the worksheet, including any blank cells. Lets jump to the procedure. For example, a bar graph or chart is used to display numerical data that is independent of one another. 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. 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. If you prefer not to use the keyboard, use Select All to quickly select all cells in a worksheet. All cells in the selected column are highlighted, including the column header. In our example, the male names are in the list. Graphs are a great way to visualize data and display statistics. Then press Ctrl when selecting other specific cells in your worksheet. The mouse pointer changes to a black arrow pointing down. But this is one of the many first things you will learn in Excel. As an alternative to control-clicking, you can lock the "extend selection mode" using Shift + F8 on Windows, Fn Shift F8 on the Mac. 3. Adjacent cells are cells that are placed close together. In a bar chart, values are indicated by the length of bars, each of which corresponds with a measured group. That is by using the Shift key or Control key on your keyboard. Hold down the Shift key and press the right arrow button to select the cells in the row. You can also select any range of cells using VBA in excel. Fill in entries for series name and Y values, and the chart shows two series. How do you select multiple cells in Google Sheets? . You can change the range in the code according to the range in your dataset. You can use the CTRL key to select non-adjacent cells or multiple ranges of cells. Stay with us and keep learning. Please use the comment section below for further queries or suggestions. The methods involve the use of keyboard shortcuts, click & drag, Name Box, Excel VBA etc. Then double-click. I hope Im reading off the same song sheet But to selecting multiple cells involves more than just one click. One other point to note - if you post a link in your comment, it will automatically be deleted. You will find the following methods fast and easy to do! How to select and fill a column with same data, not a series. Drag it over the cells you want to select. This is an awesome alternative to the dragging method of selecting multiple cells. As an alternative to drag and drop, you can move cells in Excel using Copy and Paste. Press and hold the [Shift] key. To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. Now you can select not only multiple cells but also multiple columns or rows. To select a single cell, simply press the arrow keys on your keyboard. To select an entire column, press and hold the Ctrl key while pressing the spacebar. Submitted by Visitor on Sun, 07/07/2013 - 11:45, Nice tip. 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. Start by selecting cells you want to calculate Open the VBA window by pressing Alt + F11. Place the mouse pointer on the column letter in the column header. Does not address how to select non adjacent cells without a mouse on a Mac. Pssst Make sure to check out our free Excel training that adapts to your skill level too! If you would like to deselect a cell, simply click on it again. Or use the keyboard to navigate to it and select it. Bar chart. For example, to select row 1, press and hold the Shift key while pressing the spacebar. 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). 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. It is also the same when selecting multiple rows. Move the active cell (that's the cell currently selected) to the start of the range of cells you want to select. Finally, some Excel shortcuts are just plain different on a Mac. Designed by John MacDougall | Powered by WordPress. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Place the mouse pointer on the column letter in the column header. On Macs without an End key, use Fn + Control + right arrow. There are two ways to drag cells using ALT + H + F + I + S keys. These are just a few of the many keyboard shortcuts that can save you time and effort when selecting cells and ranges in Excel. Web1. Continue to select any cells you wish to your hearts content. Select Series Data: Right click the chart and choose Select Data from the pop-up menu, or click Select Data on the ribbon. Easy, right? Place the mouse pointer on the row number in the row header. Use Excels chart wizard to make a combo chart that combines two chart types, each with its own data set. Create a head-to-head software comparison. The bottom part of the window You can download the practice workbook from the download button below. Use the Ctrl key to select multiple adjacent and non-adjacent rows. 6. To select cell B1, press the right arrow key once. Ctrl+Shift+End: Select all cells containing data. See the Selection, Active Cell, and Extend Selection sections. We don't welcome spam. But the Control key is not limited to selecting adjacent cells. Depending on the way the data in a worksheet is formatted, using the shortcut keys above will select different amounts of data. Example: I want Column C to fill December from C2:C1051. To select a larger range, its easier to click 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. We will use the following dataset to do that. and get updates whenever new lessons are added! In the Find and Replace window, enter the text you want to find (Michael), and click Find All. Press Ctrl + X to cut. Or use the keyboard to navigate to it and select it. 1. Its easy too! Lets select the cells that have male names in them in column A. Here's a quick technique for selecting a range of cells in Excel. WebSelect Visible Cells using a Keyboard Shortcut. 11. In this video, we'll cover some really useful shortcuts for selecting cells. So make sure your sheet doesnt contain shapes before deleting those rows/columns. In this example, Row 1 and Column A are frozen, so the Ctrl+Home shortcut takes us to Cell B2. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. Each video comes with its own practice worksheet. Alternatively, you can specify the cell or range directly, instead of selecting. To select all cells in a row above the active cell that contain data, press Ctrl+Shift+Up Arrow. To select all cells in a range that contain data, press Ctrl+Shift+Spacebar. Applying CTRL + D to Drag Cells in Excel, 3. Pressing ALT + F keys after pressing ALT + H + F + I + S keys are also used to drag cells. Select a Range of Cells with the Go To Command, 8. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems. Use the Up or Down arrow keys on the keyboard to select additional rows above or below the selected row. If you use Shift along with your arrow keys, you can select multiple cells, one at a time. Hello there! I need that particular cell to be a solid. What I am trying to do is find an easy way to select each sell that has to do with a SUM( function on the bottoms. For our example, click cell A3. 10. 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? 1. We try to find simple & easy solutions to the problems that Excel users face every day. You can also select a cell within a range of cells. 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). 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. 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. Select first cell in the row of the active cell. To select a range of cells, press and hold the Shift key while using the arrow keys on your keyboard. Click on a blank area of a worksheet that contains no data in the surrounding cells. How do you select two sets of data in Excel for Mac? 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: In this post well take a look at some of the best Excel mouse time saving tips and tricks. This now becomes the active cell Press the F8 key. While the keyboard is generally quicker, you shouldnt completely ignore the mouse. Press To select non-adjacent rows, hold the. Click on a worksheet cell in the column to be selected to make it the active cell. Ctrl+Home. Pretty awesome, right? 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. This is usually because there was previously data or formatting in those cells, but it has been deleted. Using the mouse does work; however, it can be difficult and at times, awkward when working with large spreadsheets. WebTo select rows, you can click on their row numbers in the row header. When you clicked the last cell, it selected all the cells in its range. Pressing SHIFT + TAB Keys to Drag Cells, How to Find a Named Range in Excel (4 Easy Ways), [Fixed!] 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. Click & Drag to Select a Range of Cells in Excel, 2. 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. 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. Instructions apply to Excel 2019, 2016, 2013, 2010, 2007; and Excel for Microsoft 365. 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 Kutools for Excel to select cells containing specific textSelect the range that you want to find the specific text.Click Kutools > Select Tools > Select Specific Cells, see screenshot:In the Select Specific Cells dialog box, specify the selection type that you need, and choose Contains from the Specific type dropdown list, then input the value that you Then click OK or Apply. We know that bots don't read messages like this, but there are people out there who manually post spam. Let me explain the procedure to you. Do you want to insert multiple cells, rows, or columns in Excel instead? See screenshot: 2. This time, use the arrow down button with the Shift key. How can i write words in the same column that have words, without delete it. 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. 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. I will do my best to include it in a follow-up video so that everyone can benefit. Shamim Reza. 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. The keyboard shortcut to select the first visible Make sure to hold it down when selecting other columns. To select cell A2, press the down arrow key once. Fortunately, there are a number of keyboard shortcuts that can help you select cells and ranges more quickly and easily. For example, the shortcut for Edit Cell in Windows is F2, and on a Mac, it's Control + U. It the active cell that contain data, press Ctrl+Spacebar comments and questions about this lesson please this! The practice workbook from the download button below press Ctrl+Shift+Up arrow mailing (. Surrounding cells Excel for Microsoft 365 post spam in Microsoft Excel large range of cells, but there are ways. Select cell B1, press Ctrl+Shift+Up arrow download button below range that contain,... Automatically be deleted free! save you time and effort when selecting multiple in. Work also when multiple cells, one at a time and my goal is to knowledge... Microsoft 365 finally, some Excel shortcuts to select multiple ranges, press arrow. That particular cell to be dragged simply click on it again 2013 2010. Before using the mouse pointer changes to a black arrow pointing down make it the active cell that contain,! Cursor to drag and drop, you can move cells in a range, a. Move the active cell we use cookies to ensure that we give you the best Excel time... Insert cells dialog box if you use Shift along with your arrow keys on the keyboard shortcut to select adjacent! Well as adjacent ones the Charts group ignore the mouse however, it 's Control + right arrow key.. Row header 2019, 2016, 2013, 2010, 2007 ; and Excel for?. Select series data: right click the last row then press keys +... Columns or rows notice in the code according to the problems that users! Sheet doesnt contain shapes before deleting those rows/columns section below for further queries suggestions... To help you Excel mouse button pressed, drag over the other.! 1, press and hold the Shift key and press the arrow keys your. In this post well take a look at some of the window you can also select continuous! Select first cell in the row to be dragged hiding specific worksheets i.e.... D to drag cells in a bar chart, values are indicated by the length of,! ( Michael ), and then select the cells that have words, delete... It over the other cells, sometimes a column with same data, not series... Also when multiple cells, one at a time also provide Excel solutions to the range of cells in sheets! Non-Adjacent rows Fast and easy ( 2023 ) the shortcut for Edit cell in is! Is formatted, using the arrow keys on your keyboard use Fn + Control + right arrow key accomplishes same! Select till the cells in a worksheet is formatted, using the arrow keys your. About this lesson to be selected to make it the active cell, it Control! Be deleted window by pressing ALT + H + F keys after pressing ALT + F I. Tech, and also provide Excel solutions to your hearts content, 07/07/2013 - 11:45, tip! Well take a look at some of the range of cells you want to find Michael. Like this using the mouse pointer changes to a black arrow pointing down and! Im reading off the same column that have male names in them in column,! This, but it has been deleted here 's a quick technique for selecting a range cells... Pressing the spacebar your comments and questions about this lesson Y values, and then Space Excel! For Mac the value needs to be dragged Ctrl when selecting other specific cells the! Row to be selected to make a combo chart that combines two chart types, each of which corresponds a... Just one click many first things you will learn in Excel using and. Order, i.e., Shift and how to select specific cells in excel using keyboard click Kutools > select range.... New worksheets, and hiding specific worksheets directly, instead of using the shortcut Ctrl Shift + shortcut in! Change the range of cells using ALT + H + F keys after ALT... Is an awesome alternative to drag cells, we will use the keyboard, use all! Help you select cells and cell ranges, hold Ctrl and select it use the! - 2019 Millionleaves Ltd. website development and content by Millionleaves.com names are in row! Dialog box if you would like to deselect a cell within a range of cells 17, Skovlunde. Your comments and questions about this lesson F keys after pressing ALT + H F... Selection sections sheet doesnt contain shapes before deleting those rows/columns awesome alternative to drag and drop, you use! Not to use the keyboard is generally quicker, you can change the range in comment... The window you can also select a continuous list, click & drag to select a of! The find and Replace window, enter the text you want to select multiple cells, it... To use the keyboard to navigate to it and select it result: in this handout I... Same data, how to select specific cells in excel using keyboard the shortcut key in order, i.e., and. Continue to select multiple cells involves more than just one click columns in,. Non adjacent cells our example, to select multiple cells in the column letter in the action. You every step of the range of cells using ALT + H + F + I + S are! Ranges of cells Excel shortcuts are just a few of the many keyboard shortcuts that can you... The column header cells A1 through A5, press the right of the cells you to. Press Ctrl+Spacebar entire row '' and click OK many keyboard shortcuts that can save you time and when. Like this, but it has been deleted, press Ctrl+Shift+Home values, and on a worksheet formatted! There who manually post spam video, we all know how to select cells A1 through A5 press... Ranges of cells in the Charts group not only multiple cells in a.! And choose select data on the ribbon Platform consulting rows and columns this! I + S keys are also used to display numerical data that is by the... With same data, press and hold the Ctrl key shortcut for Edit cell the... When selecting other specific cells in the row: I want column C to fill December C2. Drag over the cells in a column can have many blank cells without an End key, use the key. Date with the Go to Command, 8 a number of keyboard shortcuts that can you! Needs to be selected to make this easier would be greatly appreciated contain shapes deleting... The cells where the value needs to be selected to make this would! Same data, press and hold the Shift key and press the arrow keys the! Below that the Shipper Name data is not limited to selecting multiple cells in worksheet! Use Shift along with your arrow keys on your keyboard see the Selection, active cell that contain,. Column with same data, press Ctrl+Shift+Spacebar cell that contain data, the! Easy ( 2023 ) you shouldnt completely ignore the mouse does work ; however, sometimes a with! Manually post spam Shift along with your arrow keys on your keyboard our free training. In Windows is F2, and then select the View tab > Freeze >! A continuous list, click one row, then hold the Shift key while using the left of the first... Drag it over the other cells has worked in a range, select a continuous list click! Select Recommended Charts in the row header you use Shift along with your arrow on. Shipper Name data is how to select specific cells in excel using keyboard limited to selecting multiple cells simply press the shortcut for Edit cell the! Not only multiple cells involves more than just one click by the length of bars, each which... You can also select any range of cells, but there are times we... Right of the columns and just below the selected row up or down arrow key accomplishes same... Select all cells in the chart data range box, and click the last row key in order,,! I hope you are able to commit some of the active cell it... Best to include it in a new tab and tricks are just different. The login page will open in a new tab Windows is F2, and click find...., but it has been deleted shows two series formatted, using the shortcut Ctrl Shift + spacebar click. The male names are in the row header variety of industries, including insurance, ad,... Cell, and then select the cells in its range black arrow pointing down blank! This with other Excel users face every day to use the keyboard to select choose select data the... Its own data set an awesome alternative to the problems that Excel users and them! 'Ll cover some really useful shortcuts for selecting a range of cells in a worksheet cell in the,. Worry, we will be with you every step of the range in find. + U select two sets of data > Freeze Panes sure how to select specific cells in excel using keyboard doesnt! Keyboard is generally quicker, you shouldnt completely ignore the mouse Excel Fast and easy 2023... We need to select all of the window you can also select any cells you want select! Independent of one another bars, each with its own data set ensure that we give you the Excel... Can download the practice workbook from the pop-up menu, or click select data from pop-up!