How To Office Windows 10

The List Of Best Microsoft Excel Keyboard Shortcuts In Windows 10

Microsoft Excel is tightly integrated with the business world, so it is hugely important. We share some of the best Microsoft Excel keyboard shortcuts in Windows 10.

Corporate, data management and data integrity. Microsoft Excel has surely spoiled us when it comes to how easy it has made for us to manipulate large amounts of data which, if done manually, would take years.

Whether it’s running a multi-million dollar business or a small startup, Microsoft Office is the cornerstone for keeping/storing all corporate data. In particular, the Microsoft Excel is music to the ears of people who are in charge of computations and accounts. For those who are accustomed to work on the Excel 2010 or further, this is their complete guide to the available Microsoft Excel shortcuts which will not only make playing with data easier but also make it time efficient. We have filtered some that no longer work.

F11 = Insert chart. Press these two and a new worksheet with a chart will open.

Insert chart

Ctrl+H = Displays the Replace dialog box. Search and replace in the blink of an eye. Simply press these two and type what you wish to find and what to replace it with.

Find and replace

Press enter and you get this.

Replace

Ctrl+“;” = Pressing these together enters the current date in the selected cell.
Insert date

Ctrl+K = Displays the Hyperlink dialog box to insert new hyperlinks or edit existing hyperlinks. Press these two together and a dialogue box will open, your desktop should look like this.

Add hyper link

Now, in the “Text to display” write something that the user would click on that would direct it to the subsequent website and the address of the website in the Address. Your screen should look something like this.

how to add hyperlink

Now after pressing enter, the selected cell would display the word “iPhone 6S”. Clicking on it would direct it to the mentioned web address. After pressing enter, our screen should look something like this.

Hyperlink successfully inserted

Ctrl+O = Displays the Open dialog box to open or find a file. Press these two and the screen should show this.

Opening dialogue box

Ctrl+Shift+“;” = Enters the current time.

Current time inserted

Ctrl+Shift+“=” = Displays the Insert dialog box.

Insert dialogue box

More shortcuts for the MS Excel are as follows:

Alt+Enter = Starts a new line in the same cell.

Alt+F11 = Displays the Microsoft Visual Basic Editor.

Alt+F8 = Displays the Macros dialog box to run, edit or delete macros.

Alt+Space = Displays the Control menu for the program window.

Ctrl+1 = Displays the Format Cells dialog box.

Ctrl+Arrow keys = Moves to the edge of the current data region in a worksheet.

Ctrl+B = Applies or removes bold formatting.

Ctrl+I = Applies or removes italic formatting.

Ctrl+U = Applies or removes underlining.

Ctrl+D = Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below. Basically, it’s the same as Ctrl+C and then Ctrl+V.

Ctrl+End = Ctrl+End moves to the last cell on a worksheet, in the lowest used row of the rightmost used column.

Ctrl+Home = Moves to the beginning of a worksheet.

Ctrl+Page Down = Switches between worksheet tabs, from right-to-left.

Ctrl+PageUp = Switches between worksheet tabs, from left-to-right.

Ctrl+W = Closes the selected workbook window.

F12 = Displays the Save As dialog box to save the file with a different name, type or location.

F2 = Edits the active cell and positions the insertion point at the end of the cell contents.

Shift+Enter = Moves one cell up in a selected cell range.

So folks, that’s just about it but if you do discover any more shortcuts capable of joining the list of best Microsoft Excel Keyboard Shortcuts do let us know and we’ll update the list. For now its shortcuts, shortcuts and more shortcuts.