Shortcut Key to Jump Any Sheet in MS Excel (I challenge! you don't know this)

Hi! after long time I back with amazing MS Excel Shortcut key, in this article I will shows you how to jump any excel sheet by using easy keyboard shortcut key, as we knew there is no straight forward key in excel to jump into sheets; so we have to create a shortcut key to save time and energy while working in Microsoft Excel… please watch below video to know how to activate this shortcut key….

 

Code:

Sub Enter_Sheet_Number()

 

Dim sheetnum As Integer

On Error GoTo ErrorMessage

sheetnum = InputBox("Enter Sheet No")

If sheetnum > Sheets.Count Then

MsgBox "Sheet Not Aviable"

Else

Sheets(sheetnum).Activate

End If

ErrorMessage:

If Err.Number = 13 Then

Err.Clear

MsgBox "Invlaid Sheet No"

End If

 

End Sub

 

Sub Enter_Sheet_Name()

 

Dim sheetname As String

sheetname = InputBox("Enter Sheet Name")

On Error GoTo ErrorMessage

Sheets(sheetname).Activate

ErrorMessage:

If Err.Number = 9 Then

Err.Clear

MsgBox "Invlaid Sheet Name"

End If

 

End Sub

 

 

Watch Video Tutorial… Please like, share & subscribe

 

Important Shortcut Keys of Google Docs Probably you don’t know-2020

Important Shortcut keys for Google Docs

Go to Line End	Shift + End
Go to Text End	Ctrl + End
Insert Table	Alt + I, T
Insert Equation	Alt + I, E
Insert Page Number	Alt + I, G
Email	Alt + F, A
Page Setup	Alt + F, G
Download	Alt + F, D
Line Space	Alt + O, L
Superscript	Ctrl + .
Subscript	Ctrl + ,
Spell Check	Ctrl + Alt + X
Comments	Ctrl + Alt + M
Insert Image	Alt + I, I
Copy	Ctrl + c
Cut	Ctrl + x
Paste	Ctrl + v
Paste without formatting	Ctrl + Shift + v
Undo	Ctrl + z
Redo	Ctrl + Shift + z
Insert or edit link	Ctrl + k
Open link	Alt + Enter
Print	Ctrl + p
Open	Ctrl + o
Find	Ctrl + f
Find and replace	Ctrl + h
Find again	Ctrl + g
Find previous	Ctrl + Shift + g
Hide the menus	Ctrl + Shift + f
Insert page break	Ctrl + Enter
Bold	Ctrl + b
Italicize	Ctrl + i
Underline	Ctrl + u
Strikethrough	Alt + Shift + 5
Superscript	Ctrl + .
Subscript	Ctrl + ,
Copy text formatting	Ctrl + Alt + c
Paste text formatting	Ctrl + Alt + v
Clear text formatting	Ctrl + Space
Increase font size	Ctrl + Shift + >
Decrease font size	Ctrl + Shift + <
Left align	Ctrl + Shift + l
Center align	Ctrl + Shift + e
Right align	Ctrl + Shift + r
Justify	Ctrl + Shift + j
Numbered list	Ctrl + Shift + 7
Bulleted list	Ctrl + Shift + 8
Insert comment	Ctrl + Alt + m
Select all	Ctrl + a

Watch video tutorial…. Please like, share & subscribe

Powerful Gaming Laptop Asus Tuf FX504 Specification & Hands On

ASUS TUF Gaming FX504

15.6-inch FHD/4GB Graphics/Core i7-8750H 8th Gen/8GB RAM/

1TB SSHD + 128GB SSD/ 2.30 Kg

Key Feature

Model No.	Asus Tuf Gaming FX504
Screen Size	15.6 Inch
Resolution	1920x1080 Pixels
Processor	Intel Core i7 8th Gen., 2.2 GHz
Hard Disk	1 TB + 128GB SSD
RAM	8 GB upto 32GB
Graphic	4GB Nvidia Geforce TX 1050 Ti
Battery	3 Cells Lithium
USB Port	3 Port
HDMI Port	Yes
RJ45 Lan Port	Yes
Weight	2.3 Kg

Watch Hands On & Review… Please like, share & subscribe… 

Asus VivoBook 15 X512 Bezel Less Laptop, Specification & Hands On

ASUS VivoBook 15 X512DA

AMD Ryzen 5, 15.6-inch FHD

(8GB RAM/512GB SSD/Radeon Graphics/1.75 kg)

Key Feature

Model No.	ASUS VivoBook 15 X512
Screen Size	15.60 Inches Full HD
Resolution	1920 x 1080 pixels
Processor	AMD Ryzen 5 2600H (2.10 GHz)
SSD	512 GB
RAM Size	8 GB DDR4
Graphic	AMD Radeon Vega 8
Battery	Lithium 2 Cells
HDMI Port	Yes
USB Port	3 Ports
Type C Port	Yes
Card Reader	Yes
Weight	1.75 Kg

Watch Review & Hands On…. Please like, share & subscribe 

These Android & iPhone Will Support Wi-Fi Calling-2020

Note: This list is incomplete might be some phone add later……

Xiaomi:

Poco F1,

Xiaomi Redmi K20,

Xiaomi Redmi K20 Pro,

Redmi 7,

Redmi 7A,

Redmi Note 7 Pro,

Redmi Y3,

OnePlus:

OnePlus 7,

OnePlus 7T,

OnePlus 7 Pro,

OnePlus 7T Pro,

OnePlus 6,

OnePlus 6T,

Vivo:

Vivo V11,

Vivo V11 Pro,

Vivo V15,

Vivo V15 Pro,

Vivo V9,

Vivo V9 Pro,

Vivo 1904,

Vivo Y81,

Vivo Y81i,

Vivo Y91,

Vivo Y91i,

Vivo Y93,

Vivo Y95,

Vivo Y15,

Vivo Y17,

Vivo Y91,

Vivo Z1 Pro,

Samsung:

Samsung S10,

Samsung S10 Plus,

Samsung J6,

Samsung On 6,

Samsung M30s,

Samsung A10s,

Samsung M20,

Samsung S10e,

Samsung A30s,

Samsung M30,

Samsung Note 10,

Samsung Note 10 Plus,

Samsung A50s,

Samsung Note 9,

Galaxy A70,

Galaxy A8+,

Galaxy A80,

Galaxy C9 Pro,

Galaxy A20,

Galaxy A30,

Galaxy A5,

Galaxy A6+,

Galaxy A7,

Galaxy A9 Pro,

Galaxy C7 Pro,

Galaxy M20,

Galaxy M40,

Galaxy Note 4,

Galaxy Note 4 Edge,

Galaxy Note 5,

Galaxy S6,

Galaxy S6 Edge,

Galaxy S6 Edge Plus,

Galaxy J2 Pro,

Galaxy J5,

Galaxy J5 Prime,

Galaxy J7,

Galaxy J7 Max,

Galaxy J7 Nxt,

Galaxy J7 Prime,

Galaxy J7 On Nxt,

Galaxy J7 Pro,

Galaxy Note 5 Duos,

Galaxy Note 8,

Galaxy On 5 Pro,

Galaxy On 7 Pro,

Galaxy On 8,

Galaxy On 6,

Galaxy On 7 Prime,

Galaxy On 8,

Galaxy S7,

Galaxy S7 Edge,

Galaxy S8,

Galaxy S8+,

Galaxy S9,

Galaxy S9+.

Apple:

iPhone 11,

iPhone 11 Pro,

iPhone 11 Pro Max,

iPhone 7,

iPhone 7 Plus,

iPhone 8,

iPhone 8 Plus,

iPhone 6S,

iPhone 6S Plus,

iPhone SE,

iPhone XR,

iPhone X,

iPhone XS,

iPhone XS Max,

Coolpad:

CoolPlay 6,

Mega 5C,

Mega 5

Google:

Pixel 3,

Pixel 3 XL

Pixel 3A,

Pixel 3A XL,

Infinix:

Infinix Hot 7 Pro,

Infinix Smart 3 Plus,

Infinix Hot 6 Pro,

Infinix S4

Lava:

Lava Z61,

Lava Z92,

Lava Z60s,

Lava Z81,

Motorola: Moto G6

Please like, share & subscribe….