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.
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.
You might have noticed that once you move beyond row 38 in excel, that you can no longer see the first row of data. As this is your header, it can be difficult to continue entering data when you can't see for what each column has been designated. Keeping a header in place is a helpful tool for those using Excel.
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.
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.
You might have noticed that once you move beyond row 38 in excel, that you can no longer see the first row of data. As this is your header, it can be difficult to continue entering data when you can't see for what each column has been designated. Keeping a header in place is a helpful tool for those using Excel.
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. To get further details about the best computer repair Beaverton professionals or to find out more about Portland computer repair services, please check out the GeeksAKnockin.com website today.
Không có nhận xét nào:
Đăng nhận xét