EXCELlence.
Hey, What's Up People?
Doing work in Excel can be boring if we don't know some 'hack' to make our excel experience better. As for today, I'm going to share about Excel trick you can try if you never do it before. You may jot it down so you can use them later :
1) Instantly select an entire table or data range
To do this you can just hit the button CTRL + A
2) Resize a column to fit content quickly
You may have data in a cell that is much shorter than, or too long to fit in, the default width of a column. Instead of trying to manually adjust the width of the column to get the right size, double-click the boundary between two column headers (eg, the line between the A and the B for the first and second columns), and the column size for the column to the left will be perfectly sized to accommodate the cell with the longest text
3) Hide/unhide worksheets.
To hide a worksheet, right-click on the tab of the worksheet (located at the bottom of the Excel workbook) and select Hide. To unhide a worksheet, right-click on any tab of the worksheet, select Unhide, then choose which sheet to unhide.
4) Instantly copy a formula to multiple rows.
Many of the formulas we use are intended to work for multiple rows of data. In that case, when a formula is added to your first row of data, that formula needs to be copied down to all rows of data. Instead of grabbing the Fill Handle (the solid green box that appears in the bottom right corner of a cell when it is selected) and dragging all the way down, it is easier and quicker to simply double-click the Fill Handle. This will work if the cells in the column to the left of the copied formulas are not empty.
5) Convert a table into a range of data.
To convert a table into a range of data, click anywhere within the table and right-click. Select Table, then Convert to Range.
To know more Excel tips to make your work easier, this video have 50 tricks and tips that will help you.
Comments
Post a Comment