iklan ads
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.
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.
If you need to highlight all the data on an entire spreadsheet, such as if you wish to copy or cut all the data and move it someplace else, there is a much easier way to do this than dragging your mouse across all the cells of data. You just click in the first cell and then hit F8. From there, you just click on the last cell of the spreadsheet, and all of the cells will be highlighted. You can do this for just one column or the whole spreadsheet. When you want this function to cease, just hit F8 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.
You can create a second header that will appear all of the time. Go over to the right edge and find the scroll bar for the spreadsheet. Above that is an up arrow or triangle that is filled in, and above that is a box with a line in it. Place your cursor over this box and wait until the cursor looks like two up and down arrows with two lines in between arrows. Click and hold and a dark line will appear. Move this arrow down slightly and slowly and you will see a second header appear. Release the mouse and this header will stay in place and you will be able to see it the whole time you enter data, even after row 38.
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.
If you need to highlight all the data on an entire spreadsheet, such as if you wish to copy or cut all the data and move it someplace else, there is a much easier way to do this than dragging your mouse across all the cells of data. You just click in the first cell and then hit F8. From there, you just click on the last cell of the spreadsheet, and all of the cells will be highlighted. You can do this for just one column or the whole spreadsheet. When you want this function to cease, just hit F8 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.
You can create a second header that will appear all of the time. Go over to the right edge and find the scroll bar for the spreadsheet. Above that is an up arrow or triangle that is filled in, and above that is a box with a line in it. Place your cursor over this box and wait until the cursor looks like two up and down arrows with two lines in between arrows. Click and hold and a dark line will appear. Move this arrow down slightly and slowly and you will see a second header appear. Release the mouse and this header will stay in place and you will be able to see it the whole time you enter data, even after row 38.
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 blogging 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 site today.
iklan ads