HomeОбразованиеRelated VideosMore From: Subjectmoney

Excel 2013 Tutorial For Noobs Part 23: How to Select a Range of Cells & Cells in Multiple Worksheets

89 ratings | 32644 views
http://www.excelfornoobs.com In this Microsoft Excel tutorial for beginners I show you how to select an entire column, an entire row and how to select a range of cells in a single sheet or how to edit cells in multiple worksheets at the same time. This Excel tutorial works for Microsoft Excel 2007, Excel 2010 and Excel 2013. There are multiple ways to select cells, a range of cells or multiple ranges of cells in Excel. Sometimes you might even need to know how to select multiple noncontiguous ranges in multiple worksheets to make one single change. This would be much more efficient than making the same change cell by cell. If you are this far along then I assume you are already familiar with how to select cells so I will only cover additional cell selecting techniques that you might have not discovered yet. Selecting Entire Rows and Columns To select an entire row or column simply click on the row number or column letter. Now any commands you click on will affect every cell within the selected column. To select multiple adjacent rows or columns click on the row number or column letter and while holding the left-click button drag your mouse over the range of columns or rows you want to select. Now any command you click will affect all cells in the ranges or columns you have selected. To select multiple rows or column that are not adjacent to each other click on a row number or column letter, hold down CTRL and select all the other rows or columns you want to include in the selection. To select and entire row or columns click on a row number or column letter and press CTRL + SHIFT + SPACEBAR. Now all commands will affect the entire sheet. Select Multiple Ranges of Cell Simultaneously There may be times that you want to select multiple ranges of cells that are not connected. Select a range of cells, press and hold CTRL and then select the other range of cells you want to be select. You can do this for as many cell ranges as you need. Another way to perform this action is to select a cell, press and hold SHIFT and then click on the opposite corner of the range of cells. Then press and hold CTRL and click the first cell in the next range of cells you are going to select. Now press and hold SHIFT and select the cell in the opposite corner of the range. You can also select a range of cells by manually entering it using the Find and Select command. In the Home tab under the Editing group click Find & Select and from the drop-down menu click on Go To.... The Go To dialog box will appear. In the Reference box enter the range of cells you want to select and click OK. If cell A1 was going to be the top left cell in the range and cell F20 was going to be the bottom right cell in the range then you would enter A1:F20 in the reference box and press OK. How to Select Cells and Ranges in Multiple Worksheets Simultaneously Suppose you have a workbook that contains identically formatted tables in separate worksheets. This could be the case if you had a workbook that contained quarterly sales reports, budgets, scenarios etc. You might want to make changes to the borders, fill colors or other types of cell formats. To select cell ranges among multiple sheets first activate all sheets by selecting all worksheet tabs while holding the CTRL button. Now select the range of cells in the worksheet that is showing. Any changes you make to the format of the cells will be made in the same range of cells in every worksheet that you selected. When you have multiple worksheets selected, Excel is in Group Mode. Your title bar should have [Group] next to the file name. If you want to select all worksheets in a workbook you can right-click and from the shortcut menu click Select All Sheets. NOTE: In group mode not all commands are available. For example if you click on the Insert tab you will see that almost every command on the ribbon is deactivated. Please be sure to rate, subscribe and share our videos. Please also visit our website at http://www.excelfornoobs.com. You can also add us on Facebook to keep updated. The links can be found on our Youtube channel. https://www.youtube.com/user/Subjectmoney https://www.youtube.com/watch?v=ILQ-rXjNGmU
Html code for embedding videos on your blog
Text Comments (10)
Lolo Qoqo (1 year ago)
Thank you sooooooooo much
Mahindu Francis (3 years ago)
is there a difference between highlighting and selecting in excel
brotard (3 years ago)
is there any way to select certain cells using formula? Let say I want to select A1, A3, A5, and so on...
chocoloco654 (4 years ago)
Thanks man, I'm too retarded for any of this crap..this helped.
Maggie Puddles (4 years ago)
thanks
n3rdherder (5 years ago)
Nice video! Awesome!
Subjectmoney (5 years ago)
If my free tutorials have helped you in any way please repay by liking, commenting, sharing and saving the videos to your favorites. Your interaction improves the search ranking of my tutorials which motivates me to keep making more. Thanks for the support!
Subjectmoney (5 years ago)
Click the upper left corner between the column letters and row numbers.
lol no 1 like or disliked i am just watching to see how do i select all with ctrl
Subjectmoney (5 years ago)
Hey guys please comment on this video. Any interactions such as commenting, rating, sharing and adding to your favorites increases our ranking on Youtube

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.