- =CONCATENATE(cell1, cell2) → Combine text from different cells.
- Alt + = : sum all
- Alt + H + A L / C / R → Align cell content (Left / Center / Right).
- Alt + H + FI + S → TO add number automate
- Alt + H + B + A/N → TO add boarder
- Alt + H +O + I /A→ auto fit
- Ctrl + Spacebar → Select the entire column.
- Shift + Spacebar → Select the entire row.
- Ctrl + V → Paste into all selected cells at once.
- Ctrl + D → Fill down (copies the content from the top cell into all selected cells below)
- Ctrl hit : the selected cells come to format ( select multi cell )
- F C O T S
- Ctrl + +/- : to add or delete row/ column
- Ctrl + home : first cell
- Ctrl +T : create table
- ALT + W + Q = it MOVE TO view menu and zoom level
-------------------------------------- t-----------------------------------------------------------------------------
1 Formulas & Functions
=CONCATENATE(cell1, cell2) → Combine text from different cells.
Alt + = → AutoSum (adds up numbers quickly).
Alt + H + F + I + S → Insert number automatically (Series Fill).
2 Formatting & Alignment
Alt + H + B + A / N → Add or remove borders.
Alt + H + O + I /A→ Auto fit column width/Hight.
3 Selection
Ctrl + Spacebar → Select the entire column.
Shift + Spacebar → Select the entire row.
Ctrl (hold) → Select multiple non-adjacent cells.
4 Editing & Filling
Ctrl + V → Paste into all selected cells.
Ctrl + D → Fill down (copy top cell into selected cells below).
Ctrl + +/- → Insert or delete selected row/ column
5 Navigation
Ctrl + Home → Jump to the first cell (A1).
Comments
Post a Comment