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.
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!
Our team is ready to discuss how Ripple can integrate with your existing payments systems.
In a world where three billion people are connected online, cars drive themselves and appliances can communicate, global payments are still stuck in the disco era.
Ripple connects banks, payment providers, digital asset exchanges and corporates via RippleNet to provide one frictionless experience to send money globally.
Connectivity across payments networks.
Instant, on-demand settlement.
Real-time traceability of funds.
Low operational and liquidity costs.
Better Than Any Blockchain.
Built on the most advanced blockchain technology that is scalable, secure and interoperates different networks.
Growing Global Network.
Banks, payment providers and digital asset exchanges process and provide liquidity for payments on RippleNet, creating new, competitive cross-border payments services for their customers.
How to buy Ripple.
The payment is easily completed online in minutes by POLi Payments a business from Australia Post and after payment is complete the coins will be sent to your CoinSpot online wallet immediately.
Ripple is a technology that acts as both a cryptocurrency and a digital payment network for financial transactions.
Ripple was released in 2012 and co-founded by Chris Larsen and Jed McCaleb.
The coin for the cryptocurrency is premined and labeled XRP.