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.


Labels:

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.  
Read more

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.
Read more

How to measure exact power consumption ( in watts) of a device in your house

This works only if you have a digital energy meter. Switch off all appliances in your house, except the device whose energy consumption is to be measured. Now go to the energy meter and usually there is a single white button which toggles between a variety of display functions like Voltage, amps, watts etc. Press the button continuously until you see the Watts information. Some energy meters will only display energy consumed in kW. So if you see .04 kW, that means the device is taking 40 watts, Note that kWh is different from kW. Say if you have a fan that consumes 40W. If you run the fan for one hour, your energy in kWh will be 40/1000 (conversion to kW - divide by thousand) *1 hour = .04 kWh. If you run the fan for 10 hours then 40/1000 * 10 = .4 kWh Usually, 1 kWh = 1 unit of electrical energy. So if you have a device which runs in lower Wattage, you can run it for longer hours for the same amount of kWh consumed. Thus saving on bills. 
Read more