Five Advanced Excel Tips And Tricks For Windows Users
Monday 17 July 2017

Five Advanced Excel Tips And Tricks For Windows Users

If you use Microsoft Excel as your default worksheet application, we are sure that you already know some useful tips to work faster. But there are more tips and tricks that you may not know yet.

In this article, we are going to share with you five lesser known Microsoft Excel tips that will assist you in doing your works in an easy way. For instance, sometimes you will need to create a customize list, format your table, or even print multiple worksheets on a single page. These advanced tips will help you to do your tasks in those such situations.

1. Use Watch Window To Monitor Data

Watch Window is a great feature in Microsoft Excel, which helps you monitor data changes on your worksheet.

For example, when you work on a large spreadsheet, it's not simple to recognize how a change in a cell value makes an impact on other subordinate cells. Of course! It will waste a lot of time if you try to scroll your worksheet up and down to view those changes.

Fortunately, Watch Window can help you to monitor any changes of specific Microsoft Excel cells in real time. To enable this feature, you can go to Formulas tab and choose the "Watch Window" option. Subsequently, click on the "Add Watch" option and then select the cell you want to track and click on the "Add" button.

From now on, when you make a change on your data, Watch Window will show the updated value immediately. Even better, you can watch cells on other spreadsheets.

2. Round Off The Value To Thousand Or Million

Displaying long numbers in your spreadsheet doesn't beautiful, and you don't like it? Then you should format those numbers and show them in a shorter way.

That said, instead of displaying long numbers, you can present all the values are thousands as "K" or all the values are millions as "M". For example, instead of showing 25,000 in a cell, you can format and display it as 25K. Similarly, you can display 25M in your worksheet instead of 25,000,000.

Even better, it can round off the value to display in a shorter way. For instance, if you have a cell that has value is 22,796.37, after formatting, it will show 23K. That is how does it work. One thing you also should know that it doesn't change the value of the cell. It just changes how does the value looks in that cell. The real value of the cell remains the same. Therefore, you can use this trick without worrying about any issues.

To use it, you need to choose the range of cells you want to format. Then right-click on them and choose the "Format Cells" option

In the next step, click on the "custom" option and fill in: ###,”k” or ###, “m” for rounding off to thousands or millions, respectively. Subsequently, click on the "OK" button to execute the change. Similarly, you can use this method to format the value of the chart as well. This round off method is one of the handiest online Excel tips that we should use to format values of large worksheets.

3. Print Multiple WorkSheets On A Single Page

Do you ever want to print two or more sheets in a single page? Well! You can do this task without installing any Excel add-on.

To get started, access Quick Access Toolbar -> More Commands.

In the "Choose commands from" list, select "All Commands".

After that, find the "Camera" command and add it to the right list. By doing so, you will add the "Camera" to the Quick Access Toolbar.

To print multiple spreadsheets, you need to combine them into a single spreadsheet and then print. With the help of the "Camera" command, you can select the area that you want to print and then click on the "Camera" icon in Quick Access Toolbar.

In the next step, open a new worksheet and paste it there. Next, choose the second area and do the same like above. By that, you can combine all sheets together and ready to print. One thing that good is that when you change a value on your worksheet, then the value in the snapshot will also change

4. Add Table Style To Selected Excel Data

To apply the table style to your selected Excel data, you can choose the "Format as Table" option under the "Home" tab. There are many predefined styles you can choose from, or you can create a new custom style, depending on your need. Besides, you can apply styles to separate cells or the range of cells as you want.

5. Create A Custom List In Excel

If you don't want to type in the same structure of the value on your worksheet, then creating a custom list would be a good choice. Instead of entering a few repeated values, you can select it from a drop-down list.

To use this, the first step you need to do is to select the area you want to use this list. Then go to Data Validation -> Data Validation under the "Data" tab.

From the "Allow" drop-down list, choose the "List" option. In the "Source" field, choose the range of source data you want to include in this list, and then click the "OK" button.

After that, you can click on any cells in the range you selected in the first step and choose the value you want to fill in from the list of values.

These advanced Excel tips will help you to complete your tasks quicker and more efficient. Have you ever used any of these tips?