Skip to main content

Best of Microsoft Excel Useful Shortcuts:


Best of Microsoft Excel Useful Shortcuts:

Excel is the best software I have ever seen. You can do anything in it, from home and personal accounts to complex calculations to games. Use the below shortcuts wisely!!!!
Shortcut Keys
Description
Ctrl + Shift + ;
Enter the current time.
Ctrl + ;
Enter the current date.
Ctrl + A
Select all contents of the worksheet.
Ctrl + B
Bold highlighted selection.
Ctrl + I
Italic highlighted selection.
Ctrl + K
Insert link.
Ctrl + U
Underline highlighted selection.
Ctrl + 5
Strikethrough highlighted selection.
Ctrl + P
Bring up the print dialog box to begin printing.
Ctrl + Z
Undo last action.
Ctrl + F9
Minimize current window.
Ctrl + F10
Maximize currently selected window.
Ctrl + F6
Switch between open workbooks / windows.
Ctrl + Page up
Move between Excel work sheets in the same Excel document.
Ctrl + Page down
Move between Excel work sheets in the same Excel document.
Ctrl + Tab
Move between Two or more open Excel files.
Ctrl + '
Insert the value of the above cell into cell currently selected.
Ctrl + Shift + !
Format number in comma format.
Ctrl + Shift + $
Format number in currency format.
Ctrl + Shift + #
Format number in date format.
Ctrl + Shift + %
Format number in percentage format.
Ctrl + Shift + ^
Format number in scientific format.
Ctrl + Shift + @
Format number in time format.
Ctrl + Arrow key
Move to next section of text.
Ctrl + Space
Select entire column.
Shift + Space
Select entire row.
F2
Edit the selected cell.
F5
Go to a specific cell. For example, C6.
F7
Spell check selected text or document.
F11
Create chart.
Alt + =
Create a formula to sum all of the above cells
Alt + Shift + F1
Insert New Worksheet.
Shift + F3
Open the Excel formula window.
Shift + F5
Bring up search box.


Popular posts from this blog

How to make print screen button to automatically open the Snipping tool in Windows 11

 In windows you can search for keyboard from start menu and open keyboard settings.  Or you can go to Settings > Accessibility > Keyboard. In the keyboard settings window, toggle the switch that says "Use the Print screen button to open screen snipping".  Hereafter whenever you press print screen button, you will be able to make a selection on the screen for a screenshot.  

How to get Ribbon Style Interface in LibreOffice Write and Calc.

The ribbon interface in Microsoft office makes it easy for users to complete tasks easily. You can get a similar interface in LibreOffice by following the steps below: 1. Download the latest version of LibreOffice (at the time of writing this post, the version is 5.4) 2. Open LibreOffice Writer and Go to Tools > Options. 3. Under LibreOffice section, click Advanced. 4. Check the checkbox saying, "Enable Experimental Features". 5. Now go to View > Toolbars > select Notebookbar. 6. After restating, you should get ribbons. 7. You can still access the old layout by clicking on the three slider menu button and selecting MenuBar, to show the old style menu bar as well. If you want to change the tool bar style, you can select View (in the old style Menubar) > Toolbar Layout > Default. You can do the same for LibreOffice Calc as well.

How to automatically shut down computer after downloading in WIndows PC

You may have to shut down the PC after a certain time to automate your computer to shut down, say after finishing a download. To do so, you need to open the command prompt. In the command prompt, type the following: shutdown -s -t xxx where, xxx = time in seconds. If you decide to abort the above within the time, type the following in the command prompt. shutdown -a Eg, shutdown -s -t 2400 will shutdown the computer in 40 minutes (2400/60).