Home   Articles   Microsoft Office   Become A Microsoft Excel Pro With These Tips

Become A Microsoft Excel Pro With These Tips

  • Scoop.it

Microsoft Excel has advanced a lot these days and there are numerous features in it that help in enhancing the proficiency and capability to work effectively. Here are a few tips that every user must check out to become a Microsoft Excel professional.

Excel shortkeys and tips

Using tables to format data swiftly

Tables in Microsoft Excel are amazing and can handle plenty of data immaculately. Simply select any cell having data in it and press Ctrl + T followed by the Enter key.

Using Cell Styles

For formatting, consistency is highly preferred. Cell styles can be used to ensure that the formatting of every kind of the similar information available in the workbook would be formatted in the same way.

Using Format Painter

One of the most beautiful tools in every Microsoft Office program is format painter. With the help of this tool formatting can be copied from one area to another.

Using Ctrl+Shift to Select

That traditional style for selecting a datasheet using mouse dragging has now been replaced with Ctrl + Shift. This is a much faster way in contrast to the other one. Simply click on the first cell and hold down Ctrl + Shift following by hitting the up, down, left or right arrow key.

Auto Fill

This is one of the useful features available in Microsoft Excel. It is really helpful especially when you are writing something in series. Once you begin with the series, simply move the cursor to the lower right part of the cell. When the cursor turns into a plus (+) sign, click and drag up, down, left or right to select the cells required to be filled in.

Advertisement

Keyboard Shortcuts for Formatting

Plenty of shortcuts are available that increases the productivity and here are a few of them:

  • Ctrl + 1: It opens the format dialog whether you have selected drawing shapes, charts, cells or anything else
  • Alt + Enter: This helps to add a new line while editing the cell
  • Ctrl + T: With this, table formatting is applied to the cells
  • F4: Last action is repeated with this.

So, if you are also willing to become a Microsoft Excel professional, try out the aforementioned features and tools.

Advertisement

Related Articles

Leave a Reply

We're glad you have chosen to leave a comment. Please keep in mind that all comments are moderated according to our comment policy. Do NOT use keywords in the name field. Let's have a personal and meaningful conversation. If you have questions regarding how to download the templates, please visit this link.