Calculate Quickly in Chrome using Omnibox

As you know that Google will calculate basic math in the search bar. But, did you know that you can access a similar math in your omnibox.

Steps:

• Open Chrome
• Just type in a basic math problem in the Chrome search/address bar
• The correct answer will appear in the suggestions below the omnibox without pressing Enter key

This will work if your default omnibox search is Google. You won’t get an answer if your default is any other. No matter what is your default browser.

Remember: It doesn’t appear to work if you are typing into an incognito window.

Let us know what we have missed in the comments.

Delete Blank Rows Easily

Blank rows/column or blank cells in data sheets make your life painful. Here some easy way to delete blank rows/column/cells  in MS Excel.

Steps:

• Open the excel sheet where you wish to delete the empty cells
• After that select your data range
• Navigate to Home > Find & Select > Go To Special
• One Go To Special window will appear.
• Here click on Blanks radio button and click Ok
• Automatically all the blank cells will select
• Now just delete them navigating Home > Delete > Delete Sheet Rows/column/cells
• Remember, don’t click anywhere on the sheet otherwise selection will vanish
• Now all the blank rows/column/cells will be delete

Let us know what we have missed in the comments.

Sum Cells based on Background/Fill Color

As we all know that MS Excel has no formula or feature to calculate such a thing to calculate cells on their background color. Here, explained one methods that will help you to achieve this.

To make the task more clear let’s make a sheet as per below image.

Here we don’t need the total sum of all elements but we need the sum of elements that have the same background color.

Steps: This steps is much faster and better.

For this task we can use a small UDF (User Defined Function) which will fo the trick for us. This function does not return the color name but it returns the color index which is also a unique value and can be used in our task.

• Open Worksheet
• Fill as per above background color or whatever you want
• Press Alt + F1 to open the VBA or Right click on sheet name and select View Code.
• Navigate the Insert > Module

• Type the following ‘SumByColor‘ UDF in the editor

=SumByColor(Cell_with_background_color_that_you_wish_to_sum, Range_to_e_summed_up)

• Now enter the function ‘SumByColor‘ as formula
• After that, drag this formula to the whole range.

So, This is all from this topic.

Input Values Starting with 0

When an input value starts with zero, Excel will delete the zero by default. Rather than reset the Format Cells, this problem can be easily solved by adding a single quote mark ahead of the first zero, as shown.

Hide Data in Excel

Almost all user know that how to hide data by right clicking to select the Hide function, but this can be easily noticed if there is only a little bit of data.

The best and easiest way to hide data thoroughly is to use the format cells function.

Steps:

• Choose the area, you want to hide
• Go to Home > Font > Format Cells
• Click on Number Tab
• Choose Category as Custom
• Type should be ;;;
• After-that click Ok

All the values in the area will be invisible and can only be found in the preview area next to the Function button.