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
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
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.**