Learn how to create am invoice template in Excel.

You will learn how to create a simple and auto fill invoice in Excel. If you do this you are essentially getting a free invoice template. And finally answer your question to how do I make a simple invoice?

Here are the steps outlined in my video.

Dropdown List For Product
1) Cell C14
2) Data ~ Data Validation
3) Setting tabs
4) Allow = List
5) Source = =$U$14:$U$20
6) Enter twice
7) Copy & paste to all rows

Unit Price Lookup
1) Select cell J14
2) =IFERROR(VLOOKUP(C14, $O$14:$P$20, 2, FALSE),0)
3) Copy and paste for the rest of the rows

Total
1) Select cell K14
2) =J14*I14
3) Apply to rest of the rows

Automatically Hide Row
1) Select cell L14
2) =IF(C13=””,0,1)
3) Apply formula to rest of the rows
4) Place cursor in header.
5) Ctrl + Shift + L
6) Apply Filter to Helper column to display only value of 1
7) Right-click on sheet.
8) View Code
9) Paste the VBA script
10) Ctrl + S
11) Close VBS Editor

Here is the VBA script

Private Sub Worksheet_Change(ByVal Target As Range)
Me.AutoFilter.ApplyFilter
End Sub

🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗
Invoice Template in Excel – PART 1 – Excel Tips and Tricks
https://youtube.com/shorts/Gx_zm_8OvZE?si=lfS1kAiN0LzwN3Di

Invoice Template in Excel – PART 1 – Excel Tips and Tricks
https://youtube.com/shorts/CTIHhpW9QHA?si=bA9PUSlN68gpJwcp

Invoice Template in Excel – Excel Tips and Tricks – DETAIL EXPLANATION
https://youtu.be/20dLD2-DoLc?si=fk96v-gU_YuU8t_h

#shorts #microsoft #excel #microsoft #tiktok #shortvideo #howto #fyp #google