shortcut keys in Excel:

 Here is a list of some commonly used shortcut keys in Excel:


1. Ctrl + C: Copy selected cells or text.

2. Ctrl + X: Cut selected cells or text.

3. Ctrl + V: Paste copied or cut cells or text.

4. Ctrl + Z: Undo the last action.

5. Ctrl + Y: Redo the last action.

6. Ctrl + A: Select all cells in the current worksheet.

7. Ctrl + B: Apply or remove bold formatting.

8. Ctrl + I: Apply or remove italic formatting.

9. Ctrl + U: Apply or remove underline formatting.

10. Ctrl + F: Open the Find dialog box to search for specific content.

11. Ctrl + H: Open the Find and Replace dialog box to search and replace specific content.

12. Ctrl + S: Save the current workbook.

13. Ctrl + N: Create a new workbook.

14. Ctrl + O: Open an existing workbook.

15. Ctrl + P: Print the current workbook.

16. Ctrl + W: Close the current workbook.

17. Ctrl + Page Up: Switch to the previous worksheet.

18. Ctrl + Page Down: Switch to the next worksheet.

19. Ctrl + Shift + + (plus sign): Insert cells, rows, or columns.

20. Ctrl + - (minus sign): Delete cells, rows, or columns.

21. Ctrl + Shift + $: Apply currency formatting.

22. Ctrl + Shift + %: Apply percentage formatting.

23. Ctrl + Shift + #: Apply date formatting.

24. Ctrl + Shift + @: Apply time formatting.

25. Ctrl + Shift + &: Apply border formatting.

26. Ctrl + Shift + ~: Apply general number formatting.

27. Ctrl + Shift + !: Apply comma formatting.

28. Ctrl + Shift + ^: Apply exponential formatting.

29. Ctrl + Shift + *: Select the current region around the active cell.

30. Ctrl + Shift + L: Toggle the filter on or off.


These are just a few examples of the many shortcut keys available in Excel. You can find a complete list of shortcut keys by pressing the "Alt" key and looking for the underlined letters in the ribbon menu.

Comments

Post a Comment

Popular posts from this blog

Set password by default when transfering data through xender hot spot network.

Image
We are going to explain how to transfer data securely through xender app. Whenever we turn on hot spot of xender then mobile hot spot network turned on through a xender which is by default open network. In this case if our data connection is on then any one can access our network and may they perform crime through network. So always keep your network password protected. How to Set password in xender when turned on hot spot through it 1.  Go to settings menu in xender app. 2.  Under the connect phone tab click on to set connection password. 3.  At that time it will ask password give password on pop up box. 4.  Done. Now check your hot spot network is now secure with password.
Read more

Browser cache weakness

    Browser cache weakness Severity: Medium Vulnerability description Browsers can store information for purposes of caching and history. Caching is used to improve performance, so that previously displayed information doesn’t need to be downloaded again. History mechanisms are used for user convenience, so the user can see exactly what they saw at the time when the resource was retrieved. If sensitive information is displayed to the user (such as their address, credit card details, Social Security Number, or username), then this information could be stored for purposes of caching or history, and therefore retrievable through examining the browser’s cache or by simply pressing the browser’s Back button. Impact Browsers often store information in a client-side cache, which can leave behind sensitive information for other users to find and exploit, such as passwords or credit card numbers. The locations at most risk include public terminals, such as those in libraries and Inte
Read more

Email Phishing

Image
Email Phishing may get an attacker your personal information like credentials, credit card information, registered mobile number, etc PII (Personal Identifiable Information) parameters. How to perform Phishing via Email? Step 1: Create an identical working website that is appearing quite similar to the official company website. This dummy website acts as a fake verified validation to the target to gain trust over. Ex. Gmail account login page, Facebook login page or any other website. Step 2: An important part to ponder over is the URI or URL of the fake but working website that has to be changed minutely in such a way that the target person is not able to spot the changes easily in its link and fewer people are aware as well as concerned about this security threat. Ex. For 'gmail.com' one can modify it to 'gma1l.com' or for 'facebook.com' that can be modified to 'facebeok.com'. Users enter their details here on the fake login page without checking
Read more