Facebook

header ads

8 MS Excel shortcuts that will save your time and make you expert.

8 MS Excel shortcuts that will save your time and make you expert.



If you have ever used a computer, you have definitely dealt with Microsoft Excel, as this important program is practically ubiquitous, as it appears on corporate computers regularly thanks to its presence in the list of Microsoft programs Office" (Microsoft Office). Excel has become synonymous with spreadsheets as a whole - just as the Kleenex has become the front of the incest industry - and virtually a pioneer in this field, almost everyone has spent some time working with Excel. Familiarity with working on excel is almost a necessity of work, and why not! It is a powerful tool that can help
you organize data in a simple way.

But just because the program is popular does not mean that you can use it proficiently as following the tips and tricks related to browsing the program is highly desirable, when it comes to Excel there is always more to learn.

Getting the most out of Excel:

Excel today is honestly one of the most popular software in the market, but its capabilities are still not fully understood by many experts. What you should know is where these features and functions are available.

Many people dedicate a great deal of their time to learning Excel in the hope that they can tame this magical "horse" and make it fulfill their desires, which is no easy task.

Failure to follow seemingly rules can lead to immediate disaster, with simple data turning ugly and hard to handle, with features like complex formulas, pivot tables, macros, and merging Mail merges in Word and conditional formatting are easy to get lost in this sea of lists of options.

And if you are like me, any tips that can help you get the most out of Excel are golden tips that you can not get enough of, no matter how many, so when I got to know this information I knew that I must show it to you.

These tips describe how to do just a few clicks to get the tasks you do every day using Excel, and include a variety of keyboard shortcuts that are guaranteed to save you precious minutes of time spent working on the program. All of these operations are so simple that even those just starting out with Excel can quickly master them.

Based on that, here are the eight shortcuts that are sure to help you work more efficiently on Excel:


1- Choose several things with one click:

This handy trick, which is equivalent to (Ctrl + A) in Word, will enable you to select the entire spreadsheet with just one click, which will immediately save you valuable time. You can also press Ctrl+A once, as in Word, to select the current table, or twice to select the entire sheet.


2- Resize the entire column with just two clicks:

Have you ever spent hours entering data only to realize that you can't see half the information because the columns are too small? Instead of clicking and dragging each column with the mouse, select the columns you want to resize, place the cursor to the right of them, and double-click.


3- Enter the current date:

Instead of looking at the bottom right corner of your computer screen to type the date into the cell just press (Ctrl + ;). If you want to always display the current date in a cell, type =()Today . in it.


4- Insert comments quickly and easily

After you've finally completed your schedule, you notice something that may or may not be right. Instead of freaking out and ending up in a bench full of notes reminding you to re-review cell (D9), press (Shift+F2) to insert a comment.


5. Make the same change to a variety of tables:

Instead of copying and pasting something to add to the file at the last minute, collect all the sheets you want to make changes to by clicking on one of the windows, then pressing (Ctrl), and clicking on all the other windows. After making the change to the current sheet, the change will be applied to all sheets, and if you want to change all sheets, right-click on the current sheet and choose (Choose all sheets).


6- Starting a new line in a specific cell:

You may have discovered that pressing Enter in a cell will not take you to a new line and will simply take you to the next cell in the table. But pressing (Alt + Enter) while typing in the cell will move the cursor down so that you can type a second line.


7- Add a variety of lines or columns at the same time:

Sometimes you may need to add as many as 100 columns or lines, and while doing this individually is painstaking and time consuming, there is a much easier way. In order to add a variety of lines or columns in the table, select the same number of lines or columns that you want to add, and then right-click and choose Insert.


8- Choose entire lines or columns:

Save time when selecting an entire column or an entire line by using these shortcut commands: (Ctrl+Space) to select the entire column (Shift+Space) to select the entire line. These two shortcuts will spare you the process of selecting and dragging across the table.

Stressing out over streams isn't a source of entertainment for anyone. Also, learning how to do these simple shortcuts and tricks will not only make you look like an Excel pro, but it will also reduce the amount of extra time you currently spend working on the program.


Post a Comment

0 Comments