Crazy Microsoft Excel Hacks ๐ฅ
Tejas Patil
Visit on Instagram@elementec
Crazy Microsoft Excel Hacks ๐ฅ
.
Check caption for details ๐
Hack 1
1. Select a cell you want to refer to easily
2. Tap on the Name box on the top left, beside the formula bar
3. Write the โnameโ that you want to give to the cell
4. Whenever you want to get that value. Just type =โnameโ in any cell where you want the value and it will show up there.
Hack 2
1. Click on any cell in a data.
2. Tap Ctrl+T
3. It will convert the data into a structured table with color formatting
Hack 3 - Easily fill data
1. Just type the first information you want to extract from the cell. It can be First name, any number, email anything.
2. Press enter and select the cell where you typed the first info.
3. Press Ctrl+E to fill up the rest of the data on the basis of the first prompt.
*If shortcut does not work, you can find the Flash fill option in the Data tab.
#excel #msexcel #excelhacks #tips #office #microsoft #techreels #techtips #tipsandtricks #elementec #hacks #technology
#trending #reelsviral #reelsinstagram
Comments
Comments from the original post on Instagram
No comments yet
