10 Short Tips to smartly work in Excel

Use COUNTIF(range, criteria) to count how many cells meet a specific condition.

[{"selector":"#anim-f9316056-5e36-4310-babc-55301dbdc9f7","keyframes":{"opacity":[0,1]},"delay":600,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-84e3c4ee-1ced-4de9-bca5-f6af4f3e9a06","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

Type the first few dates, select them, then drag the fill handle to complete the sequence.

[{"selector":"#anim-cdea8f7d-6451-4afa-8dbf-684f52f0182d","keyframes":{"opacity":[0,1]},"delay":600,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-62a083f0-2f8a-41b0-aee1-021ea689d12c","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

Press CTRL+; to insert the current date into a cell.

[{"selector":"#anim-cda7b02b-8d1f-4030-a13f-d7c6ac1c23d8","keyframes":{"opacity":[0,1]},"delay":600,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e293e687-5ed5-4238-b3e4-1b6085494fd3","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

Highlight a range and press ALT+= to quickly sum up the selected numbers.

[{"selector":"#anim-c1efe51f-1116-4fe4-8034-30a3fbf69c8f","keyframes":{"opacity":[0,1]},"delay":600,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-dde45948-c281-4246-9969-5c734081fcd8","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

Use CTRL+Arrow keys to quickly move to the edge of data in any direction.

[{"selector":"#anim-6cc619e4-1d4f-4fe6-824b-aea66b4541fc","keyframes":{"opacity":[0,1]},"delay":600,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0c13f020-f957-43f4-88f1-becc87c09e2f","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

Double-click the fill handle to autofill formulas down to the end of your data.

[{"selector":"#anim-85121934-ec74-4fff-a96f-e3156cdaec4d","keyframes":{"opacity":[0,1]},"delay":600,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-3235731e-81f4-489b-b3dc-4a40a88f8bdd","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

Use data validation to restrict what users can enter in specific cells.

[{"selector":"#anim-c1b72568-6104-4e87-a6f6-84eab9a84d9e","keyframes":{"opacity":[0,1]},"delay":600,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ae8b320b-0656-49c9-84dc-5be3560c96b4","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

Split a single cell's contents into multiple cells using 'Text to Columns'.

[{"selector":"#anim-df940ed8-151f-4352-b280-584557b30504","keyframes":{"opacity":[0,1]},"delay":600,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-6e88136f-b57b-4d82-b59b-b159e2e270dd","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

Use CTRL+Delete to clear cell contents without deleting formats or comments.

[{"selector":"#anim-4040d050-7aba-4ffe-bb4d-eafca945b20f","keyframes":{"opacity":[0,1]},"delay":600,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-37d9f665-d110-4aca-90be-ebea2ee49311","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

Use data validation to create dropdown lists that automatically adjust based on source data changes.

[{"selector":"#anim-0ddb7e1b-4605-4363-bc15-6dba6ffc2330","keyframes":{"opacity":[0,1]},"delay":600,"duration":1000,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-af5ffc0e-0b8a-4c3a-ba82-68b1315f598a","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

Visit the Blog Excelabcd.co.in

[{"selector":"#anim-13a59533-aa89-4dae-b216-ebce5c75969b","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}]

10 Short Tips to smartly work in Excel

Use COUNTIF(range, criteria) to count how many cells meet a specific condition.

COUNTIF() for Conditional Counting

Type the first few dates, select them, then drag the fill handle to complete the sequence.

Fill Dates Quickly with Auto Fill

Press CTRL+; to insert the current date into a cell.

CTRL+; for Current Date Entry

Highlight a range and press ALT+= to quickly sum up the selected numbers.

Quick Sum with ALT+=

Use CTRL+Arrow keys to quickly move to the edge of data in any direction.

CTRL+Arrows for Navigation

Double-click the fill handle to autofill formulas down to the end of your data.

Quickly Copy Formulas with Autofill

Use data validation to restrict what users can enter in specific cells.

Protect Cells with Data Validation

Split a single cell's contents into multiple cells using 'Text to Columns'.

Split Text with Text to Columns

Use CTRL+Delete to clear cell contents without deleting formats or comments.

Quickly Delete Contents with CTRL+Delete

Use data validation to create dropdown lists that automatically adjust based on source data changes.

Create Dynamic Dropdowns with Data Validation

Visit the Blog Excelabcd.co.in