La spreadsheet has become an important tool and interesting for many. Gone is the famous account report made with the typewriter or with the Notepad and added with the Casio calculator.
That is old water that has been overtaken by Excel and its functions. But unfortunately not everyone controls or knows the full potential of this Microsoft program and the time savings that this can produce when working with this program.
In this case we have used Excel 2013 for reference. A version that many already have and that is also compatible with future versions, so the tricks can be used in Excel 2013 and later.
Insert the Date in the Cell.
In Excel 2013 we can insert the date in a quick way using the combination of the following keys: "CTRL +;". This key combination allows you to enter the date that the system has in a cell and it does so in a static way. A useful combination if we use the spreadsheet as a report or invoice.
Quickly navigate between books and sheets
The best way to optimize space and accounts in Excel is by the use of the different sheets and books that we can create. This is a problem if we want to move between them quickly, at least it is a problem if we compare it with having all the data within the same sheet.
A little trick to move between books is to use the "CTRL + TAB" keys and if we want to move between sheets we have to use the following combination: CTRL + PAGE DOWN, to advance the page and CTRL + PAGE RE to go back.
Hide cell data in Excel 2013
It is becoming more and more common make forms and tests that depending on what we write, certain cells are autocompleted or filled with other data. This is very useful but sometimes to do it we need to hide certain formulas or information.
At least so that the user does not modify it or simply for aesthetics. To get this, first we have to select the cell with the data that we want to hide. Then we click with the right button and we go to «Format Cells».
Choose the custom category and type ";;;" We save it and now neither an error symbol nor similar data will appear, it will only appear as if the cell had nothing.
Conclusion
There are more tricks in Excel 2013 to make us more effective. There may be hundreds or thousands of them, but in any case, these three are interesting, at least for those who work with Excel in a professional way. Do not you think?