funvocablab

  EXCEL TIPS AND TRICKS   v  Hate Numbering Cells do this =sequence(enter the no you want to enter)                   Ex : =sequence(20) from 1 to 20 number will be displayed. v  Ctrl+Shift+Down arrow to select the column in which data is entered. v  Ctrl+shift+L : To Filter and unfiltered. v  How to move columns? If you want to move the column then drag it drop by pressing shift. v  Ctrl+T : To convert in table. v  Ctrl + : To insert a new row. v  Ctrl+Space: To insert a new column by selecting a column. v  Ctrl + - : To delete a column by select a column. v  Ctrl+Shift+1 : To Format this values as no. v  Ctrl+Shift+4: To Format the value as currency. v  Subtotal : Alt+= v  F7: To check to spell               Formula Errors and How to Fix Them v  ####:  This Error comes if the number is too large to adjust in a cell then adjust & drag the cells to solve this. v  #Name? : If you have done a typo error in the formula then this error can happen. v  # Value! :  If you accidentally add