Here are some useful tips in Excel:
Use the CTRL key to select multiple cells or ranges.
Use the SHIFT key to select a range of cells or ranges.
Use the ALT key to select a non-adjacent range of cells or ranges.
Use the F4 key to repeat the last action you performed.
Use the F5 key to open the Go To dialog box.
Use the F6 key to move between the active sheet, the formula bar, and the Name box.
Use the F7 key to check the spelling of your worksheet.
Use the F8 key to toggle between the insert and overwrite modes.
Use the F9 key to recalculate your worksheet.
Use the F11 key to insert a new chart.
Use the CTRL+A key to select all the cells in the worksheet.
Use the CTRL+C key to copy the selected cells or ranges.
Use the CTRL+V key to paste the copied cells or ranges.
Use the CTRL+Z key to undo the last action you performed.
Use the CTRL+Y key to redo the last action you undid.
Use the CTRL+F key to open the Find and Replace dialog box.
Use the CTRL+H key to open the Replace dialog box.
Use the CTRL+K key to insert a hyperlink.
Use the CTRL+N key to create a new workbook.
Use the CTRL+O key to open an existing workbook.
Use the CTRL+S key to save your workbook.
Use the CTRL+W key to close the active workbook.
Use the CTRL+Q key to quit Excel. I hope these tips help you become more productive in Excel!
About Author
Discover more from SURFCLOUD TECHNOLOGY
Subscribe to get the latest posts sent to your email.
