FRENZ 4 EVER

Shayari, FREE cards, Masti Unlimited, Fun, Jokes, Sms & Much More...

Frenz 4 Ever - Masti Unlimited

Hi Guest, Welcome to Frenz 4 Ever

Birthday Wishes : Many Many Happy Return Of The Day : ~ Harini, Mim2007, Mishra808, Simply_deepali.
Thought of The Day: "Be wise enough to walk away from the nonsense around you."

Excel time saving shortcuts

Share
avatar
SourabhBasak
Administrator
Administrator

Member is :
Online
Offline


Male

Capricorn Pig

Posts : 5393
I LiveHyderabad

Job/hobbies : Storage Administrator
KARMA : 197
Reward : 613

Mood : crafty

F4e Status : Gham-e-Hayat ki tashreeh aur kya hogi,
Diya jalakar tarasta hu Roshni ke liye..

Excel time saving shortcuts

Post by SourabhBasak on Tue Oct 13, 2009 2:36 pm

Move to next cell in row - Tab
Move to previous cell in row - Shift + Tab
Up one screen - Page Up
Down one screen - Page Down
Move to next worksheet - Ctrl + Page Down
Move to previous worksheet - Ctrl + Page Up
Go to first cell in data region - Ctrl + Home
Go to last cell in data region - Ctrl + End
Bold toggle for selection - Ctrl + B
Italic toggle for selection - Ctrl + I
Underline toggle for selection - Ctrl + U
Strikethrough for selection - Ctrl + 5
Change the font - Ctrl + Shift + F
Change the font size - Ctrl + Shift + P
Apply outline borders - Ctrl + Shift + 7
Remove all borders - Ctrl + Shift + Underline
Wrap text in same cell - Alt + Enter
Format cells - Ctrl + 1
Select font - Ctrl + Shift + F
Select point size - Ctrl + Shift + P
Format as currency - Ctrl + Shift + 4
Format as general - Ctrl + Shift + # (hash sign)
Format as percentage - Ctrl + Shift + 5
Format as number - Ctrl + Shift + 1
Autosum a range of cells - Alt + Equals Sign
Insert the date - Ctrl +; (semi-colon)
Insert the time - Ctrl + Shift +; (semi-colon)
Insert columns/rows - Ctrl + Shift + + (plus sign)
Insert a new worksheet - Shift + F11
Read Monitor Cell One - Alt + Shift + 1
Read Monitor Cell Two - Alt + Shift + 2
Read Monitor Cell Three - Alt + Shift + 3
Read Monitor Cell Four - Alt + Shift + 4
List Visible Cells With Data - Ctrl + Shift + D
Lists Data In Current Column - Ctrl + Shift + C
List Data In Current Row - Ctrl + Shift + R
Select Hyperlink - Ctrl + Shift + H
Move To Worksheet Listbox - Ctrl + Shift + S
Move To Monitor Cell - Ctrl + Shift + M
Select Worksheet Objects - Ctrl + Shift + O
List Cells At Page Breaks - Ctrl + Shift + B
Options Listbox - Insert + V


_________________________
avatar
roypriti
Learner
Learner

Member is :
Online
Offline


Female

Aries Rat

Posts : 125
I LiveLeeds(UK)

Job/hobbies : Flirting
KARMA : 4
Reward : 8

Mood : pretty

Re: Excel time saving shortcuts

Post by roypriti on Tue Oct 13, 2009 3:01 pm

wht is excl?
avatar
imran niazi
Member
Member

Member is :
Online
Offline


Posts : 394
Humor : Life is Nothing Without You

KARMA : 44
Reward : 451

Mood : Happy

Re: Excel time saving shortcuts

Post by imran niazi on Wed Jan 06, 2010 9:16 pm

rose Good Post rose
avatar
SourabhBasak
Administrator
Administrator

Member is :
Online
Offline


Male

Capricorn Pig

Posts : 5393
I LiveHyderabad

Job/hobbies : Storage Administrator
KARMA : 197
Reward : 613

Mood : crafty

F4e Status : Gham-e-Hayat ki tashreeh aur kya hogi,
Diya jalakar tarasta hu Roshni ke liye..

Re: Excel time saving shortcuts

Post by SourabhBasak on Wed Jan 13, 2010 7:47 pm

Thanks for appreciations dear....... flowers


_________________________

Sponsored content

Re: Excel time saving shortcuts

Post by Sponsored content


    Current date/time is Fri Aug 18, 2017 6:31 am