Excel life hacks for your homeworkEducational ResearchUpdated on Jun 24, 2017 View more like this | Visit Ukraine, UN | Contact RayTrey |
Here are some simple ways to significantly improve the use of this necessary program. Releasing Excel
2010 , the Microsoft has added a myriad of new features , but they are visible not immediately. "Just So!" I
invite you to try the techniques that are guaranteed to help you in your work.
These tricks will make it easier to work with Excel. Everything is now so simple!
Now you can select all the cells in one click. You just have to find the magic button in the corner of an
Excel sheet. And, of course, do not forget about the traditional method - the key combination Ctrl + A.
How to select all cells in one click
To open multiple files, you need to select the desired files and press Enter. Time savings are obvious.
Simultaneously open multiple files
Between open a workbook in Excel can be easily navigated using the keyboard shortcut Ctrl + Tab.
Quick Access Toolbar contains three standard buttons, you can easily change the number to the right is
you. Simply go to "File" ⇒ "Settings" ⇒ "Quick Access Toolbar" and choose any key.
How to change the Quick Access Toolbar in Excel
If you need to add a diagonal line in the table for a special division, just click on the home page for Excel
usual icon borders and choose the "other boundaries".
How to add a diagonal line in the table
When there is a situation where you have to insert a few empty rows, do this: Mark the desired number
of rows or columns, and click "Paste". Then simply choose the location where you want to move the cells, and
you're done.
If you need to move any information (cell, row, column) into Excel, select it and hover your mouse over
the border. After this move information wherever required. If you want to copy the information, do the same
operation, but with pressed key Ctrl.
How to move the data in Excel
Now remove the empty cells, so often interfere with work, it is incredibly easy. You can get rid of all at
once, simply select the column and click on the tab "Data" and then click "Filter". Above each column will be a
downward pointing arrow. By clicking on it, you will go to get rid of the menu empty fields.
How to remove all empty cells
Search for something which has become more convenient. Pressing the keyboard shortcut Ctrl + F, you
can find all the necessary data in your table. In addition, if we learn to use the symbols "?" And "*", you can
greatly expand the search capabilities. The question mark - one unknown character and the asterisk - several.
If you do not know exactly how to enter a request, this method will definitely help. If you need to find a
question mark or asterisk, and you do not want to replace them sought Excel unknown character, then put "~"
in front of them.
Onetime information is easily distinguished by a unique entries. To do this, select the column and click
the "Advanced" on the left of the "Filter" item. Now tick to select an input range (from copy) as well as the
range in which you want to place the result.
About the Author: Dan Blor is a student. He is interested in new technologies and writes about that at essaycapital.com
2010 , the Microsoft has added a myriad of new features , but they are visible not immediately. "Just So!" I
invite you to try the techniques that are guaranteed to help you in your work.
These tricks will make it easier to work with Excel. Everything is now so simple!
Now you can select all the cells in one click. You just have to find the magic button in the corner of an
Excel sheet. And, of course, do not forget about the traditional method - the key combination Ctrl + A.
How to select all cells in one click
To open multiple files, you need to select the desired files and press Enter. Time savings are obvious.
Simultaneously open multiple files
Between open a workbook in Excel can be easily navigated using the keyboard shortcut Ctrl + Tab.
Quick Access Toolbar contains three standard buttons, you can easily change the number to the right is
you. Simply go to "File" ⇒ "Settings" ⇒ "Quick Access Toolbar" and choose any key.
How to change the Quick Access Toolbar in Excel
If you need to add a diagonal line in the table for a special division, just click on the home page for Excel
usual icon borders and choose the "other boundaries".
How to add a diagonal line in the table
When there is a situation where you have to insert a few empty rows, do this: Mark the desired number
of rows or columns, and click "Paste". Then simply choose the location where you want to move the cells, and
you're done.
If you need to move any information (cell, row, column) into Excel, select it and hover your mouse over
the border. After this move information wherever required. If you want to copy the information, do the same
operation, but with pressed key Ctrl.
How to move the data in Excel
Now remove the empty cells, so often interfere with work, it is incredibly easy. You can get rid of all at
once, simply select the column and click on the tab "Data" and then click "Filter". Above each column will be a
downward pointing arrow. By clicking on it, you will go to get rid of the menu empty fields.
How to remove all empty cells
Search for something which has become more convenient. Pressing the keyboard shortcut Ctrl + F, you
can find all the necessary data in your table. In addition, if we learn to use the symbols "?" And "*", you can
greatly expand the search capabilities. The question mark - one unknown character and the asterisk - several.
If you do not know exactly how to enter a request, this method will definitely help. If you need to find a
question mark or asterisk, and you do not want to replace them sought Excel unknown character, then put "~"
in front of them.
Onetime information is easily distinguished by a unique entries. To do this, select the column and click
the "Advanced" on the left of the "Filter" item. Now tick to select an input range (from copy) as well as the
range in which you want to place the result.
About the Author: Dan Blor is a student. He is interested in new technologies and writes about that at essaycapital.com
