Top Important Excel Shortcuts

These important excel shortcuts are the top tiers when using excel sheet. It makes your work faster. They are:

1. ALT H O I: For you to avoid messy data, fixing it manually can only delay your time. Instead, clean up messy data in seconds by selecting it and pressing ALT H O I. ALT H O I automatically adjusts the column width to the length of the data.
2. CTRL [: Finding a file can be very stressful. It is like finding a needle in a haystack. Instead of looking for the file path; open the file, navigate to the worksheet, and mapping the cell, just press CTRL [ to teleport to a cell reference. This makes your work faster.
   
3. ALT WFF: Not seeing your header when strolling a sheet can disorganize you. To select this, select the first cell containing data in the table and press ALT WFF to freeze the panes. This will make the headers remain visible when scrolling throughout the worksheet.
4. F8: This allows you to select data without the mouse. Once you press F8, it will activate extend selection mode, and then, just select the data you want to include in the selection using the arrow keys.
   
5. CTRL K: CTRL K helps you to link external data in your worksheet. It opens the insert hyperlink dialog box. From there, you can enter the address of the data you want to link and press Ok.
   
6. ALT F1: This Microsoft Excel shortcut makes it easier for you to visualize your data using a chart. Once you select the data and you want to visualize it, press ALT F1 and it will automatically create a chart.
7. CTRL ~: A lot of formulas on your sheet has probably given you enough headaches. This excel shortcut toggles between showing a cell value and formula.
8. ALT =: This helps to sum up the selected cells. Excel auto sum function automatically sums detected data

You may like this: Most Powerful Gmail app features