0

Excel Shortcuts Formulas and Basic function Keys

Here you will find Excel Shortcuts Formulas (vlookup, hlookup) and Basic function Keys self made shortcuts.

Basic Excel Features
Ctrl+s
Save the active file with its current file name, location, and file format.
Ctrl+p
Print File (Opens print menu).
Ctrl+o
Open File.
F12
Display the Save As dialog box.
f10 (or alt)
Turnkey tips on or off.
F1
Display the Excel Help task pane.
F7
Display the Spelling dialog box.
Alt+F11
Open the Visual Basic Editor to create Macros.
Shift+F7
Display the Thesaurus dialog box.
Alt+F8
Display the Macro dialog box.
Inside Worksheets
Ctrl+g or F5
Display the ‘Go To’ dialog box.
Shift+F4
Repeat last find.
Tab/Shift+Tab
Move one cell to the right / to the left in a worksheet.
Alt+Page Down/Alt+Page Up
Move one screen to the right / to the left in a worksheet.
Selecting Data
Ctrl+Shift+*
Select all the rows and columns around the active cell.
Ctrl+Space
Select the entire column Vertically
Ctrl+Shift+(+)
Display the Insert dialog box to insert blank cells.(if clip board empty)(if clip board having data then insert that data)
Ctrl+Shift+spacebar (twice)
Select the entire worksheet or the data-containing rows and columns.
Ctrl+Shift+Page Up (and Page Down)
Select the Next and Previous sheet in a workbook.
F8
Turn on extension of selection with arrow keys without having to keep pressing shift.
Ctrl+Alt+v
Display the Paste Special dialog box.
Shift+Spacebar
Select the entire row Horizontally
Edit Cells
Shift+Enter
Move UP
F2
Edit the active cell with cursor at end of the line.
Ctrl+;
Insert current date.
Ctrl+Shift+:
Insert current time.
Copy Data From above and right side row Making Chart
Alt+F1
Create and insert chart
Shift+F2
Insert / Edit a cell comment.
Ctrl+Shift++
Insert Cell/Row/Column Menu
Ctrl+k
Insert a hyperlink.
F11
Create and insert chart in a separate Chart sheet.
Ctrl+l
Display Create Table dialog box
Ctrl+-
Delete Cell/Row/Column Menu
Ctrl+”
Copy above cell values
Ctrl+r
Copy cell from the left
Ctrl+’
Copy above cell formulas
Ctrl+d
Copy above cell
Hide and Show Elements
Alt+Shift+Arrow Right
Group rows or columns.
Ctrl+Shift+0
Unhide any hidden columns within the selection.
Ctrl+Shift+9
Unhide any hidden rows within the selection.
Ctrl+9
Hide the selected rows.
Ctrl+0
Hide the selected columns.
Format Data
Ctrl+u or ctrl+4
or remove an underline.
Ctrl+5
or remove strikethrough formatting. (example)
Ctrl+Shift+f
Font adjustment
Ctrl+I or ctrl+3
or remove italic formatting.
Ctrl+b or ctrl+2
or remove bold formatting.
Ctrl+1
Format cells dialog.
Ctrl+Shift+%
Percentage format with no decimal places.
Ctrl+Shift+!
Number format with two decimal places, thousands separator.
Ctrl+Shift+~
General number format.
Ctrl+Shift+@
Time format with the hour and minute, and indicate A.M. or P.M.
Ctrl+Shift+$
Currency format. Ex. $1,231.00
Ctrl+Shift+#
Date format with the day, month, and year. Ex. 10-october-2014
Self Shortcut
Paste special
Alt+h then type v (P – past, F- Formula,O- formula and Number formatting, K- Keep Source Formatting)
Alt+ N
Insert Menu
Alt+ P
Page Layout Menu
Alt+ M
Formulas Menu
Alt+ A
Data Menu
Alt+ R
Review Menu
Alt+ V
View Menu

 

Setting Names
Ctrl+F3
Define a name or dialog.
Ctrl+Shift+F3
Create names from row and column labels.
F3
Paste a defined name into a formula.
Formulas
=
It will Start a formula (basic)
Ctrl+a
Select All
Shift+F3
Display the Insert Function dialog box.
Alt+=
Insert the AutoSum formula.Ex = sum().
F4 ( while applying Vlookup )
It will freeze cell reference (e.g. =B69) makes reference absolute (=$B$70)
Shift+F3
Insert a function into a formula .
F9
Calculate all worksheets in all open workbooks.
Shift+F9
Calculate the active worksheet.
Ctrl+`
Toggle Show formula in cell instead of values
Ctrl+Alt+Shift+F9
Recheck dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
Ctrl+Shift+u
Toggle expand or collapse formula bar.
Put(=) VLOOKUP(lookup_value,table_array,
col_index_num,range_lookup)
vlookup
Ctrl+Alt+F9
Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.

Excel Shortcuts Formulas and Basic function Keys

0

How to remove infolinks from your wordpress website

How to remove infolinks from your WordPress website

Hi Guys infolinks is very much frustrating for me and also making my website very slow down. I don’t think so that i can earn so much with this advertiser. Whenever I am trying to open my page it stuck and behave very sluggish, believe me this is frustrating.

 

So finally I tried to remove from my website but it’s not removing. Below are the steps to remove.

  • Open your website and click on infolinks advertisement question mark and infolinks website open with below page here you have to just select ** Prefer to not see infolinks Ads on this site? Click here to opt-out.” Option and this will remove from your website.**