User Posts: Md. Araf Bin Jayed
0
How to Find Slope of Tangent Line in Excel (2 Suitable Ways)
0

Sometimes, users have to find the slope of a tangent line in Excel. By applying a certain Excel function or utilizing some Excel features, they can perform ...

0
Make an Alternative to Datepicker in Excel (2 Easy Methods)
0

As the datepicker feature of Microsoft Excel is only available for the Windows 32-bit version, it is very difficult when you need this feature for the 64-bit ...

0
How to Stop Excel from Truncating Text (3 Easy Methods)
0

While working in Microsoft Excel, often users have to input long texts in a cell. By default, Excel hides these long texts after a certain limit or when these ...

0
How to Make a Payroll Accrual Calculator in Excel
0

While working with Microsoft Excel, sometimes, users have to make a payroll accrual calculator. Payroll accrual refers to money that is due to your employees ...

0
How to Use REGEX without VBA in Excel (with Easy Steps)
0

If you are using REGEX without VBA in Excel, this article may help you in this regard. REGEX is the abbreviated form of the term "regular expression." It means ...

0
How to Calculate Exponential in Excel (3 Easy Methods)
0

While working with Excel, users have to do different types of calculations. Some may be done manually, and some may require special Excel functions. One such ...

0
How to Apply Abbreviation Using Formula in Excel
0

While working in Excel, users often need to abbreviate text. The texts can be the name of a person, company, or organization. But there is no single function ...

0
How to Remove Anchor in Excel (2 Easy Methods)
0

While working with Excel, users use various types of formulas to get desired values. In a large data set, typing the formula separately for each cell is ...

0
How to Perform Reverse Geocoding in Excel (with Easy Steps)
0

Reverse geocoding means finding out the actual address or location from given latitude and longitude. This task can be quite hectic if you want to perform it ...

0
Determine Sheet Name Limit in Excel (with Easy Steps)
0

In Microsoft Excel, all the data, calculations, visualization, and analysis are stored either in a single or multiple pages. This page is called an Excel ...

0
How to Lookup County from Zip Code in Excel
0

Sometimes users need to lookup a county based on zip codes in Excel. This task can be easily performed by utilizing some Excel functions and features. In this ...

0
How to Copy Chart from Excel to PowerPoint Without Link
0

Sometimes users need to copy charts from Microsoft Excel to PowerPoint for presentation purposes. But, if you copy your chart with a link and then paste it ...

0
How to Link Excel to Google Sheets (with Easy Steps)
0

Many times while working in Excel, users need to link Excel files to Google Sheets. Performing this task is quite easy and simple. In this article, I will show ...

0
How to Skip Data Points in an Excel Graph (with Easy Steps)
0

Excel is a great tool for showing data in various charts and graphs. These features of Excel help to visualize numerical data. But, sometimes, users need to ...

0
How to Make a School Time Table in Excel (with Easy Steps)
0

Using Microsoft Excel, one can perform various types of tasks. Along with the analysis and presentation of data, one can also make charts and tables in Excel. ...

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.

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo