• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

function list [SOLVED]

Afarag

Member
Dears,

Please i want help,

i want to know how i can make function Prolapse list as explained in this sheet as highlight yellow row

https://www.dropbox.com/s/9bgxtjzlmpk6ovt/TS103827362.xltx


thanks a lot
 
Hi, Afarag!

That's a Microsoft Bing Porftolio template. Would you please elaborate? I neither see any explanation there nor any yellow row.

Regards!
 
Hi,sirjb7

sorry for confused the right sheet

https://www.dropbox.com/s/1jhi8zyos83m9eh/Microsoft%20Bing.xlsx

I want to understand how to make this list of data validation founded at the last row.

Yes, you are right That's a Microsoft Bing Portfolio template I see it very useful as you exactly

appreciate your efforts.

Afarag
 
Hi, Afarag!


It's the table total line feature that comes with Excel. Do this:

a) Create a new workbook, type titles for A & B columns, and fill a few rows with numbers, like date and amount.

b) Go to Insert tab, Tables group, Table, and create a new one from the data entered in a)

c) Click on any cell of the new table and an overlapping Table Tools ribbon will appear at the right of the Excel option ribbon.

d) Go to Table Style Options and click on Total Row.

... et voilà, c'est tout!


Regards!
 
Hi, Afarag!

Glad you solved it. Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.

Regards!
 
Back
Top