User Posts: Md. Araf Bin Jayed
0
How to Add Data Labels in Excel (2 Handy Ways)
0

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
0

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)
0

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
0

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
0

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)
0

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)
0

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)
0

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)
0

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)
0

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. 1

    2
    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. 1

    2
    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

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo