Skip to main content

Shortcuts Microsoft Excel

Shotcuts Excel

Introduction

Microsoft Excel is a program developed by Microsoft that makes the use of a spreadsheet for doing work. It is very widely used especially for office and administrative activities to keep the entire records. It helps in calculations, creating various tables, graphing tools, saving important numerical data, arithmetic operations etc. It uses a structure of cells arranged in rows and columns. The shortcuts in Microsoft Excel will help you a lot to do your work very easily and in a fast manner.

Here is a list of important shortcuts for Microsoft Excel: 

      ·        F2- it helps in editing the selected cell.

      ·        F3- it helps to paste the names after their creation.

      ·        F4- for repeating the last task that you performed.

      ·        F5- for going to a specific cell.

      ·        F7- for spell checking.

      ·        F11- creating the chart by using the selected data.

      ·        Ctrl + Shift +; - for entering the current time.

      ·        Ctrl +; - for entering the current date.

      ·        Alt + Shift + F1- it helps in inserting a new worksheet.

      ·        Alt + Enter- it will move the text to the next line in the cell.

      ·        Shift + F3- it will open the formula window.

      ·        Shift + F5- it will open the search box.

      ·        Ctrl + 1- it will open the window with the option of format cells.

      ·        Ctrl + A- it helps in selecting all the contents of the worksheet.

      ·        Ctrl + B- to bold the selected section.

      ·        Ctrl + I- to make the selected section italic.

      ·        Ctrl + K- to insert the link.

      ·        Ctrl + S- to save the currently opened worksheet.

      ·        Ctrl + U- to underline.

      ·        Ctrl + 5- to strikethrough the highlighted selection.

      ·        Ctrl + P- for printing.

      ·        Ctrl + Z- to undo the last task performed.

      ·        Ctrl + F3- to open the excel name manager.

      ·        Ctrl + F9- help to minimize the current window.

      ·        Ctrl + F10- help to maximize the current window.

      ·        Ctrl + F6- helps in switching between open workbooks.

      ·        Ctrl + Page up- helps in moving between worksheets in the same document.

      ·        Ctrl + Page down- helps in moving between worksheets in the same document.

      ·        Ctrl + Tab- helps in moving between two or more open excel files.

      ·        Alt + = - creates the sum total of all the above cells.

      ·        Ctrl + ' – for inserting the value of the above cell into the current cell.

      ·        Ctrl + Shift + 1 – uses comma format for numbers.

      ·        Ctrl + Shift + 4- uses currency format for numbers.

      ·        Ctrl + Shift + 3- uses date format for numbers.

      ·        Ctrl + Shift + 5- uses percentage format for numbers.

      ·        Ctrl + Shift + 6- uses scientific format for numbers.

      ·        Ctrl + Shift + 2- uses time format for numbers.

      ·        Ctrl + Arrow key- helps in moving to next section of the text.

      ·        Ctrl + Space-helps in selecting an entire column.

      ·        Shift + Space- helps in selecting an entire row.

      ·        Ctrl + - - helps in deleting the selected row or column.

      ·        Ctrl + Shift + = -helps inserting a new row or column.

      ·        Ctrl + Home – helps in moving to the cell A1.

      ·        Ctrl + ~ -helps in switching between showing the values in the cells or the excel formulas.

Conclusion

These shortcuts are very widely used in Microsoft Excel and can surely help anyone who uses them in their daily routine work. It will make the work very easy and you will be able to finish all your tasks without any hassles.

Popular posts from this blog

How to install MAC mouse cursor in Windows 10

Windows 10 comes with many options in mouse cursors. They can be changed with their Shape and Size, Their Black and White cursor are also good. But if you are interested in something different than Apple's Mac mouse cursors are available in market to satisfy you.

How to install MAC mouse cursor in Windows 10
Now I will show you how to install MAC EI Capitan cursors in Windows 10. Following steps will help you.


Step 1.   Go to http://in-dolly.deviantart.com/art/Updated-ElCapitan-cursors-593804414.

Step 2.   Now click on Download link which is in the right corner of website, When this Zip file completely downloaded, now open that Zip file using WINRAR, or locate the file and right click. Now select Extract All(if you have WinRAR installed in your device).

Step 3.   After that select location, where you want to install that file on your Device.


Step 4.   Now open that file and locate the file install.inf. After that click on particular file to install MAC EI Capitan cursors in Windows 1…

HOW TO USE KEYBOARD SHORTCUTS KEYS IN WINDOWS 10

● Ctrl+A 
    Use the keyboard shortcut key ctrl+Ato select all item in a window or a text file..

● Ctrl+B
     Use the keyboard shortcut key ctrl+Bto Boldhighlighted text

● Ctrl+C      Use the keyboard shortcut key Ctrl+C to copy the highlight text. ● Ctrl+F Use the keyboard shortcut key Ctrl+F to Find in any program,This includes your Internet browser to find text on the current page.
● Ctrl+N Use the keyboard shortcut key Ctrl+N to Create new page Or Documents.
● Ctrl+O     Use keyboard shortcut key Ctrl+O to open a file.
● Ctrl+P    Use the keyboard shortcut key Ctrl+P to Print the page being viewed. For example, the document in Microsoft Word or the web page in your Internet browser.
● Ctrl+S     Use the keyboard shortcut key Ctrl+S to While working on a document or other file in almost every program pressing Ctrl+S will save that file. This shortcut key should be used frequently anytime you're working on anything important..
● Ctrl+T     Use the keyboard shortcut key Ctrl+T to open a ne…

How to set Ethernet and Proxy settings in windows 10

To connect your PC to LAN or WAN you need to connect to Ethernet. Your computer sometimes uses proxy settings to connect to the Internet.
Use Ethernet settings in Windows 10
To open Ethernet, go to Start menu, click on Settings.

Now click on Network & Internet (Wi-Fi, airplane mode, VPN).


Here second last option is Ethernet. Initially, it will not show anything until you connect it.


Use Proxy settings in Windows 10
To open Proxy, go to Start menu, click on Settings, now click on Network & Internet (Wi-Fi, airplane mode, VPN).


In Proxy settings first is Automatic proxy setup. Here PC will take settings automatically. You can use setup script also. It will use a proxy server for Ethernet or Wi-Fi connections. These settings do not apply to VPN connections.


Second is Manualproxy setup. Here you can set manually proxy setup. These settings also do not apply to VPN connections.
You may like How to set VPN and Dial-up settings in Windows 10.