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 a heading or any home to the formula then this error.

v #Div/0! : If you divide something but accidentally click on a blank cell this error occurs.

v #Ref! : If you accidentally delete the column this error occurs then press Ctrl+Z(Undo) to resolve this.

funvocablab