Ms. Excel 1 important Tricks
MICROSOFT EXCEL IMPORTANT TRICKS.
Hello Friends You Can See and Watching video for Microsoft Excel Best Most Two Important Tech. Lets Get Start:- Please Follow This Site And Subscription This Website. 👇👇👇👇👇👇 Can you See Excel Video
Dear Friends Look at This (Note)
One important trick in MS Excel is to use keyboard shortcuts. Learning and utilizing keyboard shortcuts can greatly improve your efficiency and speed when working in Excel. Here are a few essential keyboard shortcuts to get you started:
1. Ctrl+C: Copy selected cells or data.
2. Ctrl+V: Paste copied cells or data.
3. Ctrl+Z: Undo the last action.
4. Ctrl+T: Insert a table from selected data.
5. Ctrl+Shift+~: Apply the General number format.
6. Ctrl+Shift+$: Apply the Currency number format.
7. Ctrl+Shift+%: Apply the Percentage number format.
8. Ctrl+Shift+#: Apply the Date format.
9. Ctrl+Shift+@: Apply the Time format.
10. Ctrl+Home: Go to the beginning of the worksheet.
11. Ctrl+End: Go to the last cell with data on the worksheet.
12. Ctrl+Shift+L: Apply AutoFilter to selected range.
13. Ctrl+Spacebar: Select the entire column.
14. Shift+Spacebar: Select the entire row.
15. F2: Enter edit mode in the selected cell.
16. F4: Repeat the last action.
17. F11: Insert a new chart based on the selected data.
18. Alt+Enter: Add a line break within a cell.
19. Alt+H+O+I: AutoFit column width.
20. Alt+H+O+H: AutoFit row height.
These shortcuts are just a starting point, and there are many more available in Excel. Using keyboard shortcuts can save you time and make your Excel tasks more efficient. Consider exploring additional keyboard shortcuts that are relevant to your specific Excel needs.
We
Have Brought You A New Tutorial Online Site Where You Will Get New Videos
Daily. If You Like Watching Our Videos Or Like For Education Then You Can Stay
With Us And Join The Site As A Member. There Is A Contact System Above, If You
Want You Can Contact Via Call/Mail. We Have A YouTube Channel And A Facebook
Page. If You Want, You Can Join.
Thanks
For Visit Our Website
good help site
ReplyDelete