Top 20 Excel Shortcut Keys | Data Formatting | Techygrow | Daily Life Using Tricks |

Описание: Top 20 Excel Shortcut Keys | Data Formatting | Techygrow | Daily Life Using Tricks


Alt + = How to fill down?
Ctrl + D How to fill right?
Ctrl + R How to do flash filI?
Ctrl + E How to insert hyperlink?
Ctrl + K How to format as table?
Ctrl +T How to filter data?
Ctrl + Shift +L How to name a range?
Ctrl +F3 How to clear cell contents?
Alt +H+E+A How to conditional formatting?
Alt +H+L+N How to freeze top row?
Alt + W+F+R How to freeze /unfreeze row/ column?
Alt +W+FF How to freeze first column?
Alt +W +FC How to text to columns?
Alt +A+E How to remove duplicates? Alt +A +M How to merge and center cells?
Alt +H+ M+C How to delete worksheet?
Alt + E+L How to rename current worksheet? Alt+H+0+R How to sort ascending?
Alt +H+S+A How to sort descending?
Alt +H+S+D How to remove gridlines?
Alt+W+VG How to go to a specific cell?

#viral #viralvideo #trending #excel #tips #tricks

Follow @techygrow