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

Automatically align the column widths in Windows Xp

Some times when you browse folders in details view, the view may be cluttered and you might want to resize the column widths manually to get the complete details fit in a single screen in the horizontal direction so that you need not use the horizontal scroll bar to view the details which are off screen. Alternatively, Windows Xp provides an automatic way to adjust column width. Just select any row in the list and press they key combination, “ctrl + ‘+’of the numeric key pad”.
Read more

How to disable all the flash in SeaMonkey using AdBlock plus ( flashblock not working when JavaScript is disabled)

Flash block is a very good add-on for blocking flash in SeaMonkey, but when you disable JavaScript in the browser, the flashblock add-on does not work. So here is an alternative. In SeaMonkey after installing AdBlock plus, do the following to remove flash completely. Open AdBlock plus (Go to tools > AdBlock plus). Now click the filters menu and select ADD FILTERS. Now in the filter rule type *.swf and click the apply button. Here after you will not be able to view flash in your browser. Blocking flash helps save a lot of bandwidth. If you want to see flash in a particular page then you will have to disable AdBlock plus by going to AdBlock plus > options >and uncheck the Enable AdBlock plus menu.
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