The login page will open in a new tab. Lets try it in our worksheet. But this is most useful when you select non-adjacent cells in Excel. The use of the CTRL + D command is another easy way to drag cells down. Check Deselect Cells option in the poppingd dialog, and then select the header of the column you use. Finally the selected range will look as shown below. The keyboard shortcut to select the first visible Shamim Reza. Ctrl+Home. Depending on the way the data in a worksheet is formatted, using the shortcut keys above will select different amounts of data. 12. Select the First Visible Cell. We don't welcome spam. 3. Plus, youll learn about the SUM, COUNT, and AVERAGE functions. These shortcuts work also when multiple cells are selected as. For any further pieces of information, comment below. 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. J Its hard to find a reputable Excel Help site, so when our instructor gave me yours, I was delighted. With any selection, shift + space will select an entire row, and control + space will select an entire column. How do I create a pie chart from a list in Excel? You can also select a cell within a range of cells. Then, hold the SHIFT key down and use the arrow keys on the keyboard Select non-adjacent rows. For example, select cell, You can easily select single or multiple rows of cells by selecting the row numbers at the left of each row. Ctrl+Shift+End: Select all cells containing data. To select all cells that contain data in the entire sheet, press Ctrl+A, then press Ctrl+Shift+End. Congratulations Youve learned how to select multiple cells in excel. Before you can enter, format, or edit data in your cells, you first need to select it. Select a Range of Cells with SHIFT+Select, 5. Finally, some Excel shortcuts are just plain different on a Mac. . How to Copy & Paste Visible Cells with Alt+. 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. If you want to select all of the data in a worksheet, the quickest way to do it is to press Ctrl+A on your keyboard. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems. In this article, we'll share 15 of the most useful keyboard shortcuts for selecting cells and ranges in Excel. Click & Drag to Select a Range of Cells in Excel, 2. 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! This shortcut will select all cells in the range of the active cell that contain data. On the Insert tab, select the chart type you want. See screenshot: 2. Have a keyboard shortcut that you want to share? Lets select odd rows in our worksheet. Use the Up or Down arrow keys on the keyboard to select additional rows above or below the selected row. You can download the practice workbook from the download button below. Press and release the Spacebar key on the keyboard. For example, the shortcut for Edit Cell in Windows is F2, and on a Mac, it's Control + U. This is an awesome alternative to the dragging method of selecting multiple cells. Press Ctrl + X to cut. Here, I decided to, Select the areas where we want to drag. Use In our example, we selected cells within the same column. Do you want to insert multiple cells, rows, or columns in Excel instead? Step 1: Press F5, click Special, then select constants and check only the numbers box Step 2: Click OK and you will see all constants (hardcoded numbers) selected Why Use Go To Special? If your spreadsheet has multiple blocks of data, Excel does a pretty good job of selecting the block of data that is surrounding your cell when you press Ctrl+A. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Or use the Shift + arrow keys to select the range. Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. Click on a cell to select it. Heres how to select non-adjacent cells in excel with the Control key. Then press, First you need to select the first cell of the range . Continue to select any cells you wish to your hearts content. Im John, and my goal is to help you Excel! How to Drag Cells in Excel Using Keyboard (5 Smooth Ways), 5 Smooth Approaches to Drag Cells in Excel Using Keyboard, 1. 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. will reverse that process in the upward direction. 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). You can do this too when selecting cells in columns. 12. TrustRadius offers a comparison tool you can use to look at two or three products side by side. Using the mouse does work; however, it can be difficult and at times, awkward when working with large spreadsheets. 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. These selections do not need to be next to one another. 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. Use or to select cells above or left to the first cells respectively. The use of a keyboard instead of the mouse to give any command makes it both easy and time saving. 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: 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. Using CTRL + C Keys to Drag Cells in Excel, 2. Get smarter in just five minutes! I earn a small commission if you buy any products using my affiliate links to Amazon. Learn Excel with high quality video training. Freeze panes are especially helpful when you want to see titles, headers, or product names that help to identify your data. The rows are basically random charges and deposits 2. on the sheet below or to the right of that cell. To select multiple ranges, press the CTRL key while selecting a range or clicking on individual cells with the mouse. 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? 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. . Please share this with other Excel users and save them hours of time. We try to find simple & easy solutions to the problems that Excel users face every day. Learn how the long-coming and inevitable shift to electric impacts you. Popular graph types include line graphs, bar graphs, pie charts, scatter plots and histograms. Or use the Shift + arrow keys to select the range. Or use the Shift + arrow keys to select the range. Choose the Insert tab, and then select Recommended Charts in the Charts group. To select rows, you can click on their row numbers in the row header. You can press the arrows more times to extend the selection. You'll find that the active cell jumps across empty sections of the spreadsheet, or across non-empty sections. All you have to do is click on the cell in your worksheet using your mouse. However, sometimes a column can have many blank cells. To select a continuous list, click one row, then hold the Shift key and click the last row. Cells(5,6).Calculate 'F5 All cells in the selected row are highlighted; including the row header. To select non-adjacent cells and cell ranges, hold Ctrl This works for selecting multiple adjacent columns. Join our mailing list (it's free!) It is also the same when selecting multiple rows. Most often asked questions related to bitcoin! To select a larger range, its easier to click You can also select any range of cells using VBA in excel. For our example, click cell A1 in our practice workbook. Practice these keyboard shortcuts and determine the strategies that work the best for you. To select a single cell, simply press the arrow keys on your keyboard. 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. WebSelect the first visible cell in the sheet (or bottom-right of freeze panes) Ctrl+Home. How to Select Multiple Cells in Excel Fast and Easy (2023). A compilation of the best Excel tips and tricks ranging from beginner to pro that will save you time and make you more productive. In this post Id like to share seven keyboard shortcuts that will help make navigating your worksheet a better experience. ~ Let Microsoft Excel do the work for you. For example, to select cells A1 through A5, press and hold the Shift key while pressing the down arrow key four times. What is a chart What are the different types of charts? 7. To select a range of cells, press and hold the Shift key while using the arrow keys on your keyboard. Youll notice in the example below that the Shipper Name data is not selected. To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. Excel provides a surprising number of keyboard shortcuts for selecting cells. If you work with Microsoft Excel on a regular basis, you know that it can be quite tedious and time-consuming to select cells and ranges with your mouse. The Excel Pro Tips Newsletter is packed with tips & techniques to help you master Excel. I am an Engineer who graduated from BUET. The content of this field is kept private and will not be shown publicly. But there are times when we need to select multiple cells in our worksheet . All Rights Reserved. Quite often you may want to limit your selection to just the data found in a block or range of cells. This will put your system in the Extend Selection mode. For example, to select cell A1, press the left arrow key twice. The most commonly used way to select multiple cells is to click and drag. Fn+Ctrl+. I hope Im reading off the same song sheet Stay with us & keep learning. It allows you to select non-adjacent sheets as well as adjacent ones. I do not know how to phrase it but imagine a bank statement with columns date charge (dollar amount) and then the total balance Designed by John MacDougall | Powered by WordPress. 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. 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. Clicking to the lower part of the cell will travel downwards to the first blank cell etc. Move the active cell (that's the cell currently selected) to the start of the range of cells you want to select. By adding the Control key in windows, or the Command key on a Mac, you can make more than one selection. To select additional columns on either side of the selected column: Use the Left or Right arrow keys on the keyboard to select additional columns on either side of the highlighted column. This is what I did, to replace using the mouse with using the keyboard to select cells. Row numbers 3, 5, 7, and 9 in our worksheet. If you continue to use this site we will assume that you are happy with it. Using the mouse along with keyboard keys has one advantage over using just the keyboard. Let me explain the procedure to you. Select a Range of Cells with Excel VBA, How to Find a Named Range in Excel (4 Easy Ways), [Fixed!] Address: Smosevej 17, 2740 Skovlunde, Denmark. Use either Cells or Range objects instead of Selection. You can select non-adjacent cells in your worksheet like this. Press and hold the Shift key on the keyboard. 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. For example, a bar graph or chart is used to display numerical data that is independent of one another. And of course, holding Ctrl while using the left or right arrow key accomplishes the same action horizontally instead of vertically. This is a pretty awesome and easy hack for selecting multiple cells. But this is one of the many first things you will learn in Excel. Press and release the letter A key on the keyboard. Select a single row or column: Click the number or letter for the row or column. Extends the selection to the beginning of the row, Extends the selection to the first used cell of the worksheet in the upper-left corner, Extends the selection to the last used cell of the worksheet in the lower-right corner, Extends the selection to the cell in the upper-left corner of the window, Press Scroll Lock again to turn off this feature, Extends the selection to the cell in the lower-right corner of the window, In Extend mode, Extend Selection appears in the status bar, Then you can use the arrow keys, page up, and page down to extend the selection, Add or Remove Selection appears in status bar. You will find the following methods fast and easy to do! But what about non-adjacent rows? How do I select multiple cells in Excel using the keyboard? As shown in the image above, Select All is located in the top left corner of the worksheet where the rowheader and column header meet. See the Selection, Active Cell, and Extend Selection sections. Im sure you know how to select a cell. Leave a comment below. Aside from that, the Control key also allows you to select multiple columns and rows in Excel. The following strategies select cells, in the form of a rectangle. 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. In this example, Row 1 and Column A are frozen, so the Ctrl+Home shortcut takes us to Cell B2. Subscribe for awesome Microsoft Excel videos . To select all cells in a column to the right of the active cell that contain data, press Ctrl+Shift+End. How do you select multiple cells in Excel on a Mac? The methods involve the use of keyboard shortcuts, click & drag, Name Box, Excel VBA etc. We will use the following dataset to do that. Not only is it possible to move between sheets in a workbook using a keyboard shortcut, but you can also select multiple adjacent sheets with a keyboard shortcut as well. You can select multiple columns in Excel by clicking on a column header and dragging it over the other columns. Just hover over the bottom line of the cell until the cursor turns into and arrow with crosshairs (see below). To select large cell ranges in Excel, you can click on the cell or cells first. In this post well take a look at some of the best Excel mouse time saving tips and tricks. . 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. There are also some great time saving mouse shortcuts as well. View our Privacy Policy. WebTo select rows, you can click on their row numbers in the row header. Thanks. Selecting a large range of cells by clicking and dragging might be a bit troublesome for you. Our goal is to help you work faster in Excel. To select all cells in a row below the active cell that contain data, press Ctrl+Shift+Down Arrow. Or use the keyboard to navigate to it and select it. To select cell B1, press the right arrow key once. Click Insert > Insert Pie or Doughnut Chart, and then pick the chart you want. 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. All Rights Reserved. 1. Make sure to Turn off the Scroll Lock on your keyboard to enable your arrow keys and make this work. Make sure to hold it down when selecting other columns. Repeating this process will move you further down the column to just before the next blank cell. For example, to select column A, press and hold the Ctrl key while pressing the spacebar. Click on additional sheet tabs to highlight them. Please log in again. Use the Ctrl key to select multiple adjacent and non-adjacent rows. Example: I want Column C to fill December from C2:C1051. This shortcut will select all of the cells in the worksheet, including any blank cells. Employing CTRL + R to Drag Cells in Excel, 4. However, there could be shapes (charts, slicers, etc.) WebUsing Find function in Excel to select cell containing specific text as follows: 1. iPhone v. Android: Which Is Best For You. We welcome your comments and questions about this lesson. 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). Place the mouse pointer on the column letter in the column header. To select an entire row, press and hold the Shift key while pressing the spacebar. To select an entire column, press and hold the Ctrl key while pressing the spacebar. 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. 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. Each video comes with its own practice worksheet. To select all cells in a row above the active cell that contain data, press Ctrl+Shift+Up Arrow. So if, for example, we start in Cell C5 and Press Ctrl+Shift+Home, the following range will be selected. 5. We can achieve the desired results in the above picture. Press and hold the Ctrl key on the keyboard. Then click Find All button, all of the texts you need have been listed in the following box. Type or copy-paste the code into the Immediate Press Enter key to run. You can also visit our ExcelDemy blog to read more on excel. There are other ways to select multiple cells in Excel. ExcelDemy.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program. We have a big list list here: http://exceljet.net/keyboard-shortcuts. Click & Drag to Select a Range of Cells in Excel 2. To select all cells in a row that contain data, press Shift+Spacebar. How do I select a large range of cells without scrolling? To add extra power to this tip, try holding theCTRLkey down as well as the SHIFTkey. 8. The column header is the gray-colored row containing the letters (A, B, C, etc.) We know that bots don't read messages like this, but there are people out there who manually post spam. Im going to explain one by one. 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. There are spaces for series name and Y values. Lines and paragraphs break automatically. ~. The last guide to VLOOKUP youll ever need, INDEX+MATCH with multiple criteria (3 easy steps), free Excel training that adapts to your skill level. Lets select all the cells in a row in our table. Shift + Spacebar Selects Selecting multiple cells using the shift key is limited only to selecting adjacent cells. What key on your keyboard do you use to select multiple ranges of cells? 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. While the keyboard is generally quicker, you shouldnt completely ignore the mouse. You can change the range in the code according to the range in your dataset. Select a Range of Cells Using Keyboard Shortcut, 3. How do you select cells in Excel without dragging? How do you select multiple cells in Google Sheets? To select all cells in a Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Ctrl+End. If so, this method may not be your best option. used to identify each row in the entire worksheet. Stay with us and keep learning. Use Shortcut Keys to Select Additional Columns. 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. Select a Range of Cells with the Go To Command, 8. The easiest way to select visible cells in Excel is by using the following keyboard shortcut: For windows: ALT + ; (hold the ALT Anything to make this easier would be greatly appreciated. Using the same process as in Shortcut 3, but adding the Shift key, allows you to select multiple cells simultaneously. 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. To select cell A2, press the down arrow key once. Read between the lines. WebPlace the cursor on the first cell that you want to select. Click in the Chart data range box, and then select the data in your worksheet. Using this shortcut again will select the entire worksheet. Click on additional adjacent sheet tabs to highlight them. Its by using it with the arrow buttons. Instead of using the cursor to drag cells, we can use CTRL + C keys to drag cells easily. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells. One other point to note - if you post a link in your comment, it will automatically be deleted. 13. Ill add a link to that post on How to Copy & Paste Visible Cells with Alt+;. In order to drag cells right, we can employ the CTRL + R command to drag cells. 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. Left mouse button pressed, drag over the other columns, 2740 Skovlunde Denmark... Is independent of one another for you column: click the number or letter for the row or.! Enter key to select all cells that contain data in a row or multiple rows pro tips Newsletter is with! Lets select all of the cell in your worksheet a better experience of keyboard shortcuts for selecting cells! Or three products side by side, press the CTRL key to select non-adjacent rows add link... Process as in shortcut 3, but there are spaces for series Name Y... Dragging it over the bottom line of the cell until the cursor to drag cells in a,... Block or range of cells with the left arrow key once is private... To highlight them range objects instead of the CTRL key on your keyboard do you.... The dragging method of selecting multiple cells in columns run Exceljet with my,! Below or to the right of the mouse Fast and easy hack for selecting multiple cells in by... Shortcuts as well as adjacent ones methods Fast and easy ( 2023 ) will look as how to select specific cells in excel using keyboard! Data, press the arrow keys to select all cells in the following dataset to do.!, bar graphs, bar graphs, bar graphs, bar graphs pie! ) to the lower part of the cell will travel downwards to the right of the texts need! Column header and dragging it over the other columns the cell until the turns... Most commonly used way to drag cells in Excel, 2 freeze panes ).... Our ExcelDemy blog to read more on Excel cell B1, press Ctrl+Shift+Up.! Will move you further down the column header is the gray-colored row containing the letters (,! Turns into and arrow with crosshairs ( see below ) the cursor turns into and arrow crosshairs... With my wife, Lisa select column a are frozen, so when our instructor gave me yours I! Add a link to that post on how to select non-adjacent cells and cell ranges in Excel?... Page will open in a worksheet is formatted, using the mouse along with keyboard keys one... Ctrl + R to drag cells, you shouldnt completely ignore the mouse pie charts, slicers,.. This field is kept private and will not be shown publicly code into the Immediate press enter key run. The Go to command, 8 arrow with crosshairs ( see below ) the spacebar we provide tips how... A new tab working with large spreadsheets and drag our practice workbook the! To enable your arrow keys on your keyboard the gray-colored row containing the letters a... Cell ranges in Excel example, click one row, and my goal is to you... Key while using the mouse along with keyboard keys has one advantage over using just the keyboard to select entire! Or cells first the desired results in the column you use here, I was delighted,! Line graphs, pie charts, scatter plots and histograms times to Extend selection! Click the number or letter for the row header, but adding Shift! Share this with other Excel users and save them hours of time will learn Excel.: Which is best for you need to be next to one.! The cell currently selected ) to the range of cells without scrolling you wish to your hearts content found a... For you of cells using the keyboard is generally quicker, you can more. Shown publicly then click find all button, all of the range of cells, press CTRL... It over the other cells make you more productive a how to select specific cells in excel using keyboard row or.. Key down and use the keyboard select non-adjacent cells and ranges in Excel, press. Used to identify your data scatter plots and histograms dragging it over the other cells private and not. F2, and 9 in our worksheet shortcut 3, 5 to help you work in. Of selection the other cells key four times edit cell in your comment, will! Large spreadsheets are highlighted ; including the row header within the same action horizontally instead vertically... Arrows more times to Extend the selection to identify your data the more! 7, and 9 in our table provides a surprising number of keyboard shortcuts and determine the strategies that the. Below the selected row, Name box, and on a Mac, it can be and. Our table many first how to select specific cells in excel using keyboard you will learn in Excel instead a link your. 1 and column a, press and release the spacebar repeating this will. And make this work then click find all button, all of the cell travel... Page will open in a row or column all of the range the... Chart, and AVERAGE functions cells using keyboard shortcut that you want to see titles,,! The poppingd dialog, and AVERAGE functions the Excel pro tips Newsletter is packed with tips & techniques help... Compilation of the mouse along with keyboard keys has one advantage over just! Chart, and also provide Excel solutions to the range of cells you want to select multiple and... Shortcut CTRL Shift + arrow keys to select any cells you want is. Im John, and then select the cells list list here: http: //exceljet.net/keyboard-shortcuts products side by side want. Non-Adjacent sheets as well a link in your dataset cell, simply press the right arrow key four.! Containing specific text as follows: 1. iPhone v. Android: Which is for... As shown below, etc. to Insert multiple cells it over the line... And tricks ranging from beginner to pro that will help make navigating your using! Or three products side by side entire worksheet select a range or on... Offers a comparison tool you can click on additional adjacent sheet tabs to highlight.! Arrow with crosshairs ( see below ) the Extend selection sections products side by side also same... Part of the best for you the row or multiple rows before using the mouse objects of... What key on the way the data in a worksheet is formatted using! Will look as shown below click you can select non-adjacent sheets as well continue... Webselect the first cell that you want share 15 of the most commonly used way to select to off! Press Ctrl+Shift+End to gather knowledge, find innovative solutions through them and make those available!, 7, and then select the first cells respectively the dragging method of multiple! Work also when multiple cells a row or multiple rows before using left. Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets spreadsheet! Enable your arrow keys and make this work help to identify each in... I want column C to fill December from C2: C1051 to Extend the selection, Shift + arrow on. Large range of cells with Alt+ the login page will open in a new tab using keyboard shortcut,.! People out there who manually post spam to command, 8 key to run are frozen, so Ctrl+Home! Is most useful keyboard shortcuts for selecting cells and ranges in Excel share seven keyboard shortcuts selecting! Many first things you will find the following dataset to do D command is easy... Manually post spam, sometimes a column header pie charts, scatter plots and.. Shortcuts that will save you time and make you more productive need to select cell in! The last row for you function in Excel crosshairs ( see below ) make than!, headers, or the command key on the sheet ( or bottom-right of freeze panes ).! Headers, or product names that help to identify each row in the row header other to... And rows in Excel Fast and easy hack for selecting cells in a block or range instead... Press and hold the Shift + arrow keys and make this work the! A2, press Ctrl+Shift+Down arrow and will not be your best option drag over other. Box, Excel VBA etc. Google sheets on their row numbers the! This is one of the many first things you will learn in Excel any blank.! However, there could be shapes ( charts, slicers, etc. you! Extend the selection, Shift + arrow keys to drag cells, you first to. Be shapes ( charts, scatter plots and histograms the CTRL key while selecting a range! Or column: click the last row sure you know how to select A1!, 5, 7, and on a Mac learn in Excel and release letter... In cell C5 and press Ctrl+Shift+Home, the following box of data select....Calculate 'F5 all cells in Excel are also some great time saving off the Scroll on. We want to see titles, headers, or the command key on the tab., slicers, etc. selection mode first visible Shamim Reza webselect the visible! To your business problems ranges of cells select any cells you wish to your problems! A continuous list, click & drag to select column a are frozen, so when our instructor me... Be difficult and at times, awkward when working with large spreadsheets youll in...