Reply to thread

Message: <blockquote data-quote="kasun_kbp" data-source="post: 28127603" data-attributes="member: 534657">10 Essential Excel shortcuts that can make working with data easier and more efficient. These shortcuts cover a range of tasks, from automatically filling data down a column to adding gridlines to a worksheet.1. CTRL ECTRL E makes complicated tasks easier than ever, thanks to Flash Fill. Flash Fill automatically fills data down a column based on detected patterns. Just enter how you want the data to appear, hit CTRL E, and Excel will fill the pattern down the column in a flash.<img src="https://i.ibb.co/y0WH4KQ/1.gif" alt="" class="fr-fic fr-dii fr-draggable " style="" />2. ALT =Let Excel do the math for you with this shortcut! ALT = detects data in adjacent cells and automatically sums it using the SUM function. Just select an empty cell adjacent to the data that needs to be added and press ALT =.<img src="https://i.ibb.co/PNFhqMv/2.gif" alt="" class="fr-fic fr-dii fr-draggable " style="" />3. ALT H O IIf you are unable to see your data, ALT H O I is here to help! Press ALT H O I to automatically adjust the column widths to fit the size of your data. <img src="https://i.ibb.co/j8X3nfz/3.gif" alt="" class="fr-fic fr-dii fr-draggable " style="" />4. ALT ↓If you are entering repetitive data in Excel, ALT ↓ is a must-know shortcut. The Alt ↓ shortcut displays a dropdown list of all values previously entered in the column. Now, you can simply select any value, which will automatically be entered into the active cell! <img src="https://i.ibb.co/VBm6bFn/4.gif" alt="" class="fr-fic fr-dii fr-draggable " style="" />5. CTRL `When cranking out formulas in Excel, checking each one individually in the formula bar can be tedious. Instead, try the CTRL ` shortcut! CTRL ` toggles between displaying the cells’ formulas and values in the active worksheet. <img src="https://i.ibb.co/6b7sP4W/5.gif" alt="" class="fr-fic fr-dii fr-draggable " style="" />6. CTRL ENTERDragging formulas down columns and then again across rows can be a drag. Say goodbye to the fill handle and hello to CTRL ENTER! CTRL ENTER fills the active cell’s contents into selected cells. Note: The active cell has to be in editing mode for this to work. <img src="https://i.ibb.co/h9PCw8v/6.gif" alt="" class="fr-fic fr-dii fr-draggable " style="" />7. CTRL TStart getting into the routine of using Tables with CTRL T. CTRL T converts data to an Excel Table. Tables are a powerful tool that clean up formatting, auto-fill formulas down columns, automatically expand and update linked charts when new rows are added, and more! <img src="https://i.ibb.co/8x5CFJy/7.gif" alt="" class="fr-fic fr-dii fr-draggable " style="" />8. ALT F1If you are spending too much time creating charts to visualize data, meet ALT F1. These two magical keys automatically create a bar chart using the selected data and insert it right into the active worksheet! <img src="https://i.ibb.co/TBNMqHQ/8.gif" alt="" class="fr-fic fr-dii fr-draggable " style="" />9. ALT W VGAre you team gridlines or no gridlines? If you're team no gridlines, this ones for you. The ALT W VG shortcut removes all gridlines from the active worksheet. <img src="https://i.ibb.co/p3HQXtd/9.gif" alt="" class="fr-fic fr-dii fr-draggable " style="" />10. CTRL SHIFT LLast but not least, CTRL SHIFT L. CTRL SHIFT L makes analyzing large data sets a little easier by adding the Sort&Filter toggles<img src="https://i.ibb.co/ngzZmXT/10.gif" alt="" class="fr-fic fr-dii fr-draggable " style="" /> Copied from Twitter</blockquote>

Verification: Winadiyakata thappara keeyak tibeda?

Top Bottom