User Posts: Md. Araf Bin Jayed
0
How to Create a Sensitivity Table in Excel (2 Effective Ways)
0

Sensitivity analysis or sensitivity tables in Microsoft Excel are quite easy to create or perform. By giving proper input of data and following some commands, ...

0
Difference Between SUMIF and COUNTIF Functions in Excel
0

While working in Microsoft Excel, users have to use various types of functions for their working purposes. Some of these functions have many similarities, ...

0
[Solved!]: Excel Page Layout Being Greyed Out (4 Quick Fixes)
0

While working in Microsoft Excel, you will find the Page Layout tab in the ribbon that is in the menu bar of a worksheet. This tab provides you with various ...

0
How to Copy SUM Formula in Excel (6 Easy Methods)
0

While working in Excel, users have to apply various types of functions and their corresponding formulas. One such function is the SUM function of Excel. ...

0
Difference Between XML and Excel Files (9 Real Instances)
0

While working with Excel files, users may save them in various formats other than .xlsx. One such format is the .xml format, which means Extensible Markup ...

0
How to Convert Date to Julian Date in Excel (3 Easy Ways)
0

Usually, users have to perform many tasks in Excel, which includes mentioning dates. These dates can be days, months, or years of a particular time. Mentioning ...

0
CONCATENATE vs CONCAT in Excel (2 Ideal Examples)
0

While working with Excel, you need to use various functions depending on your purpose or criteria. Two such functions are the CONCATENATE function and the ...

0
How to Concatenate Names in Excel (5 Easy Ways)
0

In many scenarios, users have to handle or exploit data in Excel in different ways. One such instance is when concatenating names in Excel. By using some ...

0
How to Rename Files in a Folder in Excel (2 Easy Ways)
1

Renaming files might not sound difficult to do for most people. But, renaming a large number of files one by one can become very tedious and time-consuming. ...

0
How to Change Width of Column in Excel Chart (with Easy Steps)
0

In Microsoft Excel, you can perform numerous tasks in a few minutes. Apart from calculating or using various functions for problem-solving, users can use Excel ...

0
How to Create Attendance Sheet with Time in and Out in Excel
2

Attendance sheet is a very important feature for an organization or institution. It helps to keep track of employee performance. Creating an attendance sheet ...

0
How to Calculate Percentage for Multiple Rows in Excel
1

Sometimes, Excel users need to calculate percentages for various working purposes. They may need to find out efficiency or contribution towards total ...

0
How to Create Line of Credit Payment Calculator in Excel
1

In this article, I will show you how to create a line of credit payment calculator in Excel. I will demonstrate the whole procedure using the Microsoft 365 ...

0
How to Add or Remove Dotted Border in Excel (4 Easy Ways)
1

A dotted border is a feature of Microsoft Excel. It may be present in the worksheet by default or by manipulating some commands or options in Excel. In this ...

0
How to Make Food and Beverage Budget in Excel
1

In daily life, people have to make or follow many types of budgets. This is necessary for maintaining the expenses of day-to-day life. If you want to throw or ...

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