Figuring Out Tricks

August 7, 2017

Software

Comments Off on Figuring Out Tricks


The Most Useful Excel Tips

When one is dealing with tons of big data, the important role that is played by excel in everyday work cannot be ignored. Tips are there that can help a lot for both the advanced users of Excel and the beginners There are spreadsheets secrets that can help a lot in everyday work. In a spreadsheet selecting all the data is the first and most simple one. Most people know how to select all using the control key +A shortcut, however, by clicking the corner button on top of the page one can select all the data. One, on the other hand can open files in bulk instead of opening them one by one. That when one has multiple files they need to work on this ensures that they can open them simultaneously. One can do this by selecting all Navigatinghe files that they need to open and then pressing Enter.

When one has already opened the different files navigating through them can be tiresome and one can easily work on the wrong spreadsheet ruining the whole project. Once one has different files open they can shift between them freely by just using Ctrl+ Tab. The shortcuts that are most common in the top menu of a spreadsheet are undo typing, repeat typing and save. By using the File then Options then Quick Access toolbar route one can however add others. After selecting a shortcut such as cut copy and saving one can notice shortcuts adding at the top menu. To a cell one can also add a diagonal line. Usually, borders can change different borders of a cell and when clicks more borders they can even add a diagonal line. Also, one can easily navigate the spreadsheets in different directions with only a click on the Ctrl + any arrow key.

Without having to add rows or columns one by one can actually add multiple rows or columns. This can be made possible by dragging the selected number of rows and columns then highlighting them and lastly choose insert from the drop down menu and new rows or columns will be added. One can copy and move data in a cell easily this is by choosing the pointer to the borders until it turns into a crossed arrow icon and then one can freely move it. Before they drag the data to move it, to copy one is needed to click the Control button and a new column will copy all the selected data. The tricks in Excel are many and all that one needs is to be acquainted with the spreadsheets well.