If you need to collect, store and analyze data, then Microsoft Excel is an obvious choice, but this versatile piece of software can do much more than just store basic data. You can create calendars in Excel, make mailing labels, compare data, record inventory, complete accounting tasks, create forms and quite a bit more. Excel also offer dozens of helpful tricks and shortcuts for users.
Highlighting data is something we often have to do, especially if you need to cut and paste or copy and paste the data. To highlight quickly, tap into the first cell of a row and just hit your shift and spacebar. The whole row will highlight and you can copy or cut the data.
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.
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.
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.
Highlighting data is something we often have to do, especially if you need to cut and paste or copy and paste the data. To highlight quickly, tap into the first cell of a row and just hit your shift and spacebar. The whole row will highlight and you can copy or cut the data.
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.
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.
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. To get further details about the best computer repair Beaverton professionals or to find out more about Portland computer repair services, please visit the GeeksAKnockin.com site today.
0 التعليقات:
إرسال تعليق