Microsoft Excel is possibly one of the most useful applications out there. If you want to get more out of the application, it is important that you learn how to make a chart in Excel and Excel shortcuts. This post takes a close look at the different Excel shortcuts that you can use to make your life a whole lot easier. So, what are you waiting for? Let’s dive in.
- Current Date
A useful Excel shortcut that you need to try out is inserting the current date. To use the shortcut, you just need to press “CTRL + ;”. If you do not want to look at the right hand corner of the screen to add the current date, you can simply use this Excel shortcut. It will get things done immediately.
- New Text Line in the Same Cell
Another Excel shortcut that you can use is to add a new text line in the same cell. To use this shortcut, you need to press “Alt + Enter”. It is the perfect shortcut for times when you are typing and want to keep on going in the same cell. This shortcut will let you create a new line within the same cell. It is super useful.
- Select Full Columns and Rows in One Go
If you want to select full columns and rows within one go, you only need to press “Shift + Spacebar” or “Ctrl + Spacebar”. These powerful Excel commands let you choose an entire column or row in its entirety. The entire column would get selected.
- Add Multiple Columns and Rows
In addition to the above shortcuts, you can also add multiple columns and rows by right clicking and selecting “Insert”. Now, you will be able to insert columns and rows for adding more data with minimal effort.
- Resize Columns
Inserting large amounts of data is not an easy task. It takes a great deal of patience. Besides, it can be difficult not being able to see the input in total since the column sizes would be too small to offer a full display. However, there is no need to worry as you do not need to resize each and every cell individually. You can simply select all of the columns that you want to resize and move the mouse to click on the right corner and double click it.
- Add a Comment
To add a comment in a cell, you can simply hold “Shift + F2”. It should do the trick. A comment box will instantly pop up for you to leave a comment.
- Make Changes in Multiple Worksheets
There are times when you need to make changes to multiple worksheets. Rather than having to copy and paste all the changes, you can create a group by pressing Ctrl when clicking on one tab and clicking on all the remaining tabs.
- Select Everything
Finally, you can select everything by holding “Ctrl + A”.
Once you have finished reading this post, you will be able to get more out of Microsoft Excel.