Excel Keys that helps you in using/accessing excel without mouse

-



Particluars Shortcuts
Create new Excel File Ctrl N
Create New Sheet Shift F11
Move Between Sheets Clockwise Ctrl PageDown
Move Between Sheets Anti-Clockwise Ctrl PageUp
Move between opened Excel Workbooks Ctrl Tab
Undo Ctrl Z
Redo Ctrl Y
Save Ctrl S
Save As F12
Insert Table Ctrl L
Zoom In Ctrl Alt +
Zoom Out Ctrl Alt -
Hide/Unhide the Toolbar Ctrl F1
Right-Clicking Menu Shift F10
Display Control Menu Alt SpaceBar
Close Excel File Ctrl F4
Switch the Fn mode Fn Esc
Go to Cell A1 Ctrl Home
Go to Last Cell of Data Ctrl End
Select Whole Continuos Range Ctrl A
Select Column Ctrl SpaceBar
Select Row Shift SpaceBar
Delete Selected Cell Ctrl -
insert Selected Cell Ctrl +
Move within Selection ClockWise Tab
Move within Selection Anti-ClockWise Shift Tab
Open "Go To" Window F5
Open Name Manager Ctrl F3
Go to Linked Cell Ctrl [
Fill Down Ctrl D
Fill Right Ctrl R
Show / Edit Cell Formula F2
Paste Special Ctrl Alt V
Paste Only Formula Ctrl Alt V F
Paste Only Format Ctrl Alt V T
Paste Only Value Ctrl Alt V V
Paste Only Widths Ctrl Alt V W
Paste Transpose Ctrl Alt V E
Paste Link Ctrl Alt V L
StrikeThrough / Cross Text Ctrl 5
Repeat Previous Action F4
Format As Percent Ctrl Shift %
Format As General Ctrl Shift ~
Format As Currency Ctrl Shift $
Open Format Cell Window Ctrl 1
Auto Sum / Sub Total Alt =
Show all Formula Ctrl ~
Insert / Show Comment Shift F2
Delect Comment Shift F2 Esc Delete
Change Font Alt H F F
Change Font Size Alt H F S
Edit Border Alt H B
Central Alignment Alt H A C
Align left Alt H A L
Align Right Alt H A R
Go to Conditional Formatting Alt H L
AutoFit Column Width Alt H O I
Customize Column Width Alt H O W
AutoFit Row Height Alt H O A
Customize Row Height Alt H O H
Hide Rows Alt H O U R
Hide Column Alt H O U C
Hide Sheet Alt H O U S
Unhide Row Alt H O U O
Unhide Column Alt H O U L
Unhide Sheet Alt H O U H
Rename Sheet Alt H O R
Sort Alt A S S
Filter Alt A T
Text to Column Alt A E
Page Break Preview Alt W I
Normal View Alt W L
Freeze Top Row Alt W F R
Freeze Top Column Alt W F C
UnFreeze Sheet Alt W F F
Start / Stop recording Macros Alt L R
Go to Macro Dialog Box Alt F8
Insert Pivot Table Alt N V

Comments

Post a Comment

Popular posts from this blog

GSTIN CheckSum Digit Logic

-
Image
Its always an adventure for a Professional to find & acquires the information which are lesser-known to generals. Each taxpayer is assigned a state-wise PAN-based 15-digit Goods and Services Taxpayer Identification Number (GSTIN). Here is a format break-down of the GSTIN: The first two digits represent the state code as per Indian Census 2011. The next ten digits will be the PAN number of the taxpayer The thirteenth digit will be assigned based on the number of registration within a state The fourteenth digit will be Z by default The last digit will be for check code. It may be an alphabet or a number. Lets have a Detailed View of Last Digit And Know How to Calculate this Digit Each Digit 0-9 is awarded with a weight from 0-9 & Each Alphabet {A-Z} have weight from 10 -35 Step I  - Assign Weight to Each Digit of GSTIN seperately Step II - Assign "Place Value Factor(PVF)" 1 for All Odd Place Value 2 for All Even Place Value Step I
Read more

Spell-Number in Rupees Excel VBA Formula

-
Please open Virtual Basic using Developer toolbar or pressing shortcut Alt + F11 & Insert new Module from Insert Menu or by right click in Project Explorer. Copy the underneath program in the module. Now move to the excel workbook and try the Formula "=SpellNumber(<number>)" You will get the number converted in Words. For any query please do comment or mail me on Gauravj75@gmail.com Public Function SpellNumbers(ByVal MyNumber) Dim Rupees, Paise, Temp Dim DecimalPlace, Count ReDim Place(9) As String Place(2) = " Thousand " Place(3) = " Lac " Place(4) = " Crore " Place(5) = " Arab " ' String representation of amount MyNumber = Trim(Str(MyNumber)) ' Position of decimal place 0 if none DecimalPlace = InStr(MyNumber, ".") 'Convert Paise and set MyNumber to Rupee amount If DecimalPlace > 0 Then Paise = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & "00", 2)) MyNumber = Tr
Read more

Convert Number to Words Currency in MS Word

-
Image
Convert Number to Words Currency in MS Word Step 1: Enable Developer Tab In MS Word If you can't see the developer tab as like in the below picture, Go to File -&gt; Options -&gt; Customize Ribbon -&gt; Check on 'Devloper' under Main Tabs heading, Step 2: Add the Module Code Click on the Visual Basic option in the Developer Ribbon. Right click on the 'Project' title and Insert -&gt; Module Copy and paste the below code in code window of the Module ---------------- Sub ConvertCurrencyToEnglish ( ) ' MyNumber = Val ( Selection. Text ) Dim Temp Dim Rupees, Paise Dim DecimalPlace, Count ReDim Place ( 9 ) As String Place ( 2 ) = " Thousand " Place ( 3 ) = " lakh " Place ( 4 ) = " Crore " ' Convert MyNumber to a string, trimming extra spaces. MyNumber = Trim ( S
Read more