Keyboard shortcuts have contributed to optimizing the time of users and professionals since time immemorial. Control+C to copy, Control+V to paste, Control+F to search… However, there are other tricks that only a few know despite their great utility.
Excel is one of the most popular desktop applications in the world. Its spreadsheets allow a multitude of applications, from making an invoice to keeping a company’s accounting. Professionals who use this tool are used to handling large volumes of data, so knowing the ins and outs of the application makes their work much easier.
Forget about chopping letter by letter ever again
If you want to earn the Excel Power User award, you must first know how to apply the autofill function. This can be very useful for when in the documents you work with you have to fill several rows with information in series of names, addresses or any other pattern that Excel is able to recognize.
There is a shortcut that can save you hours in front of the computer chopping this information in a monotonous way. When faced with a series in which you must extract data about which there are references in a previous column, for example to cover the last names and initials of a previously written full name. Fill in the first row as an example, then type Control + E. Voilà! Excel will automatically fill in the gaps until the column is complete.
read also
How to import data from a photo
Another time-saving trick is to import a printed document into an Excel spreadsheet without having to manually enter the data.
1 To take advantage of this, first take a photo of the paper document and save it on your computer or mobile. 2 Then select the function Insert > Data from a photo 3 Excel will automatically extract the data and show you a preview. If the result is correct, click OK. 4 The data from the paper document will appear in the spreadsheet. There may be some minor bug that you need to fix, but this feature promises satisfactory results.
The Ultimate Shortcut to Doing Calculations
Who hasn’t gotten over the boring Excel formulas? Above all, if a slip when making a wrong cell has unbalanced the cells of the entire document. Luckily there is a way that this never happens to you again.
Once you have written all the values of your budget or your sales balance, select the cells with the data and those that will find the results. With the Alt = Excel command you will get the accounts automatically without having to spend time repeating the same formula over and over again
This article was published in La Vanguardia on March 20, 2023
