Skip to main content

Excel control


  1. =CONCATENATE(cell1, cell2) → Combine text from different cells.
    • Alt + =  : sum all
  2. 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 
  3. Ctrl + Spacebar → Select the entire column.
    • Shift + Spacebar → Select the entire row.
  4. 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)
  5. Ctrl hit  : the  selected cells come to format ( select multi cell )
    • F      C    O     T     S 
  6. Ctrl + +/- : to add  or delete row/ column
  7. Ctrl + home : first cell
  8. Ctrl +T : create table 
  9. 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

Popular posts from this blog

TIPS AND TRICKS WITH HOTKEY

Indesign hotkey with tips and tricks 10/11/2017 1.TO GIVE HOT KEY ON PARAGRAPH OR CHARACTER STYLE NEED A NUM KEYBOARD 2.WE CAN ASSIGN A ALPHABET ON THE DEC TAB SETTER TO ALIGN link: https://learn.g2.com/what-is-graphic-design design field https://www.vistaprint.in/business-cards?txi=15626&xnid=TopNav_Visiting+Card&xnav=TopNav for all size print photoshop hotkey PHOTOSHOP SHORTCUTS Keys for viewing images This is not a complete list of keyboard shortcuts. This table lists only those shortcuts that are not displayed in menu commands or tool tips. Result Windows Mac OS Cycles through open documents Control + Tab Control + Tab Close a file in Photoshop and open Bridge Shift-Control-W Shift-Command-W Toggle between Standard mode and Quick Mask mode Q Q Toggle (forward) between Standard screen mode, Maximized screen mode, Full screen mode, and Full screen mode with menu bar F F Toggle (ba...

Movies done

thinksmart studio with my work https://youtu.be/2xIsHOW-LTU my vfx movie krishna arjuna hero " NAGARJUN GARU" https://www.youtube.com/watch?v=X0dLQxkQlsE My first Movie as visual effect artist -2006-7 my shot link: https://www.youtube.com/watch?v=Pex2sjmFte0 shot time:5.40/6.00 paint work software used : Adobe After Effects input https://youtu.be/z4IyFVBRtCI hindi dubb: https://www.youtube.com/watch?v=tkKwnZUVCMw shot time time :11.35 min shot time time :11.55 min making of yogi https://www.youtube.com/watch?v=z4IyFVBRtCI https://www.youtube.com/watch?v=xaCt7Yf64ls time:1.45.45s morphing shot  software used:Combusiton https://www.youtube.com/watch?v=iIc0PLt2vM0&t=189s titel time : 1.38s titel done 3ds max + photoshop as a supervisor for roto and visual effects shot software :Nuke and aftereffects long link: https://www.youtube.com/watch?v=Lq3xf1iu4dg time:0.15 roto work Software used : Adob...

ARDHAM MOVIE 2022 PROJECT

 https://drive.google.com/file/d/1KlkjFxA_89MmlW88KQYluhvxPS5H8mkF/view?usp=drive_link its the image of 2011 international animation day the camera feed with a wrong date 👍