- 194
- 1 670 480
Rath Point
India
เข้าร่วมเมื่อ 16 ก.ย. 2017
Rath Point's Official TH-cam Channel.
In Rath Point, watch MS Office Tutorial videos. SUBSCRIBE Rath Point, Like, Share and click on bell icon to get notifications for new videos to improve your MS Office skills.
We are updating the MS Office tutorial videos from time to time with more valuable contents, to improve your knowledge.
Please feel free to COMMENT on videos which will motivate us to add more videos for you.
MS Office is so much important now a days and you must learn it.
Thanks for watching in Rath Point TH-cam channel.
Have a Great Day and Stay Safe.
#RathPoint
In Rath Point, watch MS Office Tutorial videos. SUBSCRIBE Rath Point, Like, Share and click on bell icon to get notifications for new videos to improve your MS Office skills.
We are updating the MS Office tutorial videos from time to time with more valuable contents, to improve your knowledge.
Please feel free to COMMENT on videos which will motivate us to add more videos for you.
MS Office is so much important now a days and you must learn it.
Thanks for watching in Rath Point TH-cam channel.
Have a Great Day and Stay Safe.
#RathPoint
How to Paste Data in Reverse Order in Excel
In this video, I’ll show you how to paste data in reverse order in Excel.
Learn to copy and paste data in reverse order in Excel with easy steps. After watching this video, you can reverse the order of data such as text, value or numbers in Microsoft Excel. It will make the data upside down or flip vertically withing the column in the Excel spreadsheet.
Subscribe for more tutorial videos:
www.youtube.com/@rathpoint/?sub_confirmation=1
00:00 Introduction
00:22 How to Reverse Data in a Column
00:46 How to Flip Data within the Row
Below questions will be answered:
How to paste value in reverse order in Excel?
How to reverse the order of data in Excel?
How do I paste data upside down in Excel?
How do I reverse text order in Excel?
How to reverse a list in Excel?
How to reverse order in sheet?
Can you change the order of data in Excel?
How to reverse numbers in Excel?
How can I reverse the order of data in Excel?
How do you paste and reverse order in Excel?
How to reverse order of names in Excel?
Is there a reverse formula in Excel?
How do you reverse order by?
How do you reverse text in sheets?
How to paste cells in reverse order in Excel Sheets?
How to reverse text in Excel?
How to paste upside down in Excel?
How to paste in reverse order in Excel?
How do I reverse a data sequence in Excel?
How do you reverse changes in Excel?
How do I change the order of data in Excel?
How to flip data in sheet?
How do I reverse the order of a data spreadsheet?
How to flip data in Excel vertically?
How do you reverse words order in Excel?
How do I copy a column in reverse order?
How do I flip data backwards in Excel?
How to reverse a value in Excel?
How do you reverse pasting in Excel?
How to make clipboard paste in reverse order?
How do I flip text backwards in Excel?
How do I invert a list in Excel?
How do I copy data from top to bottom in Excel?
How do you reorder cells in Excel?
How do you reverse a data set in Excel?
How do I paste reverse order in Excel?
How to flip data vertically in Excel?
How to copy and paste columns in reverse order in Excel?
★★ PLAYLIST ★★
Excel Formulas: th-cam.com/play/PLxjABGKb4DEiCZY_7PwkzC5INj0ecRI6i.html
Excel Tutorial: th-cam.com/play/PLxjABGKb4DEi7boBibihO9YjYPXdgAumH.html
Word Tutorial: th-cam.com/play/PLxjABGKb4DEg0_tVlxreolQXVcMrfz22e.html
PowerPoint Tutorial: th-cam.com/play/PLxjABGKb4DEjSn5urJhqCpJUfa1lXYcF1.html
★★ SUBSCRIBE, LIKE, SHARE & COMMENT ★★
www.youtube.com/@rathpoint/?sub_confirmation=1
SUBSCRIBE: Please subscribe to our channel and click on the bell icon to know the latest tips and tricks.
LIKE: If you like the video then please hit the like button.
SHARE: Feel free to share with your friends and family in social networks to improve their knowledge too.
COMMENT: Your comment will motivate us to add more and more videos and will resolve your queries.
WEBSITE: Visit Rath Point website to learn more Excel formulas and functions.
★★ CONNECT with RATH POINT ★★
Website: rathpoint.com/
TH-cam: www.youtube.com/@rathpoint
Instagram: rathpoint
Facebook: rathpoint
Twitter: rathpoint
Subscribe Rath Point:
www.youtube.com/@rathpoint/?sub_confirmation=1
★★ THANK YOU ★★
Thanks for watching Rath Point TH-cam Channel.
Rath Point @rathpoint
Learn to copy and paste data in reverse order in Excel with easy steps. After watching this video, you can reverse the order of data such as text, value or numbers in Microsoft Excel. It will make the data upside down or flip vertically withing the column in the Excel spreadsheet.
Subscribe for more tutorial videos:
www.youtube.com/@rathpoint/?sub_confirmation=1
00:00 Introduction
00:22 How to Reverse Data in a Column
00:46 How to Flip Data within the Row
Below questions will be answered:
How to paste value in reverse order in Excel?
How to reverse the order of data in Excel?
How do I paste data upside down in Excel?
How do I reverse text order in Excel?
How to reverse a list in Excel?
How to reverse order in sheet?
Can you change the order of data in Excel?
How to reverse numbers in Excel?
How can I reverse the order of data in Excel?
How do you paste and reverse order in Excel?
How to reverse order of names in Excel?
Is there a reverse formula in Excel?
How do you reverse order by?
How do you reverse text in sheets?
How to paste cells in reverse order in Excel Sheets?
How to reverse text in Excel?
How to paste upside down in Excel?
How to paste in reverse order in Excel?
How do I reverse a data sequence in Excel?
How do you reverse changes in Excel?
How do I change the order of data in Excel?
How to flip data in sheet?
How do I reverse the order of a data spreadsheet?
How to flip data in Excel vertically?
How do you reverse words order in Excel?
How do I copy a column in reverse order?
How do I flip data backwards in Excel?
How to reverse a value in Excel?
How do you reverse pasting in Excel?
How to make clipboard paste in reverse order?
How do I flip text backwards in Excel?
How do I invert a list in Excel?
How do I copy data from top to bottom in Excel?
How do you reorder cells in Excel?
How do you reverse a data set in Excel?
How do I paste reverse order in Excel?
How to flip data vertically in Excel?
How to copy and paste columns in reverse order in Excel?
★★ PLAYLIST ★★
Excel Formulas: th-cam.com/play/PLxjABGKb4DEiCZY_7PwkzC5INj0ecRI6i.html
Excel Tutorial: th-cam.com/play/PLxjABGKb4DEi7boBibihO9YjYPXdgAumH.html
Word Tutorial: th-cam.com/play/PLxjABGKb4DEg0_tVlxreolQXVcMrfz22e.html
PowerPoint Tutorial: th-cam.com/play/PLxjABGKb4DEjSn5urJhqCpJUfa1lXYcF1.html
★★ SUBSCRIBE, LIKE, SHARE & COMMENT ★★
www.youtube.com/@rathpoint/?sub_confirmation=1
SUBSCRIBE: Please subscribe to our channel and click on the bell icon to know the latest tips and tricks.
LIKE: If you like the video then please hit the like button.
SHARE: Feel free to share with your friends and family in social networks to improve their knowledge too.
COMMENT: Your comment will motivate us to add more and more videos and will resolve your queries.
WEBSITE: Visit Rath Point website to learn more Excel formulas and functions.
★★ CONNECT with RATH POINT ★★
Website: rathpoint.com/
TH-cam: www.youtube.com/@rathpoint
Instagram: rathpoint
Facebook: rathpoint
Twitter: rathpoint
Subscribe Rath Point:
www.youtube.com/@rathpoint/?sub_confirmation=1
★★ THANK YOU ★★
Thanks for watching Rath Point TH-cam Channel.
Rath Point @rathpoint
มุมมอง: 95
วีดีโอ
How to Remove Blank Rows in Excel Shortcut
มุมมอง 85วันที่ผ่านมา
In this video, I'll show you how to remove blank rows in Excel shortcut keys. Learn how to remove blank rows in Excel shortcut keys with easy steps. If you have multiple blank rows in Excel, then its time consuming to select and delete then one by one. In this tutorial video, I’ll show you how to remove all blank rows in Excel at once with keyboard shortcut keys. After watching this video, you ...
How to Unhide Excel Workbook
มุมมอง 11014 วันที่ผ่านมา
In this video, I’ll show you how to unhide Excel workbook. Learn how to unhide Excel workbook accidentally hidden. You can easily unhide workbook in Excel after watching this tutorial video. Sometimes you can find that the entire Excel file is hidden when opened. In this video, I will explain how to unhide an entire Excel file step-by-step. Subscribe for more tutorial videos: www.youtube.com/@r...
How to SUM by Cell Colour in Excel without VBA
มุมมอง 25621 วันที่ผ่านมา
In this video, I’ll show how to SUM by cell colour in Excel without VBA. rathpoint.com/how-to-sum-by-cell-colour-in-excel-without-vba You can also COUNT cells based on the background fill colour of the cell without using VBA in Office 365, Excel 2021, Excel 2019 and Excel 2016. Similarly, you can use IF, IFS, SUMIF, SUMIFS, COUNIFS, SUBTOTAL, AGGREGATE, AVERAGE and other Microsoft Excel functio...
How to Make an Excel File Read Only after Opening
มุมมอง 238หลายเดือนก่อน
In this video, I’ll show you how to make an Excel file read only after opening. Learn to make an Excel file read only after opening with step-by-step procedures: rathpoint.com/how-to-make-an-excel-file-read-only-after-opening/ You can also remove read only from an Excel file easily after watching this tutorial video. If you have made any changes after making the file read only then you will get...
How to Fix #VALUE! Error in SUMPRODUCT Function
มุมมอง 4074 หลายเดือนก่อน
In this video, I’ll show you how to fix #VALUE! error in SUMPRODUCT function. Learn why SUMPRODUCT formula not working and what are the solutions to correct it. Visit website to learn how to use SUMPRODUCT Formula in Excel with Examples: rathpoint.com/sumproduct-formula-in-excel/ Subscribe for more tutorial videos: www.youtube.com/@rathpoint/?sub_confirmation=1 The syntax of Excel SUMPRODUCT fu...
How to create Pivot Table from Multiple Sheets in Excel
มุมมอง 16K10 หลายเดือนก่อน
In this video, I'll show how to create pivot table from multiple sheets in Excel. The pivot table from multiple sheets in Excel with same columns or different columns, can be done easily. After watching this tutorial video, you can easily create one pivot table from 2 sheets, 3 sheets, 4 sheets or more in Excel. Creating a PivotTable in Excel from multiple worksheets or workbooks is possible by...
How to Insert Checkbox in Excel
มุมมอง 7K11 หลายเดือนก่อน
In this video, learn how to insert checkbox in Excel. rathpoint.com/how-to-insert-checkbox-in-excel/ You can insert, edit and format multiple checkboxes in Microsoft Excel cell. Then you can click the Excel checkbox to tick and untick it. If you cannot insert a checkbox without the developer tab, then first you need to add the developer tab in Microsoft Excel. Subscribe Rath Point: www.youtube....
How to Remove Saved to this PC in Title Bar
มุมมอง 72Kปีที่แล้ว
In this video, I’ll show you how to remove “Saved to this PC” in title bar of Microsoft Word, Excel and PowerPoint. You might have noticed “Saved to this PC” in title bar after saving a Word document, Excel spreadsheet or PowerPoint slide. To get rid of “Saved to this PC” in title bar after file name, follow the steps mentioned in this tutorial video. Subscribe Rath Point: www.youtube.com/@Rath...
How to Count Uppercase or Lowercase Letters in Excel
มุมมอง 3.5Kปีที่แล้ว
How to Count Uppercase or Lowercase Letters in Excel
How to Automatically Add Serial Numbers in Excel
มุมมอง 36Kปีที่แล้ว
How to Automatically Add Serial Numbers in Excel
How to fix Arrow Keys Not Moving Cells in Excel
มุมมอง 91K2 ปีที่แล้ว
How to fix Arrow Keys Not Moving Cells in Excel
How to Share Excel Workbook with Multiple Users
มุมมอง 127K2 ปีที่แล้ว
How to Share Excel Workbook with Multiple Users
How to Convert Month Number to Month Name in Excel
มุมมอง 11K2 ปีที่แล้ว
How to Convert Month Number to Month Name in Excel
How to keep column index number in VLOOKUP automatically
มุมมอง 10K2 ปีที่แล้ว
How to keep column index number in VLOOKUP automatically
How to Change Default Currency in Excel
มุมมอง 2.5K2 ปีที่แล้ว
How to Change Default Currency in Excel
Combine Multiple Excel Workbooks into One
มุมมอง 2.1K2 ปีที่แล้ว
Combine Multiple Excel Workbooks into One
How to convert PDF to Excel without losing formatting
มุมมอง 3.2K2 ปีที่แล้ว
How to convert PDF to Excel without losing formatting
How to Edit PDF File in Laptop for Free
มุมมอง 9462 ปีที่แล้ว
How to Edit PDF File in Laptop for Free
very informative
Thanks 😊
Thank you
Welcome 😊
شكرا 👍
Welcome 😊
Thanks so much, good sir!
Welcome 😊
Great
Thanks 😊
Thank you ❤
Welcome 😊
Thank you so much
Welcome 😊
Nice
Thanks 😊
Thank you for the quick guidance. It's really helpful.
Welcome 😊
Very useful, why so few people watched this video? Well done.
Thanks 😊
Thanks a lot, it helped to resolve an issue
I am glad that it helped you. Thanks for your comment.
very helpful
Thanks 😊
thankyou Sr i subscribed
Welcome 😊
Hi brother, I am asking again this question , How to insret page number orders for multiple worksheets one execel file
I will make a video and will let you know the steps, so that it will be easy for you. Thanks
Please explain, my Documents are multiple work sheet how to do insert page numbers orde for those,
Keep your sheets in order. Then insert page number. The starting page number you can manually update if it's not reflecting correctly.
sir ap video editing app konsa use kar rahy ho
There are many free apps, imovie in macOS is also free.
@@rathpoint sum based on color and sign of interrogation, how it will in Capcut
I am not sure about Capcut.
Nice one
Thanks 😊
Music is damn low, please next time put more louder 👍🏽 useless
Sure, Thanks for your suggestion 😊
Thanks it worked for me
Welcome 😊
thanks
Welcome 😊
Thank you so much sir Subscribed ❤ I was looking for shortcuts which actually works . Thank you once again sir❤
You're welcome 😊
Hi, your video helped. When I did the search for 'keyboard' it didn't bring up the onscreen keyboard... I then typed in 'onscreen' and the search bar brought up onscreen keyboard and I was able to click off the scroll lock! Thanks
I am glad that it helped you. Thanks for your comment ☺️
If we share it in whatsapp group, than can the people in the group change it or edit it from mobile
Excel mobile version is always with limited features. Full features are available only in Windows or Mac version.
thanks boss, useful information.
Welcome 😊
To be honest, this is not really useful. I put formatting, formula and other for a purpose. Removing it will not help. You should speak about other options such as Power Query or alternatives.
Let me know the issue clearly, so that I can provide the solution.
MY MAN !! nice =CHOOSE(LEFT(TEXT(A1,"000000000.00"))+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine") &IF(--LEFT(TEXT(A1,"000000000.00"))=0,,IF(AND(--MID(TEXT(A1,"000000000.00"),2,1)=0,--MID(TEXT(A1,"000000000.00"),3,1)=0)," Hundred"," Hundred and ")) &CHOOSE(MID(TEXT(A1,"000000000.00"),2,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ") &IF(--MID(TEXT(A1,"000000000.00"),2,1)<>1,CHOOSE(MID(TEXT(A1,"000000000.00"),3,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine"), CHOOSE(MID(TEXT(A1,"000000000.00"),3,1)+1,"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen")) &IF((--LEFT(TEXT(A1,"000000000.00"))+MID(TEXT(A1,"000000000.00"),2,1)+MID(TEXT(A1,"000000000.00"),3,1))=0,,IF(AND((--MID(TEXT(A1,"000000000.00"),4,1)+MID(TEXT(A1,"000000000.00"),5,1)+MID(TEXT(A1,"000000000.00"),6,1)+MID(TEXT(A1,"000000000.00"),7,1))=0,(--MID(TEXT(A1,"000000000.00"),8,1)+RIGHT(TEXT(A1,"000000000.00")))>0)," Million and "," Million ")) &CHOOSE(MID(TEXT(A1,"000000000.00"),4,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine") &IF(--MID(TEXT(A1,"000000000.00"),4,1)=0,,IF(AND(--MID(TEXT(A1,"000000000.00"),5,1)=0,--MID(TEXT(A1,"000000000.00"),6,1)=0)," Hundred"," Hundred and")) &CHOOSE(MID(TEXT(A1,"000000000.00"),5,1)+1,,," Twenty"," Thirty"," Forty"," Fifty"," Sixty"," Seventy"," Eighty"," Ninety") &IF(--MID(TEXT(A1,"000000000.00"),5,1)<>1,CHOOSE(MID(TEXT(A1,"000000000.00"),6,1)+1,," One"," Two"," Three"," Four"," Five"," Six"," Seven"," Eight"," Nine"),CHOOSE(MID(TEXT(A1,"000000000.00"),6,1)+1," Ten"," Eleven"," Twelve"," Thirteen"," Fourteen"," Fifteen"," Sixteen"," Seventeen"," Eighteen"," Nineteen")) &IF((--MID(TEXT(A1,"000000000.00"),4,1)+MID(TEXT(A1,"000000000.00"),5,1)+MID(TEXT(A1,"000000000.00"),6,1))=0,,IF(OR((--MID(TEXT(A1,"000000000.00"),7,1)+MID(TEXT(A1,"000000000.00"),8,1)+MID(TEXT(A1,"000000000.00"),9,1))=0,--MID(TEXT(A1,"000000000.00"),7,1)<>0)," Thousand "," Thousand and ")) &CHOOSE(MID(TEXT(A1,"000000000.00"),7,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine") &IF(--MID(TEXT(A1,"000000000.00"),7,1)=0,,IF(AND(--MID(TEXT(A1,"000000000.00"),8,1)=0,--MID(TEXT(A1,"000000000.00"),9,1)=0)," Hundred "," Hundred and "))& CHOOSE(MID(TEXT(A1,"000000000.00"),8,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ") &IF(--MID(TEXT(A1,"000000000.00"),8,1)<>1,CHOOSE(MID(TEXT(A1,"000000000.00"),9,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine"),CHOOSE(MID(TEXT(A1,"000000000.00"),9,1)+1,"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"))
Thank u so much
Welcome 😊
Pls share formula to highlight cells having small alphabets/ letters
First, use the formula mentioned in this video to count lowercase. Then use conditional formatting with IF >0 and give color to highlight. Hope you got it.
@@rathpointsir, I want to highlight small letters in the whole sheet, not in a single column? Is this possible
Yes, include formula in conditional formatting.
Thnx bru
Welcome 😊
U solve my problem.i search 2.5 hour continuously TH-cam videos
I am glad that it helped you. Thanks for your comment.
Good infm❤
Thanks 😊
Help
Hope it helped you.
I tried the formula but it still give an error.
Please help
Let me know your formula.
Did you get the video clip?
thanks bro
Welcome
Thank you so much ❤
Welcome 😊
Thank You so much bro❤
Welcome 🙏
Thank you 🙏
Welcome 🙏
Thank you....... Useful
Welcome 😊
Excellent, thank you.
Welcome.
You really help a lot, thank you so much👍
Welcome 😊
Can we use if function instead minus please show me how to do it ,and show how to compare number and text combination to get if function For example if coloumn C4 contione 500 and D4 contains true word I should get valid text in E5
Instead of multiple IF functions, use IFS function. Check the short video: th-cam.com/users/shortsHuweiCz97kg?feature=share
Very helpful! Thank you
Welcome 😊
😊 thanks
Welcome 😊
Thank you very much, this help me much, love u
Welcome 😊
Super
Thanks 😊
Thank you so much for this.
Welcome 😊
🙏
🙏
Thanks
Welcome 😊
Thank you so much meri problem solved ho gai bhai😊
I am glad that it solved your problem. Thanks for your comment ☺️
wow thank u so much
Welcome 😊
If I use number 852000 it shows as eight hundred fifty two thousand instead of eight laks fifty two thousand
You can replace the text lakhs with thousand.