Featured post

Trick to get the sum row wise or column wise

    Row-wise or Column-wise Sum Using a Shortcut: Select the range of numbers in the table that you want to sum (either a column or a row, or even multiple columns or rows). Press the Alt key on your keyboard. After pressing Alt , press the +   = key . This is the AutoSum shortcut. If you're summing a column , Excel will automatically fill the cell directly below the selected range with the sum of that column. If you're summing a row , Excel will automatically fill the cell directly to the right of the selected range with the sum of that row.   The AutoSum feature ( Alt + = ) automatically sums numbers in a contiguous range of cells.    

how to change horizontal table to vertical table


 

Comments

POPULAR POSTS

essential BAsic excel formulas a quick guide

Some important tips to learn MS Word

Insert Serial Numbers in Roman Numerals, Alphabets, and Numbers in Excel

How to find sum of numbers with units in a range in Excel?

Rearrange columns in excel sheet using a quick trick

TIPS TO INSERT A SERIAL NUMBER IN AN EXCEL SHEET