10 short tips for Excel Users

10 short tips for Excel users

Use the AutoSum button to quickly sum a range of cells.

[{"selector":"#anim-49d15870-74d7-4410-bc78-f2898095c474 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

Use the Fill Handle to copy cells or fill in a series.

[{"selector":"#anim-dad38c6b-8415-41ac-b960-7f797cd95be3 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

Use the Ctrl + Space shortcut to select the entire column of a selected cell.

[{"selector":"#anim-ed0f1151-a3c1-4f3e-8332-6423e0aff7f2 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

Use the Shift + Space shortcut to select the entire row of a selected cell.

[{"selector":"#anim-06e9e1cf-471f-4e8d-b447-c938cc4f77b1 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

Use the Ctrl + F shortcut to find and replace text in a worksheet.

[{"selector":"#anim-2b52de41-7900-4d25-900a-f45f3dbe6b72 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

Use the Ctrl + Z shortcut to undo the last action.

[{"selector":"#anim-242a4481-c7f1-41ba-bbc5-a0690f324900 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

Use the Ctrl + Y shortcut to redo the last action.

[{"selector":"#anim-7587b5d6-f639-471d-8fcf-02f553b72047 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

Use the Ctrl + Home shortcut to go to the first cell in a worksheet.

[{"selector":"#anim-91f074ac-7bf1-45e5-b723-e09576a4073f [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

Use the Ctrl + End shortcut to go to the last cell in a worksheet used in a worksheet.

[{"selector":"#anim-d4833fa5-87c7-4113-9190-74d9a023fd8e [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

Use the F2 shortcut to edit the selected cell.

[{"selector":"#anim-59e13877-5eae-4157-9675-eceeb4933335 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]

Follow Excelabcd

[{"selector":"#anim-aa94f6a4-8e8f-4207-bfb0-9fb583107ceb [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(0%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}]