Microsoft Excel is one of those programs that is far more versatile than many people believe. Certainly it allows you to enter and analyze data, but you also can use it for accounting, planning, tracking data, making calendars, creating a budget and much more. While many people know how to use the most basic features of Excel, here are a few cool tricks that you might not have known.
If you have entered many rows and columns of data but need to copy and paste it someplace else, such as another spreadsheet, most of us click, hold and drag to select all of the information. If you have a large amount of data, this can be time consuming. To skip that, just click inside the row and tap the shift key and the spacebar. This will highlight the whole row automatically, which you can then cut, copy or paste elsewhere.
When you need more that a single row or column highlighted and you need the whole spreadsheet, this is easy as well. Go up to the first cell and click. Now you hit the key at the top of your keyboard marked F8. Then you scroll down to the very last cell of data and click inside it. This will highlight your whole spreadsheet. If you just want to highlight one column, you begin by clicking the first cell in the column and then click the last cell in that column rather than clicking the first and last cells in the entire spreadsheet. To stop this particular function, simply tap that F8 key again.
Often when you are working on a spreadsheet and you start entering data farther down the sheet, you miss having the header visible. If you have many columns of data, it's difficult to remember what data goes into what cell, so having the header constantly visible would be helpful.
To make sure the header appears all the time, you need to look at the right edge of the spreadsheet. There is a small down arrow, then a little box with a dash in it, and then a filled-in up arrow. If you hover over the little box, your cursor will change to an up and down arrow with two horizontal lines. Click and hold and move the bar that appears down until it appears below the header row. This will appear as if you have two headers, but notice as you scroll down that the top header remains.
Microsoft Excel offers hundreds of short-cuts and functions, including the ability sort data or filter data. To sort, you can go up to the Sort & Filter function on the Home tab. This allows you to sort alphabetically, reverse alphabetically or to create your own custom sort. You also can place a filter in order to view just one set of data at a time. The best way to learn about all of the functions of Excel is to click on the question mark in the blue circle that is located on the top right corner of your Excel spreadsheet. From here, you will be linked to the Excel Help system. You can ask questions, learn keyboard shortcuts and more.
If you have entered many rows and columns of data but need to copy and paste it someplace else, such as another spreadsheet, most of us click, hold and drag to select all of the information. If you have a large amount of data, this can be time consuming. To skip that, just click inside the row and tap the shift key and the spacebar. This will highlight the whole row automatically, which you can then cut, copy or paste elsewhere.
When you need more that a single row or column highlighted and you need the whole spreadsheet, this is easy as well. Go up to the first cell and click. Now you hit the key at the top of your keyboard marked F8. Then you scroll down to the very last cell of data and click inside it. This will highlight your whole spreadsheet. If you just want to highlight one column, you begin by clicking the first cell in the column and then click the last cell in that column rather than clicking the first and last cells in the entire spreadsheet. To stop this particular function, simply tap that F8 key again.
Often when you are working on a spreadsheet and you start entering data farther down the sheet, you miss having the header visible. If you have many columns of data, it's difficult to remember what data goes into what cell, so having the header constantly visible would be helpful.
To make sure the header appears all the time, you need to look at the right edge of the spreadsheet. There is a small down arrow, then a little box with a dash in it, and then a filled-in up arrow. If you hover over the little box, your cursor will change to an up and down arrow with two horizontal lines. Click and hold and move the bar that appears down until it appears below the header row. This will appear as if you have two headers, but notice as you scroll down that the top header remains.
Microsoft Excel offers hundreds of short-cuts and functions, including the ability sort data or filter data. To sort, you can go up to the Sort & Filter function on the Home tab. This allows you to sort alphabetically, reverse alphabetically or to create your own custom sort. You also can place a filter in order to view just one set of data at a time. The best way to learn about all of the functions of Excel is to click on the question mark in the blue circle that is located on the top right corner of your Excel spreadsheet. From here, you will be linked to the Excel Help system. You can ask questions, learn keyboard shortcuts and more.
About the Author:
Frankline Bell loves blogging reviews on computer repairs and support companies. To get further details about the best computer repair Beaverton professionals or to discover more about Portland computer repair services, please visit the GeeksAKnockin.com site now.
0 komentar:
Posting Komentar
silahkan tinggalkan komentar anda sangat bermanfaat dalam memotivasi pembelajaran kami.