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.
One annoyance is that when you add a great deal of data and you start to move below about the 38th row, you lose the visibility of your header. That might be fine if you just have two or three columns of data, but if you are entering data into a large amount of columns, it is sometimes tough to remember which column is which. For this reason, it is nice to have the header visible all of the time.
Fortunately, you can address the problem quickly. First look at the top right area of your spreadsheet, over by where the scroll bar is located. Above that you will notice two arrows, one is thin and points down and the other is full and points up. However your cursor between these two arrows on the little box in between. Your cursor will transform from a plus sign or arrow into an up and down arrows with two lines in the middle of them. Click and then gently drag down until you see a duplicate header appear and then stop dragging. The very top header will remain visible no matter how far down you scroll on your main spreadsheet page.
If you need to organize data a certain way, you can use the handy sort function. At the top of the page, you will notice a variety of tabs - Home, Insert, Page Layout, etc. Under Home, you will find Sort & Filter. You can create your own custom sorts or just go with alphabetical sorts. You can also filter columns to show just certain data which can be very helpful. This is just the tip of the iceberg as there are literally hundreds of shortcuts and functions available in Excel. For more help and hints, click on the question mark at the top of the Excel page. It is surrounded by a blue arrow and links to the Microsoft Excel help system.
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.
One annoyance is that when you add a great deal of data and you start to move below about the 38th row, you lose the visibility of your header. That might be fine if you just have two or three columns of data, but if you are entering data into a large amount of columns, it is sometimes tough to remember which column is which. For this reason, it is nice to have the header visible all of the time.
Fortunately, you can address the problem quickly. First look at the top right area of your spreadsheet, over by where the scroll bar is located. Above that you will notice two arrows, one is thin and points down and the other is full and points up. However your cursor between these two arrows on the little box in between. Your cursor will transform from a plus sign or arrow into an up and down arrows with two lines in the middle of them. Click and then gently drag down until you see a duplicate header appear and then stop dragging. The very top header will remain visible no matter how far down you scroll on your main spreadsheet page.
If you need to organize data a certain way, you can use the handy sort function. At the top of the page, you will notice a variety of tabs - Home, Insert, Page Layout, etc. Under Home, you will find Sort & Filter. You can create your own custom sorts or just go with alphabetical sorts. You can also filter columns to show just certain data which can be very helpful. This is just the tip of the iceberg as there are literally hundreds of shortcuts and functions available in Excel. For more help and hints, click on the question mark at the top of the Excel page. It is surrounded by a blue arrow and links to the Microsoft Excel help system.
About the Author:
Frankline Bell enjoys writing reviews on computer repairs and support companies. For further information about the best computer repair Beaverton professionals or to find out more about Portland computer repair services, please visit the GeeksAKnockin.com website now.
No comments:
Post a Comment