7 Best Shortcut Keys In MS Excel:- Www.office.com/setup

 Microsoft Excel is the amazing application of MS Office and it is designed by Microsoft. You can enjoy this application by installing MS Office via www.office.com/setup. This application is used for formatting, editing and making spreadsheets etc. You can use this software on various devices like Window OS, Mac, Computer, Laptop and Android Phones. User can use shortcut keys in MS Excel which helps you in format text, apply number format, and also helps in performing calculations. 

read also>>> How to Repair and Reinstall Office 365?

Best Shortcut Key Used In MS Excel:

  1. Insert New Worksheet in Excel:

To add new worksheet into the current workbook, you have to press and hold Shift key, press F11 and you can release both keys. This will insert a new worksheet in the current workbook.

  1. Wrap Text on Two Lines:

In case, the text in a cell runs beyond the border of the cell, then you have to wrap the text so that the text remains within the cell. If you want to set the cell to automatically wrap, then you have to select the cell and this will open the Format Cells dialog box. Now, you have to go to the Alignment tab, and then just select the Wrap text check box. This will automatically wrap the text inside the cell.

  1. Add Current Date:

In case, you want to enter the date into any cell of your worksheet, then you have to press Ctrl+; (Semicolon). This will work if you have clicked once on the cell, or double-clicked on the cell just to enter Edit mode. This shortcut will insert the current date into the cell.

  1. Add Current Time:

To add the current time to worksheet, you have to press ctrl +shift+;. This will work whether the cell is selected or in Edit mode. This method will insert the current time into the cell.

  1. Insert A Hyperlink:

First, you have to select the cell where you want to insert the hyperlink. Then you have to type a word to act as anchor text and hit Enter key. After this, again select the cell to make it active cell. Then you have to press the Ctrl and K keys on the keyboard just to open the Insert Hyperlink dialog box. Now in the Address text box, you should type a full URL and just select OK and then close the dialog box. Here, the anchor text in the cell is blue and it is underlined which shows it contains a hyperlink. www.office.com/setup

  1. Show Formula:

If in case, you want to find cells that contain formulas, then you can use this keyboard shortcut:

Ctrl+` (Grave Accent)

Basically, the Grave Accent key is situated to the left of the number 1 key on the top row of the keyboard.

  1. Undo Typing and Mistakes:

If you want to Undo your actions, you have to press CTRL and Z keys at the same time. This will reverse the last change you have made in the worksheet.

There are many shortcut keys in MS Excel, so for more information just visit to the site of MS Excel via office.com/setup.

 

visit here: www.webroot.com/safe       www.avg.com/retail

Popular posts from this blog

Office 2019 vs. Office 365: Which Should You Buy?

Image
 Hаvе уоu еvеr wоndеrеd whаt іѕ thе difference bеtwееn Offісе 365 аnd Office 2019? Aren’t thеу juѕt thе lаtеѕt version оf thе MS Office аррѕ уоu uѕе еvеrу day? Fоr mаnу uѕеrѕ, thіѕ саn bе vеrу confusing – іn thіѕ blog, уоu wіll lеаrn thе dіffеrеnсе bеtwееn thе twо www.office.com/setup аnd understand whаt ѕuіtѕ уоu аnd/оr уоur оrgаnіzаtіоn bеѕt.   Whаt іѕ Microsoft Office 365?   Microsoft Office 365 іѕ a subscription-based ѕеrvісе thаt рrоvіdеѕ Offісе аррlісаtіоnѕ аnd cloud-based ѕеrvісеѕ monthly оr annual. Thеrе аrе mаnу dіffеrеnt subscription рlаnѕ – fоr hоmе uѕеrѕ, ѕmаll аnd mеdіum businesses, lаrgе соmраnіеѕ, ѕсhооlѕ, and nоn-рrоfіt organizations. Sоmе оf thеѕе рlаnѕ include trаdіtіоnаl MS Offісе аррlісаtіоnѕ (ѕuсh аѕ Outlооk, Word, Exсеl, PowerPoint, еtс.) thаt уоu install оn уоur system – оthеrѕ dо nоt! Whаt іѕ іmроrtаnt tо note іѕ thаt Microsoft Office 365 оffеrѕ wеb-bаѕеd ассеѕѕ tо trаdіtіоnаl MS Offісе applications (ѕuсh аѕ Outlооk, Wоrd, Exсеl, PоwеrPоіnt, еtс.), but аlѕо a w
Read more

How Do I Clear The Clipboard History In Window 10? - www.office.com/setup

Image
 If the user wants to save the work which they do on your Windows 10 PC, then you should clear your clipboard history. For more details, you can visit www.office.com/setup . Way to Delete Clipboard History in Window 10:  Create A Shortcut: First, you have to power up your Windows 10 device. Then from the start screen which is there in the Windows system, you have to to left click or tap on the “ Desktop ” icon. Now, you have to right click on an open space on your Windows 10 desktop. At this point, you need to left click on the feature “New” in the menu. Here by left clicking on “New”,  you have to open a new menu and you have to left click again on the “Shortcut” feature. Now you will see a “Create Shortcut” window will open up on your screen. At this point, in the white field just under “Type the location of the item” you have to type the following text: cmd /c “echo off | clip” When you write the text above, then you have to left click on the “Next” button which is there in the lowe
Read more

Get started with Zoom For Schools:

 Zoom allows you to video chat with large groups on your computer or mobile device. Zoom is different from other video chat services in that it allows you to invite as many people as possible. Zoom meetings can host up to 1000 participants. Zoom is used by schools, businesses, and other organizations to hold meetings, classes, and host virtual events. www.office.com/setup A key feature of Zoom is that participants do not need to have a Zoom account. This makes Zoom easier to use, but it will restrict what you can do. Privacy and security It's important that we address privacy and security issues before we go any further with Zoom. Zoom claims that they have end-to–end encryption. This means that Zoom cannot access audio and video from meetings. Research has shown that Zoom can access meeting data at any time they want. This flaw could lead to the loss of confidential information that was transmitted via the service. Zoom has also issues with data privacy. It has been found sharing
Read more