User Posts: Md. Araf Bin Jayed
0

## How to Add Data Labels in Excel (2 Handy Ways)

By using various features in Excel, we can represent data graphically. Also, we can show statistical data in columns, bars, or pie charts. These methods help ...

0

## How to Create a 2D Clustered Column Chart in Excel

Column charts help to analyze and compare data. By creating a 2D clustered column chart in Excel, users can compare data from different variables. In this ...

0

## How to Use Sparklines in Excel (Create and Customize)

Sometimes, Excel users want to show the deviation in their data set or point out the movement of the data. In this case, using sparklines in Excel will help ...

0

## How to Make a Scatter Plot in Excel with Multiple Data Sets

A scatter plot helps a viewer visualize data. Excel users can analyze statistical data easily with the help of scatter plots. In this article, we will show you ...

0

## How to Make a Pie Chart in Excel with One Column of Data

For working or educational purposes, people use pie charts a lot. Pie charts help a user or viewer to understand statistical data easily. In this article, we ...

0

## Excel Loan Calculator with Extra Payments (2 Examples)

In today’s world, loans are an inseparable part of our lives. Sometimes, we need to use the help of loans and instalments to buy our essential products. In ...

0

## How to Make Excel Run Faster with Lots of Data (11 Ways)

Excel is an essential tool for everyday life. We use Excel to analyze  lots of data for our calculation purpose. Sometimes, Excel may not run fast while ...

0

## Income Tax Computation in Excel Format (4 Suitable Solutions)

It is mandatory for every eligible citizen to pay income tax on time. Sometimes, it is hard to determine the amount of tax based on one’s income. In this ...

0

## How to Rearrange Columns in Excel (4 Ways)

In Microsoft Excel, the worksheets consist of rows and columns. Sometimes, the user needs to rearrange the columns in Excel for their working purposes. In this ...

0

## How to Calculate Outliers in Excel (5 Easy Ways)

Outliers may need to be identified in order to do statistical computations on data from a data set. You can discover outliers from huge datasets using ...

Browsing All Comments By: Md. Araf Bin Jayed
1. Reply   Hello Bombshellshock,
You are absolutely correct. To expand the table by a row, click the row just below the table and enter your desired data. After inserting data press Enter and your job will be done.
If this reply doesn’t give a proper answer to your problem, then send the Excel file to [email protected]. Moreover, you can find the Excel file here.

2. Reply   Hello Queda,
If you want to add and subtract across an Excel spreadsheet, it means if you want to give a cell reference in your formula from another sheet, the formula will look like the following one.

``=SUM(B5,B6,B7,B8,B9,B10)-SUM(Cost!B5,Cost!B6,Cost!B7,Cost!B8,Cost!B9,Cost!B10)``

Without giving the proper sheet and cell reference, the formula won’t work or show an error. If this reply doesn’t give a proper answer to your problem, then send the Excel file to [email protected]. Moreover, you can find the Excel file here.  5 Excel Hacks You Never Knew  