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.
Sometimes when you have a spreadsheet filled with data, you need to move an entire row into another space. To select the entire row quickly, simply click in the row and then hit shift and the spacebar. This will highlight the row, and then you can cut the row entirely or paste it elsewhere on that spreadsheet or another spreadsheet.
For those times when you need to highlight a whole column, just click in the first cell and then find the F8 key at the top of your keyboard. Then click that F8 and then click last cell in your column. You also can use this process to highlight every cell in a spreadsheet. Just click in that very first cell and then in the very last cell and everything will highlight. To end this function, just tap on that F8 again and the function will stop. You also can use this to just highlight a chunk of data within your spreadsheet.
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.
When you are analyzing data or just need to look at data of a specific criterion, then the ability to sort and filter can be handy. Microsoft excel has a function just for this purpose located along with many other features on the Home tab. This provides you with the ability to sort items alphabetically, to create a custom sort or to filter for specific terms or information. To learn more about Microsoft Excel, there is a help function built into the program located near the top right part of the program. It is a question mark located in a blue circle. This allows you to browse for answers to questions, learn shortcuts and other helpful hints.
Sometimes when you have a spreadsheet filled with data, you need to move an entire row into another space. To select the entire row quickly, simply click in the row and then hit shift and the spacebar. This will highlight the row, and then you can cut the row entirely or paste it elsewhere on that spreadsheet or another spreadsheet.
For those times when you need to highlight a whole column, just click in the first cell and then find the F8 key at the top of your keyboard. Then click that F8 and then click last cell in your column. You also can use this process to highlight every cell in a spreadsheet. Just click in that very first cell and then in the very last cell and everything will highlight. To end this function, just tap on that F8 again and the function will stop. You also can use this to just highlight a chunk of data within your spreadsheet.
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.
When you are analyzing data or just need to look at data of a specific criterion, then the ability to sort and filter can be handy. Microsoft excel has a function just for this purpose located along with many other features on the Home tab. This provides you with the ability to sort items alphabetically, to create a custom sort or to filter for specific terms or information. To learn more about Microsoft Excel, there is a help function built into the program located near the top right part of the program. It is a question mark located in a blue circle. This allows you to browse for answers to questions, learn shortcuts and other helpful hints.
About the Author:
Frankline Bell enjoys blogging reviews on computer repairs and support companies. For further details about the best computer repair Beaverton professionals or to discover more about Portland computer repair services, please check out the GeeksAKnockin.com site now.
No comments:
Post a Comment