Skip to main content

Posts

Showing posts from September, 2025

Excel control

=CONCATENATE(cell1, cell2) → Combine text from different cells. A lt + =  : 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--------------------------------------------------------------------...