How to write Ranking in Excel best Excel Tips and Tricks
Short cut for ranking, suppose you have table like this and want to write ranking in this way, don't do like this, just write first rank, and then press control 1 button, you will get new tab from that tab under font option just select superscript tab, and press ok button, you will get the ranking, now just drag down this up to where you need these ranks, we will revise the same process, from main task bar under general select format cells tab, under font option select superscript and press ok button, you will get the results, just apply the same trick on your excel sheet and update me is it working or not, if facing any issue comment me under comments section, if you like this video please thumbs up, share and subscribe my channel setline excel for more great videos.
Select one or more characters you want to format.
Press Ctrl + 1 to open the Format Cells dialog box.
Then press either Alt + E to select the Superscript option or Alt + B to select Subscript.
Hit the Enter key to apply the formatting and close the dialog.
Scrol bar : • SCROLL BAR IN EXCEL [ HOW TO CREATE OR AD...
Mail Merge: • MAIL MERGE IN EXCEL TRICKY TOOL TO CREATE ...
IFRS 1 : • IFRS 1 [ International Financial Reportin...
IAS 2 : • IAS 2 Inventories - IFRS [ International A...
YouTube :-
/ @setlineexcel
Instagram :-
https://www.instagram.com/tv/B05VXAUn...
Facebook :-
/ excel-lovers-111636520186727
modal=admin_todo_tour
LinkedIn:
/ set-line-537477191
Mix: https://mix.com/setlineexcel
Pinterest: / setlineexcel
https://www.tumblr.com/blog/setlineexcel
https://twitter.com › ExcelSet
Blogger: https://setlineexcel.blogspot.com/p/e...
Music credit goes to: Alan walker -
https://filesgarage.com/viewfile.php?...
NOTE:- some pictures,music& graphics are shown in this video may be copyrighted to respected owner, not mine
________________________________
PLEASE WATCH LIKE COMMENT AND SUBSCRIBE MY CHANNEL Setlineexcel FOR MORE USEFUL AND NICE VIDEOS.