Digital creator by ABU

"শুভরাত্রি "

"যার চাহিদা যত কম
তার ঘুমের শান্তি তত বেশি"

With movie and funny Video01 – I just got recognized as one of their top fans! 🎉
please support me!

Good quality content. I see a better future In you. I recommend this page.

Data entry জন্য কিছু টিপস :

, , , , , ,

এক্সেল শিক্ষা জন্য প্রয়োজনীয় সটকাট:

Editing:
Deleting Text :

Description Shortcut Key :

Delete one character to right =Delete

Delete one character to left =Backspace

Edit active cell= F2

Cancel cell entry= Escape Key

, ,


excel জন্য সটকাট নিয়ম:


Formatting Cells :

Description Shortcut Key 👉👉

Format cells =Ctrl + 1
Select font =Ctrl + Shift + F
Select point size =Ctrl + Shift + P
Format as currency =Ctrl + Shift + 4
Format as general (to remove a ny formatting)= Ctrl + Shift
Format as percentage= Ctrl + Shift + 5
Format as number =Ctrl + Shift

Microsoft excel , যারা দুর্বল তাদের জন্য :

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

❤️Formatting Text In Worksheet :

Description Shortcut Key :
👉👉👉

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

Description Shortcut Key এক্সেল জন্য :

New file =Ctrl + N
Open file= Ctrl + O
Save file= Ctrl + S
Move between open workbooks= Ctrl + F6
Close file= Ctrl + F4
Save as= F12
Display the print menu= Ctrl + P
Select whole spreadsheet= Ctrl + A
Select column =Ctrl + Space
Select row= Shift + Space
Undo last action= Ctrl + Z
Redo last action= Ctrl + Y
Start a formula Equals Sign {eg. =SUM(A1+A2)}
Exit
Excel 97= Alt + F4
Navigating

Description Shortcut Key

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